plz help!/login failed for user sing vb.net2003 application program connec to sql2k

[crisjala]

hi gud day evrybody plz help me error"login failed for user using vb.net2003 program application connect to sql 2000...i have sql2000 server and i created dbname test then i created log in sql name xtops gran permission acces on dbname test..but if i created login in windows it works... but i dont want to create log in in windows coz the prog can acces dbase even if hte user is not created into dbase....hope you help me plz

[mulhearn22]

I have no idea what you're saying, and chances are you didn't get any responses because no one else does. Don't use slang, state your problem clearly and anything you have tried to fix it, and perhaps someone can help you.

[mickey_pt]

First of all try to write correctly...

Second, after 2/3 readings of your post, i understand that you want to login to sql server with an sql server account, and you can't, if you use the windows authentication everything works fine.

So you have to do 2 things, first enable the login in mixed mode, and then after creating the login/user to simply the process create the database with this user...

If you have sql server manager studio (ssms), it's a simple process...

And this problem it's in the wrong section...

[crisjala]

tnx guys i'll discover whats the problem...tnx for you guys..