How to change the default database of a login (Enterprise Manager)

To change the default database of a login

1. Expand a server group; then expand a server.
2. Expand Security; then click Logins.
3. In the details pane, right-click the login to modify, and then click Properties.
4. In Database, on the General tab, click the new default database to which the login is connected after logging into Microsoft® SQL Server™.

See Also

Modifying Logins