locked
Login fail after intalling sql server 2005 RRS feed

  • Question

  • Hi

    I have just installed sql server 2005.

    after installing the default server name looked like this: HAGAR-3783709FC.

    so I uninstalled and reinstalled this time giving it the instance name: HAGAR.

    now I canot login with this server name and not with the previous one. nothing works.

    HELP!!!

    Wednesday, July 9, 2008 9:26 AM

Answers

  • I think i missed something

    You said instance name: HAGAR. and what is the Servername?

    You tried with Servername\HAGAR?

     

    Wednesday, July 9, 2008 10:44 AM

All replies

  •  

    and what error message you are getting?
    Wednesday, July 9, 2008 10:40 AM
  • I think i missed something

    You said instance name: HAGAR. and what is the Servername?

    You tried with Servername\HAGAR?

     

    Wednesday, July 9, 2008 10:44 AM
  • As mentioned above, if you had installed a default instance just type your Computer name. If you had installed a named instance you need to login by specifying Computer name\Instance name. If you have SA password try logging with that and see how it goes. If nothing works don't worry you still have an option in Sql Server 2005. Read through this article and see if it helps. The article briefly describes to login by starting Sql in single user mode so that members of windows admin group have admin privilege.

     

    - Deepak

    Wednesday, July 9, 2008 12:32 PM