May 20, 2013 at 2:13 am
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
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)
------------------------------
BUTTONS:
OK
------------------------------
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?
May 20, 2013 at 8:06 am
Please check the below link..
http://stackoverflow.com/questions/2330439/access-is-denied-when-attaching-a-database
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply