Connection refused, connecting to SQL server through web

Hi,
I'm trying to connect to an SQL server from an asp.net
page. Both servers are in the same domain.
The setting on the SQL server are set to accept both
Windows and SQL users.
The users of the webserver log in with windows
authentication.
First I tried to connect to the SQL server using the
Administrator account of the web server. This was no
succes and got the message: SQL Server does not exist or
access denied
After that I changed both administrator accounts to the
same password and tried to connect. Now the connection
was succesfull.
But, if I try to connect from the web I still get the
message: SQL Server does not exist or access denied.
Does anybody have an solution for this problem?
Greetings,
Tom
Not a quick and easy answer. Very details steps are outlined here;
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
ml/SecNetch05.asp
This assumes you machines are in Active Directory. If not you can follow
this older article;
176380 How To Use ASP with a SQL Trusted Connection with Guest Account
http://support.microsoft.com/?id=176380
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you,
this really helpt.
>--Original Message--
>Not a quick and easy answer. Very details steps are
outlined here;
>Building Secure ASP.NET Applications: Authentication,
Authorization, and
>Secure Communication
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/ht
>ml/SecNetch05.asp
>This assumes you machines are in Active Directory. If
not you can follow
>this older article;
>176380 How To Use ASP with a SQL Trusted Connection with
Guest Account
>http://support.microsoft.com/?id=176380
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||You're welcome!
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.