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

    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?

  • I have got answer for my question

    Please check this post

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply