we created a new login and use windows authentication since it is being asked everytime i connect to the SQL Server 2005..
by doing this
a. login using administrator > then Click Security > Login > right click > new user
b. new user > click search button then find the user in the domain… (i am doint this temporarily since i really need to run my program.
c. Under server rule click sysadmin
d. under user mapping tick the database that you need
e. make sure that it is grant and enabled under status
once you have chosen the user then click ok
then try running it…
good luck
by the way im using visual basic 6 and MS SQL 2005.. and is used DSN as my connection…
