I've just migrated a W2K IIS 5.0 ASP application over to Windows 2003 IIS 6.0 and it breaks the application where it connects to MS SQL Analysis Service cubes. The page still works on the W2K webserver.
Here the message I receive on Windows 2003 IIS 6.0:
Provider error '80004005'
Unspecified error
/winsoft/licensecounts.asp, line 83
Line 83 is as follows:
cat.ActiveConnection = "Data Source=" & OLAPServerName & ";Initial Catalog=WINFMS;Provider=msolap;"
I know the problem is due to security permissions, but where/what do I need to do to get it to work similar to a W2K webserver?
Here the message I receive on Windows 2003 IIS 6.0:
Provider error '80004005'
Unspecified error
/winsoft/licensecounts.asp, line 83
Line 83 is as follows:
cat.ActiveConnection = "Data Source=" & OLAPServerName & ";Initial Catalog=WINFMS;Provider=msolap;"
I know the problem is due to security permissions, but where/what do I need to do to get it to work similar to a W2K webserver?
