Welcome to MSDN Blogs Sign in | Join | Help

October 2009 - Posts

Friday, October 30, 2009 9:09 AM

No collector registered for scope: "SetupStateScope” - Message pump returning: 1602

Consider this scenario: - You have already installed a SQL Server 2000 instance on a Windows 2003 machine. - You also try to install a SQL Server 2005 instance on the same Windows 2003 machine. - Searching in the hotfix.log and summary.txt log files you
Posted by John Daskalakis | 0 Comments
Friday, October 30, 2009 8:47 AM

Request from IIS 5.0 arrives as anonymous login (‘null’) on SQL Server 2000

Recently we did troubleshoot an issue where requests from an IIS 5.0 site arrived as anonymous logins (‘null’) in SQL Server 2000. The ASP.NET application was using IIS 5.0 anonymous authentication for its users to send requests to SQL server 2000. The
Posted by John Daskalakis | 0 Comments
Thursday, October 15, 2009 2:08 PM

The SQL server specified in SSIS service configuration is not present or is not available

Consider this scenario: - You have setup a SQL Server 2005 failover instance. - You then install SSIS 2005. - When you try to access the MSDB database from inside the Integration Services you get this message: The SQL server specified in SSIS service
Posted by John Daskalakis | 0 Comments
Filed under:
Monday, October 12, 2009 8:33 AM

Test connection failed because of an error in initializing provider (ORA-12154)

Consider this scenario: - You have migrated a DTS packages from SQL Server 2000 to SQL Server 2005. - The new SQL Server is installed on a Windows 64-bit machine. - This DTS package is connecting to an Oracle 10G database. - You get this error or something
Posted by John Daskalakis | 0 Comments
Filed under:
Monday, October 12, 2009 7:09 AM

Installing SSIS services after installing SQL Server database engine

Consider this scenario: - You have installed SQL Server 2005 and patched it with a Service Pack (in our case it was SP3). - Then you install SSIS on the same box, but do not patch it with any Service Pack. - Specifically you get this error when you try
Posted by John Daskalakis | 0 Comments
Filed under:
 
Page view tracker