Results 1 to 8 of 8
  1. #1
    Join Date
    May 2004
    Posts
    5

    Post Unanswered: Can't connect Web Server to SQl Server

    I have a web server with Advanced server 2003 on it and its name is WEB that is trying to get data off of the SQL 2000 server (SQL). They are only on a local area network right now because we are just testing before we put them into production. They used to be on the same machine so linking them was never a problem. I've created a ODBC connection from the web to the sql and named it "SQL". The Databae that i'm trying to access is Dept_Data. This is the same code we had for the old connection i just changed the source name to SQL.

    <%
    Dim MM_connDept_Data_STRING
    MM_connDept_Data_STRING = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Dept_Data;Data Source=SQL"
    %>

    I've messed around with this for the past two days and can't figure it out, i'm not all that familar with it but i hope someone can help me out. I kind of think it is a permissions or a login issue. Is this enough info. Help!

  2. #2
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Try...

    Code:
    "DRIVER=SQL Server;SERVER=SQL;Database=dept_data;UID=userlogon;PWD=userpassword"

  3. #3
    Join Date
    May 2004
    Posts
    5

    Post

    What logon and password is it the one to get into the Database or the what?

  4. #4
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Logon and Pwd for the Database.

  5. #5
    Join Date
    May 2004
    Posts
    5

    Post

    when put the login and password in it asks me to log into the web server for some reason. The code that we put in is in an asp file that is included in the asp file that we want displayed. Do we need to configure an anounomous account?

  6. #6
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    The WEB site has to allow anonymous access. That's set by right-clicking the site in IIS Manager, selecting security, and checking the Allow Anonymous Access box. Also make sure you have installed the SQL Server Client Network Utilities on the WEB Server. In the string I gave you, where it says

    SERVER=SQL;

    I assume SQL is the name of the SQL server box.

  7. #7
    Join Date
    May 2004
    Posts
    5

    Post

    Is this what i need to download on my advanced server 2003 web machine? http://www.microsoft.com/downloads/d...displaylang=en
    And yes the 2000 sql server is named SQL.

  8. #8
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    Part of the installation of SQL Server 2000 asks what you want to install. You have a choice of installing the server of just the client side stuff. Run the install on your WEB server and pick the client tools from the menu.
    Last edited by grahamt; 05-28-04 at 12:03. Reason: dum spellling

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •