How to Connect to a SQL server on a deferent machine using ASP.Net?

Hi,

I am trying to connect to a SQL server on a deferent machine using ASP.Net written in C#. The machine on which the SQL server reside dose not have the ASPNET user and the authentication is falling. Any ideas on how to connect using a different User. I changed the ASP.Net service on my machine to run as a deferent user MyUser, which is a domain user that have access to the server machine?

Note: We can not change the privileges on the server side.

Thanks.

RH

Hi,

I am looking to run a web service as a deferent user; it is running, as ASPNET and I would like it to run as a domain user. I am not sure if this is a configuration issue in the Dev studio. Please help.

Thanks.

Rafat

|||

You should post on an ASP.Net forum for instructions on how to set a specific login to be used by your application for connecting to SQL Server.

If you have questions about how to setup such a login in SQL Server, let us know.

Thanks
Laurentiu

|||

Please don't open different threads on the same topic.

Thanks
Laurentiu