none
For new Login unable to access Database

    שאלה

  • As a dba i have created Login and it is able to get in to server and not able to accesss the Specific DB'S and getting below error

    messagesTITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Create failed for User 'maddy'.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2796.0+((KJ_SP1_QFE-CU).111209-1117+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476

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

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

    User, group, or role 'Maddy' already exists in the current database. (Microsoft SQL Server, Error: 15023)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2796&EvtSrc=MSSQLServer&EvtID=15023&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    יום שישי 02 מרץ 2012 10:23

תשובות

כל התגובות