Post reply

Create User

  • July 28, 2009 at 10:24 am

    #133515

    When I setup a user, with the script below, they do not show up in the Logins. This happens each time. The only way I can get the user to show up is to manually start to create the user and then it will tell me the user already exists and then poof! the user shows up at the bottom of the Logins. Is there a trick to this?

    CREATE USER [company\jdoe] FOR LOGIN [Company\jdoe]

  • July 28, 2009 at 11:03 am

    #1031183

    After you execute the script, try refreshing the logins node in the display.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • July 28, 2009 at 11:14 am

    #1031193

    Tried that and tried refreshing the db. Still no luck.

  • July 28, 2009 at 12:24 pm

    #1031238

    Perhaps you're not actually creating the login you think that you are? You need to create the login before you create the user For the login...

    Per BOL's Create User section

    CREATE LOGIN WanidaBenshoof

    WITH PASSWORD = '8fdKJl3$nlNv3049jsKK';

    USE AdventureWorks;

    CREATE USER Wanida FOR LOGIN WanidaBenshoof

    WITH DEFAULT_SCHEMA = Marketing;

    GO

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • July 28, 2009 at 2:22 pm

    #1031320

    That worked. Thank you.

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

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