Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Enable Automatic Logins for the Database

Visual Studio 2005

As the database administrator for your team, you can enable automatic logins for all database users by using their network aliases as user names. Use of network aliases can facilitate some administrative and end-user tasks, as it bypasses the Visual SourceSafe Login dialog box. The best way to enable automatic logins is to use Visual SourceSafe Administrator, but you can also do it by setting the SSUSER and SSPWD environment variables using standard Windows methods. For more information, see Setting Database Options.

Security noteSecurity Note

Bypassing the login dialog box can compromise database security. Never use the same password for your databases and the network, especially if you choose to enable automatic logins by supplying the password using an environment variable. Remember that an environment variable can be read by any user with access to your computer.

To enable automatic logins using Visual SourceSafe Administrator:

  1. In Visual SourceSafe Administrator, on the Tools menu, click Options.

  2. In the SourceSafe Options dialog box, click the General tab.

  3. Click Use network name for automatic user log in, then click OK.

  4. Create new user names for all team members, using their network names. For example, the user name for network user MYDOMAIN\user_12 is user_12. See How to: Add User Accounts.

See Also

Community Additions

© 2015 Microsoft