Errors in event log are kind of related to SQL Server.

  • Our company is planing to upgrade Windows 2000 to Windows 2003 Server. There are over hundreds website residing in Windows 2000.

    During the testing, deveoplers met the following issues are listed as below.

    My question is, when you see error message, how do you troublesgoot it?

    Event Type:Error

    Event Source:VBRuntime

    Event Category:None

    Event ID:1

    Date:9/14/2010

    Time:5:40:23 PM

    User:N/A

    Computer:Test

    Description:

    The VB Application identified by the event source logged this Application ILV: Thread ID: 276 ,Logged:

    ERROR: in SendEmail: 70, Permission denied, ILV. Parameters: sqlStr = exec dbo.usp_getEmailSendInfo

    , cnStr = Driver={SQL Server}; Server=TEST; UID=Test; PWD=Test; WSID=ILV_Website; Language=us_english;Database=ILV_Support; DSN=;

    Event Type:Error

    Event Source:VBRuntime

    Event Category:None

    Event ID:1

    Date:9/14/2010

    Time:1:37:29 PM

    User:N/A

    Computer:Test

    Description:

    The VB Application identified by the event source logged this Application ILV: Thread ID: 1308 ,

    Logged: ERROR: in getDiseaseInfo (DD): -2147024891, Access is denied.,

    Parameters: sqlStr = exec dbo.usp_DD_getDDInfo 0,null,null,154, 0 ,

    cnStr = Driver={SQL Server}; Server=Test; UID=Test; PWD=Test; WSID=ILV_Website; Language=us_english;Database=ILV_Support; DSN=;

  • it looks like a permission issue

    I would start by checking the sql server error log

  • I checked the permision again and again and again. The permission had no problem.

  • Just update this.

    These two errors are not SQL Server Permission issue.

    First error is about OS level permission.

    Second Error is about ASP recordset.

Viewing 4 posts - 1 through 3 (of 3 total)

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