I have recently finished a windows desktop application for a client that connects to a sql server database. Throughout development while the server instance was on my local machine the application and server communicated fine with the connection string below
<add name="myString" connectionString="Data Source=myServerName;Initial Catalog="myDbName";Integrated Security=True" providerName="System.Data.SqlClient" />
However when we installed the database onto a server and swapped the data source names over the application failed to access the server.
When we installed sql server we used the default settings except when it came to the service account settings where the DBA used checked use a domain user account and used the administrator log in details. Everything else was by default.
The version of sql server is 2005 developer edition.
Apologies for any holes in my knowledge - I've never tackled this task before!
Can anyone shed any light?