SQL TCP ERROR

Hi There

I have a asp web site that accesses some .Net Components.

When I try and access a component that uses a data connection I get the following error

.Net SqlClient Data Provider (0x80131904)
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

I have resently update my .net Framework to 2.1

Can this have something to do with it

Thanks
Stanton
Stanton_RouxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IT-SchubertzCommented:
Hi,

maybe the update really causes the problem. I am not sure what gets updated actually.
But here are a few points I would suggest checking...

the message states that the target refuses the connection, so:

(1) are running any firewall (hard / or software) that causes the problem?
(2) are you in a domain and have no rights to access the server?
(3) most probable: the component you are using runs in IIS, therefore probably got the User context of "ASP.NET user". this user is normally installed as local machine user and therefore has no rights to access a server on  a different IP.
To solve this, you could either impersonate the component (like you are doing with your connections) or create a instance of the component in your security context.

HTH

Andy
0
Stanton_RouxAuthor Commented:
1)I am running zone alarm personal firewall.

2)The SQL server i am trying to access is on the machine that I am working on.

3)I am accessing the site through through localhost so the asp.net user account should have rights.
0
Stanton_RouxAuthor Commented:
I just checked in my User Acounts section and I see that the ASP.Net user account is not there

Is there a way of adding that account
0
IT-SchubertzCommented:
1)I am running zone alarm personal firewall

ok, any blocking messages on that log?

2)The SQL server i am trying to access is on the machine that I am working on

still could be that ZA locks that

3) not sure if adding this user is enough.
however, you can try it.
UserName: ASPNET
Pwd expires: never
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.