Today, I have come across a strange issue whereby connection to SQL DB is not valid from connection string but it the login is fine through SQL Management Studio.
The error i have received is as such;
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 'user'.
To solve this issue, I have forced any connection to SQL Server to use TCP/IP. this is done by disabling all other protocol (e.g. Name Pipes and Shared Memory) using SQL Server Configuration.
Note: the SQL Database is clustered, which adds to the complexity.
No comments:
Post a Comment