Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
McGurk
Starting Member
21 Posts |
 Posted - 2009-10-06 : 13:53:37
|
I created an application using the built-in login control. It created a connection string that works fine on my development machine but I cannot get it to work correctly on the production web server. My connection string: add name="ASPNETDBConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=true" providerName="System.Data.SqlClient"/> I have been researching this for 3 days and have read a lot about this error but nothing has helped. (I went thru the steps on at this link: http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx) The error I get is: quote:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Does anyone have any ideas on what might be the problem?McGurkAll that is gold does not glitter, not all those who wander are lost... JRR Tolkien |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-10-06 : 17:07:37
|
| did you upload the app_data folder to your remote web server ? |
 |
|
|
McGurk
Starting Member
21 Posts |
Posted - 2009-10-06 : 17:19:53
|
| Thanks for your reply. Yes, I have the folder and can see the .mdf file in it.McGurkAll that is gold does not glitter, not all those who wander are lost... JRR Tolkien |
|
|
|
|
|
|
SQL Server Express 2008 connection error