Connecting to a remote database from a localhost computer using Sql Server and MVC

Question

I have build an MVC application and it is working very well. I have created a model in MVC project to access the database from local Microsoft SQL Server 2014 and the model is generated and working properly.

Now I have to host my project entire solution to the htdocs folder and uploaded my database as well. On hosting site all my stuff is working properly but the problem is my database is not working. I do not know how to configure it with my website.

I think there is a connection string problem in web.config file, due to which the connection is not established between connection string and the database.

 <connectionStrings>
<add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=StarBuy;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />
<add name="StarBuyEntities1" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=StarBuy;user id=hidden;password=hidden;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

Is there a method to import the database from the hosting website to local Microsoft SQL Server 2014, so that I can update the Model and update the new generated connection string in the web.config file?

Your thoughts will be very appreciated.

Probably you need to include user id=hidden;password=hidden in DefaultConnection string. Ensure your DefaultConnection working properly then, include any exception if you have. — Tetsuya Yamamoto
– Tetsuya Yamamoto, Commented Oct 17, 2016 at 6:28

Deepak Jha · Accepted Answer · 2016-10-17 06:28:39Z

1

Use this connection strings.

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=StarBuy; user id=**;password=**;" providerName="System.Data.SqlClient" />
    <add name="StarBuyEntities1" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=StarBuy;user id=hidden;password=hidden;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />  
</connectionStrings>

answered Oct 17, 2016 at 6:28

Deepak Jha

3794 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

waqas adil Over a year ago

Error. An error occurred while processing your request.

Tetsuya Yamamoto Over a year ago

Have you set <customErrors mode="Off" /> in web.config? Turn it on by <customErrors mode="On" />, then show the error message.

Pravin Kr. Mishra · Accepted Answer · 2016-10-17 09:39:15Z

1

In Sql Server '.' is used to connect local. Now Your DB is in remote server.

So instead of . symbol use Server name

For example- server name is '192.168.1.1\SERVER02'

 <add name="DefaulConnection" connectionString="Data Source=192.168.1.1\SERVER02;Initial Catalog=DATABASE_NAME;Persist Security Info=true;User ID=USER_NAME;Password=PASSWORD" providerName="System.Data.SqlClient" />

Just try it will work.

answered Oct 17, 2016 at 9:39

Pravin Kr. Mishra

113 bronze badges

Comments

Jibin Balachandran · Accepted Answer · 2016-10-17 08:30:04Z

Replace the source from . to the proper database server name. i.e youripaddress\SQL2014 or whatever is applicable in your case.

In my case I can access it as JIBIN/SQL2014 or ipaddress/SQL2014

<connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=JIBIN/SQL2014;Initial Catalog=StarBuy; user id=**;password=**;" providerName="System.Data.SqlClient" />
    <add name="StarBuyEntities1" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=JIBIN/SQL2014;initial catalog=StarBuy;user id=hidden;password=hidden;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />  
</connectionStrings>

Or else you can use your ip to access your database.

Faisal · Accepted Answer · 2016-10-17 09:35:07Z

0

The dot (.) for server name can be used only when the Database server is the same as the application server. Use the correct database server name/ip instead of the (dot). You should find the connection string in the Hosting control panel if you are using any services like Plesk to host your application.

answered Oct 17, 2016 at 9:35

Faisal

1632 silver badges12 bronze badges

Collectives™ on Stack Overflow

Connecting to a remote database from a localhost computer using Sql Server and MVC

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related