System.Data.SqlClient.SqlException: Login failed for user 'xxxxxx'. Reason: Not associated with a trusted SQL Server connection. at System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnectionBase owningConnection) at System.Data.ProviderBase.DbConnectionClosed.Open(DbConnectionBase outerConnection) at System.Data.ProviderBase.DbConnectionBase.Open() at System.Data.SqlClient.SqlConnection.Open() at xxxxx.selection.FillDGResults() in c:\inetpub\wwwroot\xxxxx\xxxxx.aspx.vb:line 74
Thanks!
Dancan you post your connection string ? check if the user name exists in the users tab of the database.
hth|||Here is my connection string. Naturally, the ID, Password, and location have all been altered for security reasons.
<code.<appSettings>
<add key="cnSystem" value="packet size=4096;user id=userID; data source=SQLSERV;="None";persist security info=True;initial catalog=System;password=hellothere" />
</appSettings> </code>|||Scratch that last post... I posted a messed up version. It should read
<code. <appSettings>
<add key="cnSystem" value="packet size=4096;user id=userID; data source=SQLSERV;persist security info=True;initial catalog=System;password=hellothere" />
</appSettings> </code>|||Is the SQL Server set to allow both trusted logins and sql server logins? The error message suggests that it is expecting a trusted connection (trusting the domain authentication) yet your connection string contains a user name and password.
No comments:
Post a Comment