SQL Express connection string

  • Thread starter Thread starter David C
  • Start date Start date
D

David C

I have added some aspx pages to a classic asp site and all works fine in
testing but in production I am getting a Server Error in '/' Application. I
think it may be in the connection string as we have SQL 2005 in test and the
production site is using SQL 2005 Express. Below is the connection string
in the web.config for production (Express) site. Is anything wrong with
this? Thanks.

David

<connectionStrings>
<add name="KetodataConnectionString"
connectionString="Data Source=155-WEB2\SQLEXPRESS;Initial
Catalog=Keto;Integrated
Security=False;Uid=keto;Pwd=ShSN@K@lC;MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
 
Based on what error message you decide it is due to SQL Server Express?

Assume it is, you need to firstly verify if the SQL Server Express' mixed
security mode is enabled (so that you can use SQL Server login's
username/passwrod to access it). By default installation, SQL Server
2005/Express only uses Windows Integrated security.
 
Back
Top