Here is what we have:
Connection String:
<appSettings>
<add key="ConnectionString" value="workstation id=AH501780;packet size=4096;integrated security=SSPI;data source=XXXXXX\XXXXXX;persist security info=False;initial catalog=xxxx" />
</appSettings>
We added in the Web.config file:
<identity impersonate="true"/>
<authentication mode="Windows" />
In IIS 6 we have windows authentication checked.
We get the following error when we try to run the program:
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.
We have the SQL Profiler running and we don't see any connection being made. Any help would be appreciated!
Thanks,
TreyTry this for general error message troubleshooting:
http://support.microsoft.com/default.aspx?kbid=328306
It could also be caused due to an incorrect renaming of the cluster:
http://support.microsoft.com/default.aspx?kbid=307336
Are you going through a firewall? Try this:
http://support.microsoft.com/default.aspx?kbid=318432
Also, is the SQL Server updated with SP3?|||We got a little further with our problem. We have a VB.net windows application that will connect using that connection string. But the asp.net app will not. We also now added a port number to the connection string and we get the following error:
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.
So once again I hit another wall.
Trey|||In IIS, check under Authentication to see if "Anonymous" authentication is still enabled. Or you could add the following to your web.config (if it is already there, replace it with this):
<authorization>
<deny users="?" />
</authorization>|||Just wondering...dose my server need to use Active Directory?|||Is the SQL Server on the same server as the web server? If so, no. Otherwise, you need to configure the setup differently if you are not using AD.|||the web server and the SQL culter are on different boxes. where do i need to look now?|||Try creating a domain account on the network, then give that account permission to log into the SQL Server cluster. Then have your web app impersonate that account and see what happens.
No comments:
Post a Comment