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?