sqlsql-server-2005visual-studio-2005sql-server-2005-express

Visual Studio 2005 SQL Server Express edition username pass

Visual Studio 2005 I connect with SQL Server Express edition with SQL Server Management Studio Express using Windows authentication.

When I installed Visual Studio 2005 I didn't get asked for SQL Server Express edition user name or password. How can I connect without Windows authentication?

Solution

  • You will have to:

  • connect through Management Studio Express with windows authentication
  • in the Object Explorer pane, expand the Security folder
  • Right click on the Logins folder and choose New Login.

    You can then configure a new user, password, and grant privileges.