aspx_professional thread: SQL server does not exist / access denied - intermittent fault
Hi,
I have a asp.NET application that accesses a SQL server. Sometimes the
application runs fine but other times I keep getting the following error
message:
'System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.'
The connection string I am using is as follows and I guess this must be OK
as some of the time this works.
Server=SERVERNAME; Database=DatabaseName; UID=sa; pwd=MyPassword;
I have other ASP.NET web apps running on the same server which can access
different databases on the same SQL server with no problems.
Why does it let me access it sometimes but not all the time?
thanks,
Nick