Login failed on database connection on IIS server
Posted on 2007-11-29
I have been testing my application the visual web developer using the local:host, and a remote database.
Now I have copied my project to my web server and IIS is all setup. The web pages are fine.
But when I hit the database, it gives me:
>>Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have the IP address setup and everything and I'm not sure why it connects from my pc but not from the website.
Can you think of anything I need to check for? It has been a long day and I'm likely not thinking straight.
this works locally, but not from the IIS web site:
<add name="xxConnectionString" connectionString="Data Source=xx.xx.xx.xx;Initial Catalog=DbfName;Integrated Security=True" providerName="System.Data.SqlClient"/>