Interview Question in SQL Server Data Services (SSDS)
Interview Question :: Web Service will not connect to SQL database
I have an app which uses a web service to connect to a SQL database. The application reports back an Access Violation message.
This works at some sites, but not at others. I’ve compared every permission, property and setting I can think of between the working sites and the non working ones and all appears to be the same.
My ConnStr is:
<ConnStr>data source=SERVERNAME/DATABASE; initial catalog=USER; user=USERNAME; password=PASSWORD</ConnStr>
Any help would be appreciated.
Thanks
Loading ...