3

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

Roy
  • 2,313
  • 6
  • 37
  • 46
  • Possible duplicate of [Attaching a database in SSMS gives error](https://dba.stackexchange.com/q/42562/5203) – GSerg Sep 01 '19 at 10:31

3 Answers3

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

C-Pound Guru
  • 15,967
  • 6
  • 46
  • 67
  • I'm using Windows Authentication. Yeah, I saw the post before. And that doesn't solve the problem... – Roy Sep 15 '09 at 02:47
  • The script above give me a error message: CREATE DATABASE permission denied in database 'master'. – Roy Sep 15 '09 at 02:53
1

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.

MicMit
  • 2,372
  • 5
  • 28
  • 41
0

Had same issue. it appears that the error raised because i've connect to SQL SERVER 2012 INSTANCE with Sql Server 2008 R2 management studio. hope it help someone else too

arik
  • 338
  • 1
  • 16