accessing sql database

[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

 

[Guest]

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.

 

[Guest]

if you mean the following:

SECURITYMODE=SQL

i did this too.