ignore my first comment.
1) i think the connection string used trucsted connection. you might need to change it in the application so that it uses the choosen user/password.
>>>batman' account in order to have an existing Windows logon
2) if u use a windows authenication (i hope that what is what u meant) then not neccsary to setup a sql authentication account eg batman.
again u need to check the application code for the connection string to see how it connects to the database.
check sql server logs and event viewer failed logins. then u will know what failed for whom. If that information is not there then u need to select (tick) this option in sql server properties.
Main Topics
Browse All Topics





by: WizillingPosted on 2007-03-28 at 17:30:44ID: 18812924
current user logged into the computer/pc/server doesnt have access to the sql databse.
get an adminstrator to give accesss to database.