accessing sql database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
i have 2 pcs that access my database server. one has Enterprise Manager on
it and i can access the database just fine.
the other pc has visual studio on it and i'm trying to connect using Data
Link properties specifying SQL credentials, sa as the login but i'm getting
access denied. i thought sa would get me in. am i missing somethig?

thanks,
rodchar
 
You need to set the SQL Server Authentication to Mixed Mode to allow SQL
Logins to access the box. It installs by default to only allow windows
authentication.
 
Back
Top