creating a user

[FALCONSEYE]

I am using SQL Server 2000 and trying to setup a user for a specific application.
Under security > logins > I created a user called "stats" with SQL server authentication, assigned server roles and database access.

When I try to login as "stats", I keep getting:

unable to connect to server ....
server: msg 17 Level 16 state 1
...

does anybody know what I have to do to fix this problem?
thanks

http://www.jetansolutions.com

 

[mrdenny]

You should start with this FAQ faq962-5481.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[FALCONSEYE]

I fix the problem by switching the authentication mode.

http://www.jetansolutions.com