asp.net, sql 2000, IIS6.0

[Guest]

hi
i hope someone can help me please, i have sql server 2000 installed on SBS2003, i have the client toools of sql server 2000 installed on my local machine. i am working on web developement, and am using IIS6.0 which im really struggling with

problem
1. When try to connect to the database via a connection string (declared correctly) from my aspx page it says that login for the user has failed, i know that this is permissions problem, but i dont know where to start looking. i have added the user name and password into the users section of the database im using as well as the overall security for the server registration. i have added the user to the permissions on IIS6.0 but it still dosent work,
what do i do?????????????????????????????????????????

The web application i am using used to work on our old server win2000 bu since we have installed 2003 from sratch i have been unable ot get the web application to wor

thanx

Also i have tried to changed the mode of the server e.g. when in e.manger the display name of the server is displayed with (Windows NT in brackets) i think this may have something to do with the connection string. but im not sure?

 

[ilPostino]

Your connection string is probably wrong but you also need to check the
authentication type of your sql server.

If its not in mixed mode this is probably your problem - by default it will
install to only use NT accounts and so your asp.net application username
(ASPNET) is the one being authenticated and hense failing.

-p

hi,
i hope someone can help me please, i have sql server 2000 installed on

SBS2003, i have the client toools of sql server 2000 installed on my local
machine. i am working on web developement, and am using IIS6.0 which im
really struggling with.

problem.
1. When try to connect to the database via a connection string (declared

correctly) from my aspx page it says that login for the user has failed, i
know that this is permissions problem, but i dont know where to start
looking. i have added the user name and password into the users section of
the database im using as well as the overall security for the server
registration. i have added the user to the permissions on IIS6.0 but it
still dosent work,

what do i do?????????????????????????????????????????

The web application i am using used to work on our old server win2000 bu

since we have installed 2003 from sratch i have been unable ot get the web
application to work

thanxz

Also i have tried to changed the mode of the server e.g. when in e.manger

the display name of the server is displayed with (Windows NT in brackets) i
think this may have something to do with the connection string. but im not
sure?