From the Enterprise Manager, open Security, then Logins. Right-click your user name and select Properties. At the bottom, you will see a combo for the default database. Change this.


>Hi All:
> I am not able to connect to my sql server. When I try to establish the connection, I get this error. 'A connection could not be establish to Acme_Whse(Sql Server). Cannot open user defalult database ''. Using master database instead. Please verify Sql Server is running and check your registration properties.
> Please note that Sql Server is in running mode.
>
>How can I fix this situation?
>Thanks
>MA

Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com