SQL Express connection string

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>
 
N

Norman Yuan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connecting vs 2005 to remote SQL server 2000 3
Connection string not working 1
problem with web.config when using roles 2
asp.net and conecting to sql server2005 2
How can ASPNET access the Northwind database 1
Opening connection to db 2
connection string in Web.Config 7
URGENT: ConnectionString for SQLServer db 4

Top