How to connect sql server in server system from local system

suman goud

am working on intranet,

in my system no sql server ,

in server we have sql server, i want to bind table to grid from server to my local system

i used following connection string to connect server

providerName="System.Data.SqlClient" />

iam getting error as ""a network specified error......

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
In addition to other answers, you have specified user Id and password and have also said Integrated Security=True; which means Windows Authentication, which is contradictory. If you are using windows authentication remove user Id and password altogether otherwise make Integrated Security=False or remote that attribute altogether.
I believe, Integrated Security=True takes precedence over User Id + Password, but I might be wrong.
ketan borsdiya10y ago
HI Suman,
1. Check in SQL Server Configuration Manager there are below protocol enable?
- Shared Memory
- Named Pipes
- TCP/IP
2. Write below query to confirm Data Source
SELECT @@ServerName
3. Add SQL Port 1433 in firewall rule
Bikesh Srivastava10y ago
You need to pass proper IP of SQL server..
Tapan Patel10y ago
I think it is rights issue.Here is how you can fix.
Assuming you have provided valid server name.

Are you able to login to that several using RDP,

Also, are you a authentic or authorized SQL user?

Check for firewall settings on both systems.

Check and try again .Let me know if you still have an issue.

Please mark it as answer if it resolves the issue.