Post reply

how to add the windows login user as a memeber of sysadmin to SQL, so I can log into the SQL using windows authentication

  • February 21, 2009 at 4:20 am

    #201473

    Hi guys,

    My machine name (using Windows Vista) is John, the SQL server name is John-PC. In this morning, I logged into the SQL(2005) on the machine using the Windows Authentication, went to the Server Role folder under the Security, right-clicked the sysadmin, selected the Property, and then deleted the member "John-PC\John". After then when I tried to re-login to the SQL, I failed, and I do not know the default password for the sa user if I use the SQL Server Authentication. So is there anyone who knows how to add the Windows login user(John) to the SQL. At the moment, "john-PC\John" is the only user on the SQL, so that I cannot get into the SQL at all. And do I have to re-install the SQL? I hope that is not the case.

    If is there anyone who knows the solution, please, please, please give me a hint.

    Thanks in advance

  • February 21, 2009 at 5:05 am

    #948141

    if you know the administrator password when you set up the machine, you can log in as that:

    at the login screen which lists all the users, hit control-alt-delete twice...this will bring up the login dialog...put in administrator and his password.

    - or -

    you can simply log in as another person... use a different user or add a new one: right click on my computer, click manage, find Users and groups and add a user. make sure that user is in the "adminstrators" group. log out and then log in as that new user.

    after any of the steps above, which is just to get a different administrator to log in, log into SQL server and add yourself back in.

    while you are there, assigned a known password to the sa logina s well.

    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!

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

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