Skip to content
WJunction - Webmaster Forum

Please help me out with SQL

Status
Not open for further replies.
I have following connection string in my web.config file

Code:
<add name="ConnectionStringUsersdb" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\usersdb.mdf;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />
    <add name="ConnectionStringFilesdb" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\filesdb.mdf;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />

I get following database error after hosting my site at hostgator

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)

At my local computer application works perfectly file but not at hostgator :(

Do i need to do some modification in connection string?
 

1 comment

Do you have the database uploaded on the server? If it's SQL,you have to make a remote connection with your desktop's database/or with your server(but 1st you have to allow remote connections)
Also have you set up the correct TCP ports on your server?
 
Status
Not open for further replies.

About the author

1
Active Member · Joined
257
Messages
8
Reactions
18
Points

Advertise on WJunction

Reach 1000's of webmasters, hosts & affiliates. Banner & sponsored-thread slots available.

Contact us
Back
Top Bottom