accessing sql server database form another computer

Question

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

Rajeev Punhani · Answer

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

@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 Sharma · Answer

Re-install SQL Server and install all features during installation process.

Rinku Dhadse · Answer

i m trying all but still not getting solution.. i think something is missing... please suggest me proper solution

Rajeev Punhani · Answer

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

In My System there is Sql server browser service is already running but Still its not Working i don't know why..?

Joginder Banger · Answer

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

Again i get Same Problem i.e database not get accessed in another system.. please suggest me..

Vipan Sharma · Answer

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

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

yes sir... there are 5 to 6 computers connected in LAN through Router..

Vipan Sharma · Answer

Is all system on LAN ?

Rinku Dhadse · Answer

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

Use Static IP for your sql server system and enable TCP/IP in sql server setting.

Pradeep Sahoo · Answer

put the proper connection string where your database is present