Skip to main content
2 of 5
added 64 characters in body
gbn
  • 70.1k
  • 8
  • 165
  • 242

Attaching a database in SSMS without sysadmin role gives error

I am accessing my sql server 2008 r2 express server using SSMS. I have a user which has got db_owner permission for all database and all permissions in server role other than sysadmin. When this user tries to attach a database by using ssms(by right clicking on database node and then clicking on attach) the error message comes like

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:


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

------------------------------

If the same user uses t-sql command such as below to attach database then it works fine.

USE [master]
GO
CREATE DATABASE [hgnx] ON 
( FILENAME = N'E:\db\hgnx.mdf' ),
( FILENAME = N'E:\db\hgnx_log.ldf' )
FOR ATTACH
GO

So what is the error causing me while attaching database in SSMS? How to solve it?

IT researcher
  • 3.1k
  • 15
  • 57
  • 82