SQL Server 2008 Express failed to attach mdf file

Question

Here is the message. What's wrong with it? Is it a installtion problem?

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

---

ADDITIONAL INFORMATION:

Parameter name: nColIndex Actual value was -1. (Microsoft.SqlServer.GridControl)

---

BUTTONS:

OK

Answer 1

Are you trying to attach the mdf using SQL Authentication, or Windows Authentication? If using SQL Auth, you might try Windows Auth instead.

You might also want to check out this MSDN forum post, or this post which suggests using the single file version of database attach:

USE master;
GO
EXEC sp_attach_single_file_db @dbname = 'AdventureWorks',  @physname = N'f:\dataAdventureWorks_Data.mdf';

Edit: When running this script, you gotta be logged in as a user with at least dbcreator rights. You may also try CREATE DATABASE FOR ATTACH as shown at this blog post

Answer 2

Any other suggestions? Thanks in advance!

Answer 3

I prefer Windows authentication, and had the same error with SQL Server Standard Edition because my Windows authentication login didn't have enough privileges ( was only 'public' role ) . So logging as "sa" and adding "sysadmin" role for my Windows account login solved the problem.