I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message -
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I wrote following connection string in web.config file-
<add key="ConnectionString" value="Data Source=18.104.22.168;User ID=user;password=pass;Initial Catalog=dbname;Integrated Security=True" />
<add name="brightlightConnectionString" connectionString="Data Source=22.214.171.124;User ID=user;password=pass;Initial Catalog=dbname;Integrated Security=True" providerName="System.Data.SqlClient"/>
Is there anything wrong with the connection string?
Please help me out