Levi Caers February 2016
Connection String for Local Network
I've got a local working connectionstring which is displayed below but I need a little change in it to make it applicable for a network.
I've tried to do it with a static ip but it didn't work. Already checked that the connection to the other device is stable.
<?xml version="1.0" encoding="utf-8" ?>
connectionString="Data Source=levi\SQLEXPRESS;Initial Catalog=sdtcapt;User ID=XXXX;Password=XXXX"
Takarii February 2016
Try using something like
connectionString="Server=192.168.1.1,1433; Network Library=DBMSSOCN;Initial Catalog=mbc;User ID=xxxx;Password=xxxxx"
This points to the specific computer running the DB on the network
1433 is the default port for SQL server, so if yours is different you will need to change it.
This is used on SQL Server 2014
Asked in February 2016
Viewed 2,976 times Voted 11 Answered 1 times
Leave an answer
Quote of the day: live life
Devs Planet © all rights reserved