connecting to a remote sql server problem..

i have sql server 2000 running on a windows server 2003 machine but have my web application on another windows xp machine

i'm getting access denied from the client machine... the 2 computers are connected by workgroup..

anyone can tell me how and what i need to do to connect to the sql server thanks

Hi There

Are you using impersonation in the web.config?

If not youll be trying to access sql server as the asp.net account on the web server - this wont have access to the db on the other server - either grant access on the sql server to the aspnet account or create a new account on the web server, then use this account using imperonsation in the web.config to access the sql server machine and the database.

Thanks
Gregor

|||

That might be caused by incorrect config of sql server ,issues of permission , connection string error,fire wall blocking...

You'd better elaberate your error message.