Hi all ,
I have two servers in the same domain name ,
I installed a WebService on IIS one server,, the webservice read data from sql server 2008 database stored on another server ,
I had tried a lot of connection string and all of them does not work
as I said before the two servers are on the same domain ,
please could any one help me and give me the connection string how to read data stored on database found on a server ,from another server , and the two servers are on the same domain
There can be many reasons for the connection not to work.
Is the SQL Server open for incoming connections?
What are the error message you get?
Is the server open for SQL Security or only Windows Authentication?
Depending on the setup, choose from the list http://www.connectionstrings.com/sql-server-2008/