sql - Connection String for Local Network -


i've got local working connectionstring displayed below need little change in make applicable network. i've tried static ip didn't work. checked connection other device stable.

<?xml version="1.0" encoding="utf-8" ?> <configuration> <configsections> </configsections> <connectionstrings>     <add name="beurstd.properties.settings.sdtcaptconnectionstring"         connectionstring="data source=levi\sqlexpress;initial catalog=sdtcapt;user id=xxxx;password=xxxx"         providername="system.data.sqlclient" /> </connectionstrings> </configuration> 

try using like

connectionstring="server=192.168.1.1,1433; network library=dbmssocn;initial catalog=mbc;user id=xxxx;password=xxxxx" 

this points specific computer running db on network

1433 default port sql server, if yours different need change it.

this used on sql server 2014


Comments

Popular posts from this blog

javascript - jQuery: Add class depending on URL in the best way -

caching - How to check if a url path exists in the service worker cache -

Redirect to a HTTPS version using .htaccess -