Post reply

Connection Failed

  • December 6, 2004 at 8:55 am

    #91693

    Hello,

    I need help. I'm getting a connection failed, check SQL server configuration properties error when trying to log on to the db server. But when I try to get the SQL server configuration properties it gives me another error which says "Can't open default user database. Login failed.

    Plesae help, Ayisat


    Ayisat Idris

  • December 6, 2004 at 9:51 am

    #532688

    Can't open default user database. Login failed

    For this error, check the default database to which the login has been assigned and make sure that your login has access to that database. Or you can also change your default database to master but this is not a good practice.

  • December 6, 2004 at 9:57 am

    #532689

    Thanks for the reply. I can't get to the default database. I can't log on. How do I change the default database? I have a database on the server I can change it too but I have never done that before.


    Ayisat Idris

  • December 7, 2004 at 10:05 am

    #532866 

    You can execute the following procedure for your own login. You need sysadmin or security admin privilege to execute this procedure for other users.
    exec sp_defaultdb loginname, databasename
    e.g. for login victoria and database test, 
    EXEC sp_defaultdb 'Victoria', 'pubs'

  • December 7, 2004 at 10:34 am

    #532878

    Thank You for your help. I really appreciate it.


    Ayisat Idris

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

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