Deploy .net mvc site on shared hosting

Question

Connection String at my shared hosting look like: "Data Source=SQL5004.Smarterasp.net;Initial Catalog=DB_9A9FD8_steamfish;User Id=DB_9A9FD8_steamfish_admin;Password=YOUR_DB_PASSWORD;

In my Web.config i have connections section:

<connectionStrings>
    <add name="DefaultConnections" connectionString="Data Source=SQL5004.Smarterasp.net;Initial Catalog=DB_9A9FD8_steamfish;User Id=DB_9A9FD8_steamfish_admin;Password=YOUR_DB_PASSWORD" providerName="System.Data.SqlClient"/>
    <add name="Entities" connectionString="metadata=res://*/Models.BaseModel.csdl|
         res://*/Models.BaseModel.ssdl|
         res://*/Models.BaseModel.msl;
         provider=System.Data.SqlClient;
         provider connection string=&quot;Data Source=SQL5004.Smarterasp.net;Initial Catalog=DB_9A9FD8_steamfish;User Id=DB_9A9FD8_steamfish_admin;Password=YOUR_DB_PASSWORD&quot;"
  providerName="System.Data.EntityClient" />
  </connectionStrings>

P.S. YOUR_DB_PASSWORD replaced on my password

Why i have error: provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I solved the problem. I recompilier my project whith new settongs.

i am using smarterasp and your i had no problem with connection string. you should check your app and connection string. — DarthVader, Jul 26 '13 at 20:31
may be `provider connection string="` this part? in entities — DarthVader, Jul 26 '13 at 20:38

score 0 · Answer 1 · edited May 23 '17 at 10:32

0

You may check out these questions:

error: 26 - Error Locating Server/Instance Specified. (Can't connect to my local Db From my host server)

and

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Most of them suggest you check your 'Data Source=SQL5004.Smarterasp.net' part again.

edited May 23 '17 at 10:32

Community

1
1

answered Jul 26 '13 at 20:26

Farshid

5,134
9
59
87

Deploy .net mvc site on shared hosting

1 Answers1