How to connect to SQL SERVER 2008 from labview

[RBCHAVAN_77]

We have installed a SQL server 2008 in the local PC and through DSN we were able to connect to the database on the same PC . Now we have loaded SQL server 2008 in another PC but in same network but we are not able connect to the database. we can do it with connnectiong string?

[smercurio_fc]

Have you verified the DSN works? (I'm assuming you changed it to point to the other computer).

Did you configure SQL Server to allow connections of the type you are attempting? This is done via the SQL Server Configuration Manager.

[RBCHAVAN_77]

Thanks for your reply, 

We verified through DSN it works, we are able to connect to database by DSN.

But the issue is for connecting it to database we need to dynamically obtain the IP by choosing the Obtain the IP address automatically in TCP/IP Properties.

Whereas all the other devices connected to the PC are having static IP of 192.168.127.xxx from which we are getting the data. Also the PC IP address is 192.168.127.001 which is connected to the devices with a LAN switch to acquire the data from these devices.

Now i can either communicate with the devices using static IP address 192.168.127.1 or connect to database using dynamic address. 

A separate LAN port will solve or is there solution for this issue?

[nyc_(is_out_of_here)]

You are confusing DSN = Data Source Name and DNS = Domain Name Service.

The connection string to use can be found at http://connectionstrings.com/sql-server-2008

That was the question that was asked.