Unable to attach database with sql server management

robbaralla · April 22nd, 2010, 07:39 PM

Hi there,

I tried following the instructions on p692 to attach my dataBase to sql server but without succes.
Step 5 is where it goes wrong, the error I get is :
"Cannot show requested dialog.
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)"

I have been looking at forums to solve this, and i tried to:
- run as administrator, as also Imar suggests
- turn of the UAC
- type in a query to attch the db files.
- restart sql express
- uncheck collation
I also checked the Modify permissions, but it already seems to go wrong way before getting to any folder or file.

For most users either one of these "solutions" seemed to do the trick, but not for me.

I run sql server 2008 express on vista home premium. and I checked that sql server is actually running.

Does anybody have a solution to this?

Thanks in advance, Robin

Imar · April 23rd, 2010, 11:17 AM

Hi there,

Are you sure you are an Administrator that in turn has SQL access? Did you see this:

https://connect.microsoft.com/SQLSer...?wa=wsignin1.0

Cheers,

Imar

robbaralla · April 23rd, 2010, 12:40 PM

Hi Imar,

Thanks for your response. I did see that post and tried it, also that without succes.
This is what I did:

Code:

exec sp_attach_db @dbname =  'DBName',@filename1='C:\Data\SqlServer\ASPNETDB.mdf',@filename2='C:\Data\SqlServer\ASPNETDB.mdf_log.ldf'

this then gave the next error:
Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database 'master'.

All my attempts to get access as an administrator to the 'master' folder were denied, even though I ran the program as administrator. In sql management studio, in the security folder, I tried to make a new login account; administrator, that works, but I can't map the administrator to the master folder, permission is denied. The only account that does have the permissions is the sa account, and I can't remember that I ever registered as sa. I found some posts on how to reset the password, but for that you first have to get in via another account, which in my case does not exist.

So I uninstalled sql server 2008 right now I'm downloading sql server 2008 again, and it insisted on me making a password for the sa account.
I can't remember having done that the first time i installed the program.
So hopefully I'll be able to sign in with the sa account that has all the permissions. (and thus also change permissions for the administrator account.)
so let's see

I'll let you know.
best regards and congratulations with your new book, Robin

Imar · April 23rd, 2010, 12:44 PM

Quote:

and congratulations with your new book,

Thank you, and good luck with SQL 2008. Hope it works out this time.

Cheers,

Imar

robbaralla · April 23rd, 2010, 12:54 PM

Hi again Imar,

I just finished installing sql server 2008 again, and this time it worked perfectly, the attach dialogue opened straight away.
The good part is that this time my Administrator account has been granted a sysadmin server role, without even touching the settings, or using the sa account with password!?

Well, I guess even after braking my brain over this for 8 hrs I can't complain because it is afterall the free express version....

Robin