Link to home
Start Free TrialLog in
Avatar of kwh3856
kwh3856Flag for United States of America

asked on

Login failed for user sa. Reason:Not associated with a trusted SQL Server Connection

I am trying to write a record to my SQL database and am having trouble connecting to the database with the user sa.  I thought this user had "god" rights to the system.  Here is my code

'Write Writing Objective Info record
            Dim objConnection3 As SqlConnection = New SqlConnection("server=(local);database=FBISD-TAKS;user id=sa;password=password")
            Dim objCommand3 As SqlCommand = New SqlCommand
            objCommand3.Connection = objConnection3


Any help is greatly appreciated.

Thanks
Kenny

ASKER CERTIFIED SOLUTION
Avatar of gregoryyoung
gregoryyoung
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kwh3856

ASKER

Once again.....YOU ROCK!!!!!


Thanks
Kenny
nah I just had to figure out the same issue myself once :( took me an hour so I rememberred it :)