September 15, 2010 at 9:54 am
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=;
September 15, 2010 at 10:05 am
it looks like a permission issue
I would start by checking the sql server error log
September 15, 2010 at 11:00 am
I checked the permision again and again and again. The permission had no problem.
September 16, 2010 at 11:33 am
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