Encoded string problem
-
The Connection string stored in web config file works OK for an MSDE. However when the Connection string is encoded the connection does not succeed. Any clue for this? ---follows error message[part of it] Login failed for user '(null)'. Reason: 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 '(null)'. Reason: Not associated with a trusted SQL Server connection --------------------- Note: The authentication is set to windows trusted.
-
The Connection string stored in web config file works OK for an MSDE. However when the Connection string is encoded the connection does not succeed. Any clue for this? ---follows error message[part of it] Login failed for user '(null)'. Reason: 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 '(null)'. Reason: Not associated with a trusted SQL Server connection --------------------- Note: The authentication is set to windows trusted.
There really was no problem. I was using Firefox browser which does not reproduce the extent of a text UI correctly and I was cutting and pasting the encoded information into my web.config file which truncated the ConnectionString. What you put in is what you get out. Moral: always double check and don't think everything will be OK.