ASPNET Account unable to access network

T

thinkfr33ly

I've been developing on this machine for months and have created many
ASP.NET applications that connect to various remote machines, mostly
databases.

All of a sudden, I am unable to connect to my SQL Server even though I
have a valid connection string (no, I'm not using integrated security).
This exact connection string works perfectly in WinForms apps.

Anytime I try to connect via an ASP.NET app, I get the familiar message
"SQL Server does not exist or access is denied." Using SQL Profiler I
see it never even makes a connection attempt.

This leads me to believe that, some how, my local ASPNET account has
lost its network privledges.

Ideas? (Aside from just granting my ASPNET account admin access or
impersonating another account.)

Again, this happened suddenly and it used to work just fine.

Thanks,
RMD
 
P

Paul Clement

On 22 Jun 2005 10:05:34 -0700, (e-mail address removed) wrote:

¤ I've been developing on this machine for months and have created many
¤ ASP.NET applications that connect to various remote machines, mostly
¤ databases.
¤
¤ All of a sudden, I am unable to connect to my SQL Server even though I
¤ have a valid connection string (no, I'm not using integrated security).
¤ This exact connection string works perfectly in WinForms apps.
¤
¤ Anytime I try to connect via an ASP.NET app, I get the familiar message
¤ "SQL Server does not exist or access is denied." Using SQL Profiler I
¤ see it never even makes a connection attempt.
¤
¤ This leads me to believe that, some how, my local ASPNET account has
¤ lost its network privledges.
¤
¤ Ideas? (Aside from just granting my ASPNET account admin access or
¤ impersonating another account.)
¤
¤ Again, this happened suddenly and it used to work just fine.

Couple of obvious things to check:

Is the SQL Server service running?
Is SQL Server authentication limited to Windows authentication?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
T

thinkfr33ly

Yes, the SQL Service service is running.

No, SQL Server is not limited to Windows Auth, hence the reason the
same code with the same connection string works in a Winforms app.
 
P

Paul Clement

On 22 Jun 2005 12:04:01 -0700, (e-mail address removed) wrote:

¤ Yes, the SQL Service service is running.
¤
¤ No, SQL Server is not limited to Windows Auth, hence the reason the
¤ same code with the same connection string works in a Winforms app.

In that case you may need to do a bit of troubleshooting:

Potential causes of the "SQL Server does not exist or access denied" error message
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306


Paul
~~~~
Microsoft MVP (Visual Basic)
 
T

thinkfr33ly

I think this may have something to do with a recent rollout of McAfee
8.0 to our domain.

Is it possible that McAfee has modified the privledges of the ASPNET
user account to prevent it from accessing the network?

If so, what's the best way to enumerate these kinds of permissions for
a local user and perhaps change them?

Thanks,
RMD
 
T

thinkfr33ly

It turns out the issue was with SQL Server. For whatever reason, it
decided to stop accepting connections from some accounts while still
accepting connections from others.

We restarted the SQL Server service, and it started working again.

Very strange.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top