SQL Server login

[PatrickIRL]

This is driving me crazy! I need to be able to login to an sql server db but I can't use windows authentication because some users will have win98.

I've set up a test user and tried logging in using that but every time I get "Invalid password" error. I can log on to "Management Studio" using this login but can't connect through VB, is this possible at all??

Thanks,

Patrick

(I have posted this in the SQL forum also to see if I get resolution there)

 

[RonRepp]

Make sure that your Test User has permissions for all the databases that would be needed.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.