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.
Paul MontgomeryBusiness IT ProfessionalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
Are you attaching an existing SQL MDF file? Have you tried restoring it from a backup file instead?
0
Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
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
Russell FoxDatabase DeveloperCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
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
Russell FoxDatabase DeveloperCommented:
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
Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
It's SQL Express 11.0.2100 and the Management Studio is 10.50.1600.1.
0
Russell FoxDatabase DeveloperCommented:
What do you get if you run this on that database:
EXEC sp_helpdb

Open in new window

0
Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
Script result
0
Russell FoxDatabase DeveloperCommented:
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
Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
That did it Russell. Thanks again for your help!
0
Paul MontgomeryBusiness IT ProfessionalAuthor Commented:
First class help!
0
Russell FoxDatabase DeveloperCommented:
Glad I could get you running!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.