sqlexpress local database administrator password

.net sql-server installation webmatrix
Daniël Tulp picture Daniël Tulp · May 30, 2012 · Viewed 69.9k times · Source

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

Answer

Luuk Krijnen picture Luuk Krijnen · May 30, 2012

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.

Related questions

how to insert datetime into the SQL Database table?

How can I insert datetime into the SQL Database table ? Is there a way to insert this query through the insert command in C# / .NET?

Read More
C# Equivalent of SQL Server DataTypes

For the following SQL Server datatypes, what would be the corresponding datatype in C#? Exact Numerics bigint numeric bit smallint decimal smallmoney int tinyint money Approximate Numerics float real Date and Time date datetimeoffset datetime2 smalldatetime datetime time Character Strings …

Read More
How can I solve a connection pool problem between ASP.NET and SQL Server?

The last few days we see this error message in our website too much: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and …

Read More