Error installing SQL Server 2005 Upgrade Advisor

I'm getting a Windows Installer error when attempting to run the Upgrade Advisor setup package (SQLUASetup.exe). The error message reads:

"This installation package cannot be installed by the Windows Installer service. You must install a Windows service pack that contains a newer version of the Windows Installer service."

The machine is running Windows 2000 sp4. Both the .net framework v2 and Windows Installer 3.0 have been installed.

Any suggestions?

You need to be running Windows Installer 3.1. You can find it here:

http://support.microsoft.com/?id=893803

|||

I'm also having problems installing the Upgrade Advisor on a W2K server running SQL Server 2000. .net Framework 2.0 is installed as is Windows Installer 3.1.

I'm getting the follwing error message: "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2755."

Any ideas what might be the problem here ?

|||

You need to install Windows 2003 SP1, .NET frameworks 2.0 before installing Upgrade Advisor

You can refer http://msdn2.microsoft.com/en-us/library/ms144256.aspx

If you are still seeing install errors, you gather verbose log and post it in this newsgroup. To create verbose log:

Ex: msiexec /i SQLUASetup.msi /l*v e:\temp\verbose.log

Thanks

Sethu Srinivasan

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Error installing SQL Server 2005 Upgrade Advisor

I'm getting a Windows Installer error when attempting to run the Upgrade Advisor setup package (SQLUASetup.exe). The error message reads:

"This installation package cannot be installed by the Windows Installer service. You must install a Windows service pack that contains a newer version of the Windows Installer service."

The machine is running Windows 2000 sp4. Both the .net framework v2 and Windows Installer 3.0 have been installed.

Any suggestions?

You need to be running Windows Installer 3.1. You can find it here:

http://support.microsoft.com/?id=893803

|||

I'm also having problems installing the Upgrade Advisor on a W2K server running SQL Server 2000. .net Framework 2.0 is installed as is Windows Installer 3.1.

I'm getting the follwing error message: "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2755."

Any ideas what might be the problem here ?

|||

You need to install Windows 2003 SP1, .NET frameworks 2.0 before installing Upgrade Advisor

You can refer http://msdn2.microsoft.com/en-us/library/ms144256.aspx

If you are still seeing install errors, you gather verbose log and post it in this newsgroup. To create verbose log:

Ex: msiexec /i SQLUASetup.msi /l*v e:\temp\verbose.log

Thanks

Sethu Srinivasan

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Error Installing Service Pack 1

Hi all,
I tried to upgrade a clients site to Sp1 and got the following error:
"SQL Setup failed to connect to the database service for server
configuration. Refer to the Server error logs and setup logs for more
detailed error information."
I was just wondering if anyone else has come across this error and know any
ways to fix it?
Also does the account I am logged onto (or Term Served into) the box with
require access to the Configuration Database or the Database Server?
And I can't find any documentation on what security level is required for
applying the Service Pack ie. SQL System Administrator or just DBO of the
config database?
Thanks in advance.
Angus LoganJust like the original setup, the service pack uses integrated security to
update the ReportServer database. You need to have dbo privileges to the
database on the machine where setup is being run.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angus Logan" <angus_logan@.data3.com.au> wrote in message
news:ebzCsMeWEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I tried to upgrade a clients site to Sp1 and got the following error:
> "SQL Setup failed to connect to the database service for server
> configuration. Refer to the Server error logs and setup logs for more
> detailed error information."
> I was just wondering if anyone else has come across this error and know
> any
> ways to fix it?
> Also does the account I am logged onto (or Term Served into) the box with
> require access to the Configuration Database or the Database Server?
> And I can't find any documentation on what security level is required for
> applying the Service Pack ie. SQL System Administrator or just DBO of the
> config database?
> Thanks in advance.
> Angus Logan
>

Error in SSIS package after upgrade to SP2 release

I upgraded to SQL Server 2005 SP2 release today. I had been working with 9.00.1399. I had developed few packages in the older version which were getting invoked through the asp web application locally and it was working fine.

Today I upgraded to SQL server 2005 3042 version.
Now the same packages are not working when invoked through the web application. But it works fine stand alone. All errors refer to connection problem.

I need to resolve this urgently. Can anyone help me please?

Errors -

"SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft JET Database Engine\" Hresult: 0x80004005 Description: \"The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.\".\r\n"

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

I have seen that error from time to time. it indicates that the excel file where the connection manager is pointing to is open by other application/process. I read a Phil's suggestions to use a third party to monitor and detect who is actually holding the file, but I don't remember the name.

In the mean time, try closing all applications that may be 'holding the file' and run the package again.

|||Hi,

The error appears due to the upgrade to the SP2 version.

I restarted my system. No other process accessing the excel.
But still the same error.
This functionality used to work fine with the older version of SQL.

Error in SQL 2005 cluster installation

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. Any idea ? The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Hi,

Did you resolve this? I have run into the same error and am unsure how to proceed.

Any advice would be warmly received.

Regards,

Rob.

Error in SQL 2005 cluster installation

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

Kind regards

Marcel

sql

Error in SQL 2005 cluster installation

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys inHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

Kind regards

Marcel

Error in SQL 2005 cluster installation

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

Kind regards

Marcel

Error in Bulk Insert after Windows 2003 Upgrade

My production support group upgraded the version of Windows Server from 2000 to 2003 on a stand-alone SQL 8.0 development server. I am using a bulk insert command in a stored procedure that is now failing as a result of the upgrade.

The error message is: Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.
OLE DB error trace [Non-interface error: CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a].

We have checked the following based on other posts we have seen.

1) Re-registered impprov.dll
2) We are at SP 3
3) We are at MDAC 2.8

We also verified by copying the DB to a dev server that has not been upgraded it still works. Does anyone have any other suggestions or experience that may help?

Thank you,
KellyJust being curious, did they do an upgrade without scratch and rebuild the server? If that's the case, your server would have registry problems. If your dev box is a dedicated db box, you can simply run the rebuild registry with sql 2000 installation CD and patch up with sp3 after that. If you still have problem, since it's a dev box, I would recommand that you take backups, sratch the box, install Windows 2003, install sql 2000, patch up to sp3, and then reload the database on to the server.|||Well, I made the suggestion that the server be rebooted after the unregister and re-resgister process and that seems to have done the trick. The DBA thinks that restarting SQL Server may have been enough. Thanks for the idea Joe.

Kelly