Is there anyway to connect to local SQL Server database from hosted website?

Question

I create a website with a SQL Server database and put it on a host ...

I just want to know if there is a way that when I open my website on a special PC, I could connect to the PC's SQL Server database for reading and writing ...

Let me know if there is a special connection string for that !

No, there is no magical way of connecting to a SQL Server - you just need to specify the server and database in your connection string - no matter where and how you want to connect to it ... — marc_s
– marc_s, Commented Jan 21, 2015 at 6:23
You need to specify in the connection string the address of the computer serving your database. — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Jan 21, 2015 at 6:36

virender · Accepted Answer · 2015-01-21 06:51:40Z

2

You need to use server IP address and user id , password for connect to database.

Like

<add name="DefaultConnection" connectionString="Data Source=198.0.0.1;Initial Catalog=Database;user id=user1;password=[system];" providerName="System.Data.SqlClient" />

IP - 198.0.0.1 User id - user1 password - [system]

Note -

When you accessing your database from other computer , windows authentication will not work.
Set sql server authentication in sql server
Allow remote connections to sql server
Allow Sql server port into firewall

Then try.

edited Jan 21, 2015 at 6:51

answered Jan 21, 2015 at 6:42

virender

4,6465 gold badges31 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Is there anyway to connect to local SQL Server database from hosted website?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related