SQL Server does not exists or access denided

Discussion in 'ASP .Net' started by SOS, Feb 27, 2004.

  1. SOS

    SOS Guest

    hi guys ,
    i want to coonnect to a sql server on an other machine in a LAN network.
    i use of this connection string : "data source=TargetMachine;initial
    catalog=mydatabase;password=1;persist security info=True;user id=a;packet
    size=4096"
    but when i trying to get some data, i get this error : "SQL Server doesn't
    exists or access denided"
    but i can connect to this database and get data with "Enterprise Manager" or
    "Query Analyzer".
    what's the problem ?

    Thanx
     
    SOS, Feb 27, 2004
    #1
    1. Advertising

  2. Hi, SOS,

    Try some of the connection strings listed in this site:

    http://www.connectionstrings.com/

    Greetings
    Martin
    "SOS" <> wrote in message
    news:#DgWTrQ$...
    > hi guys ,
    > i want to coonnect to a sql server on an other machine in a LAN network.
    > i use of this connection string : "data source=TargetMachine;initial
    > catalog=mydatabase;password=1;persist security info=True;user id=a;packet
    > size=4096"
    > but when i trying to get some data, i get this error : "SQL Server doesn't
    > exists or access denided"
    > but i can connect to this database and get data with "Enterprise Manager"

    or
    > "Query Analyzer".
    > what's the problem ?
    >
    > Thanx
    >
    >
     
    Martin Dechev, Feb 27, 2004
    #2
    1. Advertising

  3. Most likely, the SQL Server is not set up with mixed mode and you are
    connecting with the SQL tools using Windows authentication. This is the most
    common reason people have problems, esp. with MSDE.

    It could also be the client library being used by the web server.

    Or, it could be user based (long shot with a connection string using SQL
    security). The easiest way to check the second is try to get data using that
    connection string in a Windows App. If it works, then try turning off anon
    access in your web app and see if you can get in.

    --
    Gregory A. Beamer
    MVP; MCP: +I, SE, SD, DBA

    **********************************************************************
    Think Outside the Box!
    **********************************************************************
    "SOS" <> wrote in message
    news:%23DgWTrQ$...
    > hi guys ,
    > i want to coonnect to a sql server on an other machine in a LAN network.
    > i use of this connection string : "data source=TargetMachine;initial
    > catalog=mydatabase;password=1;persist security info=True;user id=a;packet
    > size=4096"
    > but when i trying to get some data, i get this error : "SQL Server doesn't
    > exists or access denided"
    > but i can connect to this database and get data with "Enterprise Manager"

    or
    > "Query Analyzer".
    > what's the problem ?
    >
    > Thanx
    >
    >
     
    Cowboy \(Gregory A. Beamer\), Feb 27, 2004
    #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. Totan
    Replies:
    0
    Views:
    982
    Totan
    Apr 17, 2006
  2. shahin
    Replies:
    0
    Views:
    459
    shahin
    Aug 30, 2007
  3. Ulf Meinhardt
    Replies:
    8
    Views:
    6,161
  4. Damien

    SQL Server does not exists... Yada, yada, yada

    Damien, Sep 5, 2006, in forum: ASP .Net Security
    Replies:
    0
    Views:
    112
    Damien
    Sep 5, 2006
  5. Shahin

    System.ComponentModel.Win32Exception Access denided

    Shahin, Aug 31, 2007, in forum: ASP .Net Web Services
    Replies:
    0
    Views:
    161
    Shahin
    Aug 31, 2007
Loading...

Share This Page