How to connect sql server in server system from local system

Question

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......

Tapan Patel · Answer

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.

Nitin Sontakke · Answer

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 borsdiya · Answer

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 Srivastava · Answer

You need to pass proper IP of SQL server..