<div>
Above solution might give an error. <br />
Try:<br />
Use just the IP address and not the instance name (177.16.177.341)<br />
Also make sure the &quot;SQL Agent&quot; is running on the box you're trying to connect.
</div>


Above solution might give an error.
Try:
Use just the IP address and not the instance name (177.16.177.341)
Also make sure the "SQL Agent" is running on the box you're trying to connect.

<div>
I think this may have solved it. (I had the wrong slash). I have to redeploy DBs to test it - I will let you know soon if it fixed it- thanks
</div>


I think this may have solved it. (I had the wrong slash). I have to redeploy DBs to test it - I will let you know soon if it fixed it- thanks

<div>
<div class="content wysiwyg-content">
I have an application that is used on 2 computers: <br />
appComputer (177.16.177.340) &amp;&nbsp;devComputer (177.16.177.341). <br />
I use a file named AppSettings.xml to set the connection string.<br />
The app computer only has 1 database instance so I used the IP address:<br />
&lt;ConStringX&gt;Database=Clien<wbr />ts; Server=177.16.177.340;Uid=<wbr />This;Pwd=T<wbr />hat;&lt;/ConS<wbr />tringX&gt;<br />
and it works great. <br />
On the DevComputer I use the computer name and the instance name: <br />
&lt;ConStringX&gt;Database=Clien<wbr />ts; Server=DevComputer\Demo;Ui<wbr />d=This;Pwd<wbr />=That;&lt;/Co<wbr />nStringX&gt;<br />
This works as long as I am running the application on the DevComputer.<br />
<br />
I &nbsp;have to be able to run the application from a different server pointing back to where the DB is located.<br />
So how do I change the connection string to use the IP address (177.16.177.341) and the instance name (Demo)<br />
<br />
Thanks
</div>
</div>


I have an application that is used on 2 computers: 
appComputer (177.16.177.340) & devComputer (177.16.177.341). 
I use a file named AppSettings.xml to set the connection string.
The app computer only has 1 database instance so I used the IP address:
<ConStringX>Database=Clients; Server=177.16.177.340;Uid=This;Pwd=That;</ConStringX>
and it works great. 
On the DevComputer I use the computer name and the instance name: 
<ConStringX>Database=Clients; Server=DevComputer\Demo;Uid=This;Pwd=That;</ConStringX>
This works as long as I am running the application on the DevComputer.

I  have to be able to run the application from a different server pointing back to where the DB is located.
So how do I change the connection string to use the IP address (177.16.177.341) and the instance name (Demo)

Thanks

DB Connection string using an IP address and DB instance name

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.