Visual Studio 2005 SQL Server Express edition username pass_问答_开发者

Visual Studio 2005 SQL Server Express edition username pass

开发者 https://www.devze.com 2023-01-07 17:24 出处：网络

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

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

When开发者_JAVA技巧 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?

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.

Go to the File Menu and select "Connect Object Explorer..."

Install the latest SP for Express and this will add the user provisioning for Vista that will make you an administrator on the Express instance. Otherwise you'll have to do it the hard way, see Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out.

Once you fix your administrative privileges back on the instance, you can start adding SQL Logins. You are going to have to enable Mixed Authentication before these logins can be used, see Authentication Mode (SQL Server Express).