Post reply

cant create logins in SQL

  • May 9, 2012 at 12:36 pm

    #256281

    Hey,

    I have an sql instance created for myself where i am the admin. For some reason i am unable to log into the 'sa' acount using 'sa' as the default password. Nor am i able to change the sa pwd.

    What can i do here. Please help. i am unable to create new logins as well.

    Thanks!

    Sonia

  • May 9, 2012 at 12:40 pm

    #1485256

    What did you set the sa password to during installation, did you add any windows logins during install?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 9, 2012 at 12:43 pm

    #1485258

    Check your sql server authentication mode windows or mixed mode?

  • May 9, 2012 at 1:12 pm

    #1485278

    this can help:

    http://beyondrelational.com/modules/2/blogs/115/posts/11143/how-to-access-a-newly-installed-sql-server-2008-r2-instance-if-you-do-not-know-the-login-and-passwor.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 9, 2012 at 1:24 pm

    #1485294

    I added the windows login.

  • May 9, 2012 at 1:25 pm

    #1485297

    The authentication mode is sql server authentication.

    I tried watever is given in the link. Doens't work for me. 🙁

  • May 9, 2012 at 2:53 pm

    #1485359

    soniaj (5/9/2012)

    I added the windows login.

    Which windows login?

    What did you set the as password to during install?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 9, 2012 at 3:24 pm

    #1485376

    There is no default password of 'sa'. You had to set a password.

    Jared
    CE - Microsoft

  • May 9, 2012 at 3:36 pm

    #1485379

    Oh really! I haven't set any password during installation. It worked fine until i reinstalled.

    Any ideas?

    Sonia

  • May 9, 2012 at 3:37 pm

    #1485381

    Perry Whittle (5/9/2012)

    soniaj (5/9/2012)

    I added the windows login.

    Which windows login?

    What did you set the as password to during install?

    By login i meant that i had set it at windows authentication mode. No pwd.

    Sonia

  • May 9, 2012 at 5:09 pm

    #1485397

    The sa account will always have a password. If you selected mixed mode auth during instance install then you would have been forced to create a password for sa. That's the one you need.


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • May 10, 2012 at 12:29 am

    #1485480

    Sounds like you're going to need single user mode to sort this one 😉

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 12 posts - 1 through 11 (of 11 total)

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