Post reply

Error in creating new user login

  • July 21, 2010 at 12:42 am

    #142053

    Hi,

    I'm trying to create a new Windows authentication user login.

    I'm getting an error while doing the user mapping.

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

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&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)

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

    SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Microsoft SQL Server, Error: 1934)

    only for a particular Database I'm not able to give permission. other databases I'm able to give.

    What could be the reason?

    Thanks,

    Regards,

    Ami

  • July 21, 2010 at 12:57 am

    #1195984

    [p]Check whether the same login exist in that database under security->Users.[/p]

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • July 21, 2010 at 1:30 am

    #1195993

    yes it exists.

    and I'm able to give permissions for other DBs. But not to a particular Database

    -ami

  • July 21, 2010 at 1:39 am

    #1195996

    [p]Delete there and now create the login and give mapping.[/p]

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • July 21, 2010 at 4:49 am

    #1196052

    Sorry,

    I think I have not explained you clearly.

    I have the same username in the Servername-->Security.

    I'm able to map to other Dbs in the same server. but not to a particular DB and getting that error message.

    Thanks

    -Ami

  • July 21, 2010 at 5:04 am

    #1196059

    [p]Go to that particular DB ->Security->Users, delete the user login.[/p][p]Now go to Server name ->Security->Logins-> right click on the login -> properties -> map it to the database that you wanted to.[/p][p] I hope it ll solve your problem.[/p]

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

Viewing 6 posts - 1 through 5 (of 5 total)

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