Using ASP.NET with MS SQL 2000 and IIS on another Server

  • Thread starter Thread starter Tony Riv
  • Start date Start date
T

Tony Riv

My web app works locally, but after copying the project over to our intranet
server, I get the following error when my SQLConnection tried to connect to
the SQL server...
Login failed for user 'DEVELOP\IUSR_DEVELOP'
I have set the above user up, on the SQL database, and checked the
permissions, but still cannot connect.

Any ideas?
 
Thanks, but I have tried that and also granted access to the database I am
using and allowed the following security..
public and db owner

I also tried DEVELOP\ASPNET as well

Also, I am using MSDE 2000 on the server and administering it from
'Enterprise Manager' on my PC....don't know if that helps.
 
Sorry...

I only use SQL Server 2000 I don't know MSDE, I just know it's a limited
version of SQL Server but it's all...

Regards

Laurent Jordi

www.eztree-msdn.com
 
Back
Top