locked
Unable to log into local sql server RRS feed

  • Question

  •  

    When I try to connect to my local sql server (2005) on my machine, I get 4064 error. I was looking at some of the other answers but not sure if that will help me. I can connect to other servers on our network but just not with my local server.
    Wednesday, October 29, 2008 6:53 PM

Answers

  • I think this is something to do with Default Database of the user.

    3 cause I can see.

    1. Default database of your login been deleted from the server.

    2. Your login has not been mapped to the default database.

    3. Or login doesn't have a default database specified.

     

    There could be other reasons as well.  Try to connect with some other login probably with sysadmin (sa) rights and check for above mentioned causes.

    Friday, October 31, 2008 7:12 AM