Link to home
Start Free TrialLog in
Avatar of Paul Montgomery
Paul MontgomeryFlag for United States of America

asked on

SQL Express 2008 R2 error when attaching a Ddb

I just installed SQL Server Express 2008 R2 along with Management Studio. I am trying to attach a database and get the error Cannot show requested dialog. Parameter name: nColIndex Actual value was -1. (Microsoft SqlServer.GridControl).
I researched this and tried to run the suggested scripts with no luck. In addition if I try to look at properties of any of the existing databases I get Cannot read property User Access. This property is not available on SQL Server 7.0.
I have tried both SQL and user authentication with the same results.
I'm not sure what to try next.
Avatar of Russell Fox
Russell Fox
Flag of United States of America image

Are you attaching an existing SQL MDF file? Have you tried restoring it from a backup file instead?
Avatar of Paul Montgomery

ASKER

I am attempting to attach an existing MDF file but I can't even get to that point. As soon as I right click the Databases folder and select attach I get that error. Plus there must be something else going on due to the fact I can even view properties on any of the existing databases without getting that second error I mentioned in the OP.
ASKER CERTIFIED SOLUTION
Avatar of Russell Fox
Russell Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Russell. I actually tried that script earlier and it didn't work (errors). Tried it this time and it did work!
Thanks for your help on this.
I'm still getting an error when I try to right click -> Properties on any of the databases. I still get this error...
Cannot read property User Access. This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo)
User generated image
Ah, that could be the problem - is your server version really "SQL Server 7.0"? The newer Mgt Studio is probably expecting a more recent version of the engine to talk to.
It's SQL Express 11.0.2100 and the Management Studio is 10.50.1600.1.
What do you get if you run this on that database:
EXEC sp_helpdb

Open in new window

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That did it Russell. Thanks again for your help!
First class help!
Glad I could get you running!