how to connect remotely sql server database .
how to connect remotely sql server database . and it accessible to any computer through lan .
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manish Kumar ChoudharyPosted Jan 21, 2015, 6:57 AM
Actually what I suggest is SQL Server Authentication Mode I never try windows Authentication.
Khargesh RajputPosted Jan 21, 2015, 6:53 AM
Manish
I have tried like you suggest but my sql is in windows authentication mode
so i was not able to connect using ip address
Khargesh RajputPosted Jan 21, 2015, 6:48 AM
I have already faced this problem since last 3 days and solved today. and my sql is accessible to other computers in windows authentication mode
Manish Kumar ChoudharyPosted Jan 21, 2015, 6:21 AM
Change Data Source=192.168.0.2; to your ip address.
shyam mahanwarPosted Jan 21, 2015, 6:13 AM
Khargesh RajputPosted Jan 21, 2015, 5:37 AM
https://msdn.microsoft.com/en-us/library/ms345343.aspx