IIS6,asp.neret,sqlserver2000

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?

Can you please include the _complete_ error message? It should tell us what
kind of permissions problem you have. Note however that it is not enough to
add the user access to the database server, you also need to grant it
permissions to use the database, the tables, views, stored prrocedures, and
so on. You probably got a new error message after adding the user in the
database, but the user probably still do not have permissions to access
whatever it needs to access.

--
Regards,
Kristofer Gafvert - IIS MVP
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
<a style='text-decoration: underline;' href="http://www.ilopia.com" target="_blank">www.ilopia.com</a> - FAQ and Tutorials for Windows Server 2003


"Zal" <zal RemoveThis @sage-partners.com> wrote in message
news:1611001c416f8$ad4f4390$a301280a@phx.gbl...
 > 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?<!-- ~MESSAGE_AFTER~ -->