Hello..

just installed sql server 2000 on my development machine here, but i can't seem to get it to connect through any of my asp or vb code....

i can connect with query analyzer, using windows login info, but not with a user that i have setup to login with.... here's the error i get:

Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'myUserNameisHere'. Reason: Not associated with a trusted SQL Server connection.
im not sure if i have it installed correctly, or what is the problem... as i said, i can use the query manager with windows login and perform queries fine, but not through ado or asp pages etc....

did i setup my client network utility wrong?

in it i have tcp/ip and named pipes protocols enabled
under aliases i have:

localhost Named Pipes \\localhost\pipes\sql\query
REDTHMAINRIG TCP/IP REDTHMAINRIG


note REDTHMAINRIG is my machine's name...

do i have something setup incorrectly here?

appreciate help!