accessing sql server database form another computer

Rinku Dhadse

10y1.2k

hello sir/madam,

I am developing windows desktop Application, i want to run my application on all computers connected in LAN through Router but here i want to access single Sql server database which are on single computer.. how i access database from another computer so that my application run well on all Computers... please suggest me...

15 Replies

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

Rajeev Punhani10y ago
Hi Rinku,

The link i shared shows how you can configure your sql server to be accessed from remote.Please try the same .It has been described very clearly step by step with snap shots so i shared you that link.Please skip the step in which it has been told "Connecting to a remote SQL Server instance with ApexSQL tools".
Once you configure you can access database through IP remotely.

If the above solution is helpful then,accept the answer.
Rinku Dhadse10y ago
@Rajeev sir,
whatever link you have given i am going through but there is a concept of ApexSQL tools but i didn't want to use this because it is not available to me at this time so that suggest me another solution..
Vipan Sharma10y ago
Re-install SQL Server and install all features during installation process.
Rinku Dhadse10y ago
i m trying all but still not getting solution.. i think something is missing... please suggest me proper solution
Rajeev Punhani10y ago
Hi Rinku,
Please follow the below link steps
http://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/
If the above solution is helpful then,accept the answer.
Rinku Dhadse10y ago
In My System there is Sql server browser service is already running but Still its not Working i don't know why..?
Joginder Banger10y ago
Hi Rinku Dhadse,

I have faced this type of problem before go ahead please check your "sql server browser" service is running or not. When we install sql server should be checked I think is disabled. Please run this service . if you faced any problem ping me.
Rinku Dhadse10y ago
Again i get Same Problem i.e database not get accessed in another system.. please suggest me..
Vipan Sharma10y ago
Kindly check below link.

https://technet.microsoft.com/en-us/library/hh231672%28v=sql.110%29.aspx

https://technet.microsoft.com/en-us/library/ms165718%28v=sql.105%29.aspx

I'm using same system. It will work for me.
Still facing same issue. Let me know. SO I will provide you full help.
Rinku Dhadse10y ago
Hello Sir,
Is there Problem in Integrated Security=True in Connection String because i have search on internet it will treat as window Authentication but for accessing database from Another System it Should be Sql Server Authentication............. Is it right or Wrong..???
Rinku Dhadse10y ago
yes sir... there are 5 to 6 computers connected in LAN through Router..
Vipan Sharma10y ago
Is all system on LAN ?
Rinku Dhadse10y ago
hello sir..
my database connection String is

Data Source=192.168.1.52;Initial Catalog=Project;MultipleActiveResultSets=True;Integrated Security=True;User ID=sa;Password=rinku@15;

but still it is not working..
Vipan Sharma10y ago
Use Static IP for your sql server system and enable TCP/IP in sql server setting.
Pradeep Sahoo10y ago
put the proper connection string where your database is present