Post reply

SQL Server Error

  • June 2, 2003 at 11:03 pm

    #159158

    I have set up a sql server to host web databases. The box is being recognized. I can ping it. The IP seems to be set up correct. But when I try to connect to it from a web page. I get a SQL Error:

    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    /webserver.asp, line 8

    I have double, triple checked the connection string. It has the right IP, DB, UID, PWD

    Is there any other configurations or security issues that I am missing on the box itself. Maybe setting up user accounts or so on.

    Any help would be greatly appreciated.

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com

  • June 3, 2003 at 6:40 am

    #459525

    Could you include a sample of the connection code?

    Later jimmY

    Work like you don't need the money.

    Love like you've never been hurt.

    And Dance like no one is watching.


    Work like you don't need the money.
    Love like you've never been hurt.
    And Dance like no one is watching.

  • June 4, 2003 at 5:18 am

    #459679

    read this topic

    http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12804&FORUM_ID=5&CAT_ID=1&Forum_Title=Administration&Topic_Title=SQL+Server+Service+Pack+3

  • June 4, 2003 at 10:46 am

    #459777

    That was a good reference topic, but my error is not with [TCP/IP Sockets] it is

    [DBNETLIB]

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com

  • June 4, 2003 at 11:27 am

    #459789

    Can you check whether you can access sql server from your IIS server using OSQL/ISQL or ODBCPING.exe utilities with same login ID and password?

    If you use ODBC DSN to connect SQL Server, enable SQL Trace from ODBC administrator to see any errors.

    Make sure you use correct authentication method, ie you may have to configure SQL Server with windows and SQL server authentication.

    Edited by - Allen_Cui on 06/04/2003 11:38:38 AM

  • June 4, 2003 at 11:42 am

    #459794

    I can connect to SQL Server via the Computer Manager, but I cannot see it from IIS Manager.

    I do have mixed authentication.

    How do I enable SQL Trace from ODBC administrator to see any errors.

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com

  • June 4, 2003 at 11:45 am

    #459795

    ODBC administrator --> Tracing Tab --> Start trace --> Run your asp program --> review the trace log file.

    Edited by - Allen_Cui on 06/04/2003 11:49:35 AM

  • June 5, 2003 at 9:32 am

    #459986

    I ran the asp page no trace file was created.

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com

  • June 5, 2003 at 9:45 am

    #459993

    I take that back I found the sql log. It is over 100 meg.

  • June 5, 2003 at 9:49 am

    #459994

    This was the last entry into the SQL Log

    sqlagent 110-328EXIT SQLGetDiagFieldW with return code 100 (SQL_NO_DATA_FOUND)

    SQLSMALLINT 3

    SQLHANDLE 006A2A58

    SQLSMALLINT 1

    SQLSMALLINT -1154

    SQLPOINTER 0x00E19170

    SQLSMALLINT -6

    SQLSMALLINT * 0x00000000

  • June 5, 2003 at 10:12 am

    #460002

    Try to search for any errors especially for login info.

  • June 5, 2003 at 10:29 am

    #460007

    I did not see any login info (but I didn't know what I was looking for)

    I ran the asp in a dts package and it worked

    It had the same connectionstring and ado code.

    I also double checked I Have both SQL and Windows authentication.

    I think there has to be some sort of permissions/login issue!

    Thanks,

    Anthony Mendoza, Jr., MCSD, MCDBA

    Micro-Systems, Inc.

    Application Developer

    anthony_mendoza@msn.com

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply