Home Dashboard Directory Help
Search

Attaching a database in SSMS without sysadmin role gives error by IT researcher


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 787236
Opened: 5/20/2013 2:28:02 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description




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?

SSMS version and details

Microsoft SQL Server Management Studio                        10.50.4000.0
Microsoft Data Access Components (MDAC)                        3.85.1132
Microsoft MSXML                        2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer                        6.0.2900.5512
Microsoft .NET Framework                        2.0.50727.3053
Operating System                        5.1.2600
Details
Sign in to post a comment.
Posted by Microsoft on 5/22/2013 at 4:39 PM
Hello researcher. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.