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 in deployment of Reports

Hello,
I have built a report on SSRS 2005 and wanted to deploy that report as a
URL. However, it gives me an error which reads - "The permissions granted to
user '<Machine Name>\IUSR_<Machine Name>' are insufficient for performing
this operation. (rsAccessDenied)". Any idea whats causing this error. I get
the same message when I try to log on to http://localhost/reportserver.
The IIS on the machine has anonymous access enabled as well as Integrated
Windows Authentication.
Thanks.Bingo (anonymous access). You are not given the rights to deploy because you
are anonymous.
Turn off anonymous access on Reports and ReportServer webs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vince Keller" <siliinvestor@.hotmail.com> wrote in message
news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have built a report on SSRS 2005 and wanted to deploy that report as a
> URL. However, it gives me an error which reads - "The permissions granted
> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
> performing this operation. (rsAccessDenied)". Any idea whats causing this
> error. I get the same message when I try to log on to
> http://localhost/reportserver.
> The IIS on the machine has anonymous access enabled as well as Integrated
> Windows Authentication.
> Thanks.
>|||That worked!
Thank you very much.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubRl21jPGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Bingo (anonymous access). You are not given the rights to deploy because
> you are anonymous.
> Turn off anonymous access on Reports and ReportServer webs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vince Keller" <siliinvestor@.hotmail.com> wrote in message
> news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have built a report on SSRS 2005 and wanted to deploy that report as a
>> URL. However, it gives me an error which reads - "The permissions granted
>> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
>> performing this operation. (rsAccessDenied)". Any idea whats causing this
>> error. I get the same message when I try to log on to
>> http://localhost/reportserver.
>> The IIS on the machine has anonymous access enabled as well as Integrated
>> Windows Authentication.
>> Thanks.
>

Error importing excel file

When ever importing a excel file or flat file, I get an Unhandled exception error and the event log reads a .Netframework error ID 1000.

Checking the database I was importing into, I find that the table was created with the columns, but no data within the columns.

The import wizards report 509 row copyed before crashing with the Handle error, where a dialog box appears allowing debug or close.

Can anyone help?

I include the logged errors.

Event Log

.NET Runtime 2.0 Error
Event ID: 1000

Faulting application dtswizard.exe, version 9.0.1399.0, stamp 434f5e2a, faulting module dtspipeline.dll, version 2005.90.1399.0, stamp 434f5dbc, debug? 0, fault address 0x0004ba38.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 64 00 74 00 73 00 .d.t.s.
0030: 77 00 69 00 7a 00 61 00 w.i.z.a.
0038: 72 00 64 00 2e 00 65 00 r.d...e.
0040: 78 00 65 00 20 00 39 00 x.e. .9.
0048: 2e 00 30 00 2e 00 31 00 ..0...1.
0050: 33 00 39 00 39 00 2e 00 3.9.9...
0058: 30 00 20 00 34 00 33 00 0. .4.3.
0060: 34 00 66 00 35 00 65 00 4.f.5.e.
0068: 32 00 61 00 20 00 69 00 2.a. .i.
0070: 6e 00 20 00 64 00 74 00 n. .d.t.
0078: 73 00 70 00 69 00 70 00 s.p.i.p.
0080: 65 00 6c 00 69 00 6e 00 e.l.i.n.
0088: 65 00 2e 00 64 00 6c 00 e...d.l.
0090: 6c 00 20 00 32 00 30 00 l. .2.0.
0098: 30 00 35 00 2e 00 39 00 0.5...9.
00a0: 30 00 2e 00 31 00 33 00 0...1.3.
00a8: 39 00 39 00 2e 00 30 00 9.9...0.
00b0: 20 00 34 00 33 00 34 00 .4.3.4.
00b8: 66 00 35 00 64 00 62 00 f.5.d.b.
00c0: 63 00 20 00 66 00 44 00 c. .f.D.
00c8: 65 00 62 00 75 00 67 00 e.b.u.g.
00d0: 20 00 30 00 20 00 61 00 .0. .a.
00d8: 74 00 20 00 6f 00 66 00 t. .o.f.
00e0: 66 00 73 00 65 00 74 00 f.s.e.t.
00e8: 20 00 30 00 30 00 30 00 .0.0.0.
00f0: 34 00 62 00 61 00 33 00 4.b.a.3.
00f8: 38 00 0d 00 0a 00 8.....

Debug Log

Unhandled exception at 0x2357ba38 in DTSWizard.exe: 0xC000001D: Illegal Instruction.

Would you be able to help us nail down this problem by identifying what data is exactly causing this crash?

You can do this by reducing the data set in your spreadsheet (i.e. take 10 rows around the row #509 and see if the problem reproes, than try to find the exact row, then the exact column if possible) and figuring out what is the data and data type of the cell that could not be handled.

In the case you can give us the entire spreadsheet or the minimal piece that still reproes the problem; we could start our investigation from there.

Thanks.

|||

Hi

I have cut down the excel file, still no luck. I have even created a new excel file with two columns and two rows and I still get the error. I have noticed the test file I created "test.xls" is imported with a $ "test$" .

test.xls

Temp Contract 1 231 2 234

This should be simple to import.

John

|||

Well, this is quite simple data and it should not cause any problem. It worked for me quite easy.

Could it be possible that you have some problems with your installation/binaries? What edition of SQL Server do you have installed? Have you installed some previous versions on the same machine?

|||

Bob,

Here are the version information:

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

There was no prevoius installations of SQL, However after installing SQL2005 I installed the MSDN disk that came with it, I believe there was an error, I uninstalled and re-install MSDN without any errors "Installation Successful".

John