accessing sql database

Discussion in 'ASP .Net' started by =?Utf-8?B?cm9kY2hhcg==?=, Nov 28, 2006.

  1. 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
    =?Utf-8?B?cm9kY2hhcg==?=, Nov 28, 2006
    #1
    1. Advertising

  2. 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.


    --

    Ciaran O''Donnell
    http://wannabedeveloper.space.live.com


    "rodchar" wrote:

    > 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
    =?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?=, Nov 28, 2006
    #2
    1. Advertising

  3. if you mean the following:

    SECURITYMODE=SQL

    i did this too.

    "Ciaran O''Donnell" wrote:

    > 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.
    >
    >
    > --
    >
    > Ciaran O''Donnell
    > http://wannabedeveloper.space.live.com
    >
    >
    > "rodchar" wrote:
    >
    > > 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
    =?Utf-8?B?cm9kY2hhcg==?=, Nov 28, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kevin
    Replies:
    2
    Views:
    2,498
    Kevin
    Nov 26, 2003
  2. Jeff
    Replies:
    2
    Views:
    583
  3. =?Utf-8?B?SmFrZSBIZW5kZXJzb24=?=

    Problem when accessing SQL database in website

    =?Utf-8?B?SmFrZSBIZW5kZXJzb24=?=, Mar 13, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    529
    Karl Seguin [MVP]
    Mar 14, 2006
  4. Keith
    Replies:
    1
    Views:
    2,309
    Keith
    Jul 3, 2006
  5. Scott Castillo

    Accessing SQL Server database from Javascript

    Scott Castillo, Feb 12, 2004, in forum: Javascript
    Replies:
    3
    Views:
    332
    Douglas Crockford
    Feb 12, 2004
Loading...

Share This Page