Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

sqlexpress local database administrator password

I'm trying to install some .Net eCommerce projects on my local machine (windows Vista) with Webmatrix. Some of them ask for a Database administrator username and password, but I have no idea what those are.

Can anybody help me on this. See image which is a screenshot of the installation process.

Screenshot of installation process

like image 810
Daniël Tulp Avatar asked May 30 '12 12:05

Daniël Tulp


People also ask

What is the admin username used by SQL Server SQL Express and Localdb?

In your client (SQL Server Management Studio) you have to: change password for login user "sa" enable login for user "sa"

What is the default Sqlexpress sa password?

This connection is normally authenticated using SQL Server Authentication, and with the user name [sa] and default password [RPSsql12345].

What is default password for sa user?

Description. The remote instance of MS SQL / SQL Server has the default 'sa' account enabled without any password.


1 Answers

By Default the SQLEXPRESS installation uses Windows Authentication. in the management studio on the security-tab of the server properties you can select "SQL Server and Windows Authentication" ONLY THEN The 'sa' account is accepted. You probably have to set/reset the password for this account if you can't remember you entered it.

like image 118
Luuk Krijnen Avatar answered Sep 23 '22 15:09

Luuk Krijnen