kwh3856
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=(loc al);databa se=FBISD-T AKS;user id=sa;password=password")
Dim objCommand3 As SqlCommand = New SqlCommand
objCommand3.Connection = objConnection3
Any help is greatly appreciated.
Thanks
Kenny
'Write Writing Objective Info record
Dim objConnection3 As SqlConnection = New SqlConnection("server=(loc
Dim objCommand3 As SqlCommand = New SqlCommand
objCommand3.Connection = objConnection3
Any help is greatly appreciated.
Thanks
Kenny
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
nah I just had to figure out the same issue myself once :( took me an hour so I rememberred it :)
ASKER
Thanks
Kenny