sql server connection problem

Discussion in 'ASP General' started by Savas Ates, Oct 23, 2004.

  1. Savas Ates

    Savas Ates Guest

    "SQL Server does not exist or access denied"

    sql server error:17
    i cant connect sql Server 2000
    why?
    Savas Ates, Oct 23, 2004
    #1
    1. Advertising

  2. Are you using a SQL Server Login (if so - check login and password used) or
    Windows?

    Wayne

    "Savas Ates" <> wrote in message
    news:%...
    > "SQL Server does not exist or access denied"
    >
    > sql server error:17
    > i cant connect sql Server 2000
    > why?
    >
    >
    Wayne Wengert, Oct 23, 2004
    #2
    1. Advertising

  3. Savas Ates

    Savas Ates Guest

    i can connect with system dsn

    name=localhost
    and i test my connection
    it is succesfull with windows nt authentication

    in as p my connection string
    Set baglantim=Server.Createobject("ADODB.Connection")
    Outpost="PROVIDER=SQLoledb;Initial Catalog=friends;User Id=sa;password=;Data
    Source=localhost"

    im getting this error
    "SQL Server does not exist or access denied"
    Savas Ates, Oct 23, 2004
    #3
  4. Savas Ates

    Savas Ates Guest

    Set baglantim=Server.Createobject("ADODB.Connection")
    Outpost="PROVIDER=SQLoledb;Initial Catalog=friends;User Id=sa;password=;Data
    Source=localhost"


    when i write

    Data Source=111.111.111.111(myip)
    in my connection string it works


    when i write

    Data Source=localhost

    it doesnt work

    why?
    Savas Ates, Oct 23, 2004
    #4
  5. What happens when you ping localhost from a command line? Have you tried
    (local), your machine name, 127.0.0.1, etc.?

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Savas Ates" <> wrote in message
    news:Os#...
    > Set baglantim=Server.Createobject("ADODB.Connection")
    > Outpost="PROVIDER=SQLoledb;Initial Catalog=friends;User

    Id=sa;password=;Data
    > Source=localhost"
    >
    >
    > when i write
    >
    > Data Source=111.111.111.111(myip)
    > in my connection string it works
    >
    >
    > when i write
    >
    > Data Source=localhost
    >
    > it doesnt work
    >
    > why?
    >
    >
    >
    Aaron [SQL Server MVP], Oct 23, 2004
    #5
    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. =?Utf-8?B?UmV6YQ==?=
    Replies:
    3
    Views:
    17,887
    Carlos Barini
    Jun 7, 2004
  2. Daves
    Replies:
    1
    Views:
    361
  3. Joey
    Replies:
    3
    Views:
    4,419
  4. Geoff
    Replies:
    3
    Views:
    429
    Patrick.O.Ige
    Jan 16, 2006
  5. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    331
    farseer
    Aug 8, 2006
Loading...

Share This Page