?
Solved

SQL Express 2008 R2 error when attaching a Ddb

Posted on 2014-07-14
12
Medium Priority
?
3,285 Views
Last Modified: 2014-07-16
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.
0
Comment
Question by:Paul Montgomery
  • 6
  • 6
12 Comments
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40195834
Are you attaching an existing SQL MDF file? Have you tried restoring it from a backup file instead?
0
 

Author Comment

by:Paul Montgomery
ID: 40196131
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.
0
 
LVL 14

Accepted Solution

by:
Russell Fox earned 2000 total points
ID: 40196142
Gotcha. Apparently there's a known bug in the Express version of SSMS. You can download just the tools for SQL Server 2012, or you can use the TSQL code to do the attaching rather than the UI:
EXEC sp_attach_db 
    @dbname = N'DbName',
    @filename1 = N'C:\somewhere\DB.mdf', 
    @filename2 = N'C:\somewhere\Log.LDF'

Open in new window

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:Paul Montgomery
ID: 40197137
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)
Properties error
0
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40197436
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.
0
 

Author Comment

by:Paul Montgomery
ID: 40197731
It's SQL Express 11.0.2100 and the Management Studio is 10.50.1600.1.
0
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40199827
What do you get if you run this on that database:
EXEC sp_helpdb

Open in new window

0
 

Author Comment

by:Paul Montgomery
ID: 40199904
Script result
0
 
LVL 14

Assisted Solution

by:Russell Fox
Russell Fox earned 2000 total points
ID: 40200062
I thought perhaps the user message was caused by a database that had an owner that was no longer active, but it looks like they're all sa. Looking back at your previous comment, "It's SQL Express 11.0.2100 and the Management Studio is 10.50.1600.1.", it's probably that you're trying to connect to SQL 2012 with SSMS 2008, and so running into forward compatibility issues. I would get the latest version of SSMS installed and see if that clears it up.
0
 

Author Comment

by:Paul Montgomery
ID: 40200345
That did it Russell. Thanks again for your help!
0
 

Author Closing Comment

by:Paul Montgomery
ID: 40200353
First class help!
0
 
LVL 14

Expert Comment

by:Russell Fox
ID: 40200502
Glad I could get you running!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question