how to connect remotely sql server database .

Question

how to connect remotely sql server database . and it accessible to any computer through lan .

Manish Kumar Choudhary · Answer

Hi Khargesh Rajput , Actually what I suggest is SQL Server Authentication Mode I never try windows Authentication.

Manish Kumar Choudhary · Answer

use 192.168.0.2 ; Initial Catalog= ; User Id= ; password= " name="ManishCS" providerName="System.Data.SqlClient" /> Change Data Source= 192.168.0.2 ; to your ip address.

Khargesh Rajput · Answer

follow steps in below link https://msdn.microsoft.com/en-us/library/ms345343.aspx

Khargesh Rajput · Answer

Hi 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 Rajput · Answer

check step 4 in given link IPAll by choosing ipall your db is accessible for all computers. 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

shyam mahanwar · Answer

Thanx for reply ... i want to connect more than 10 computers and all computer are accessing same database simultaneously through lan . is it possible . .so suggest me if u have any better idea for this condition

how to connect remotely sql server database .

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)