SQL Server 2000 Login Problem...

[Redth]

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!

[Hack]

Are you using SQL Server or NT Authentication?

[veryjonny]

I got the same prob., it gets connected using NT auth. but not when I choose SQL server auth.

If you have found the soln, pls post it back..

[Roshec]

From MSDN...

INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation

After a Typical installation of Microsoft SQL Server 2000, Windows Authentication is the default security mode. Therefore, after you install SQL Server 2000 and you attempt to connect to the SQL Server server by using a standard login like system administrator (SA), you may receive the following error message:

Unable to connect to server SERVER_NAME:

Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server]


Change your Authentication mode from Windows NT Authentication Mode to SQL Server and Windows...

Later...