Geek asks and answers

The administrator password for the local sqlexpress database

I am trying to install some .Net e-commerce projects on my local computer (Windows Vista) using Webmatrix. Some of them ask for the database administrator username and password, but I have no idea what it is.

Can anyone help me on this. See Image, which is a screenshot of the installation process.

Screenshots of installation process

+5
source share
3 answers

SQLEXPRESS Windows. "" "SQL Server Windows Authentication", "sa" . , / reset , , .

+9

, , :

  • Sql Server Management Studio Administartor

  • . \SQLEXPRESS, Windows

  • "" → "" → "sa" Ok

  • WebMatrix, .

+1

Starting with SQL 2005, Express is installed with Windows Authentication. In the configuration (management studio, connecting to the server and selecting database properties), you can activate sql internal authentication, then (by default, deactivated, user without password).

So, if you cannot connect to it, you may need to activate it and set a password for user sa.

0
source

More articles:


All Articles