SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor.

Question

Post reply

SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor.

kedarnath_mundluru

Valued Member

Points: 69
More actions
December 9, 2007 at 11:55 pm

#184743

hi
i am trying to add DTS services using Upgrade advisor i am getting error below like this
this the error
"SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor"
please anybody knows this problem please let me know

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

Upgrade Advisor is designed to scan versions 7.0 and 2000, not SQL 2005. Version 9.0 is. SQL 2005.

Greg

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I'm trying to upgrade a SQL Server 2005 Professional Edition Database to 2008.

I get the following error and I saw the previous thread.

SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor.

Could you please expand on this?

In the past I have only used the upgrade advisor to upgrade from SQL Server 2000.

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Welsh Corgi (4/10/2010)
I'm trying to upgrade a SQL Server 2005 Professional Edition Database to 2008.
I get the following error and I saw the previous thread.
SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor.
Could you please expand on this?
In the past I have only used the upgrade advisor to upgrade from SQL Server 2000.
Thank you.

There is no professional edition of SQL Server and I think your error may be related to missing service packs in your SQL Server 2005. So make sure your SQL Server 2005 is SP3 and then try the upgrade again.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

My bad, I meant to say Enterprise Edition.:-P

I do not like the limited functionality with the Standard Edition.

I had applied SP3 but I just checked using SELECT SERVERPROPERTY('ProductLevel') and it shows that I'm running RTM.

I tried running the SP3 MSI and I got the screen asking if I wanteed to repair modify, etc.

That is wierd for I never had an issue applying SP's.

I will research further.:w00t:

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

Welsh Corgi (4/10/2010)
My bad, I meant to say Enterprise Edition.:-P
I had applied SP3 but I just checked using SELECT SERVERPROPERTY('ProductLevel') and it shows that I'm running RTM.
I tried running the SP3 MSI and I got the screen asking if I wanteed to repair modify, etc.
I will research further.:w00t:
Thank you.

Choose the repair option it will fix what is making your build show RTM.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Thank you but I just tried this.

I'm doing this from my home HP Professional Desktop.

I'm using the SQL Server Developer Edition that I acquired via the Microsoft Academic Alliance.

I have the Enterprise Evaluation Disk as well.

I have 28 points towards the Microsoft Certified Partner (25 points Small Business Solution Specialist) but since I'm not currently associated with an entity and I do not have have access to all of the software.

Could it be an issue with the Developer Edition not applying SP3 correctly?

I should troubleshoot this on my own but I greatly appreciate the help because I have a lot that I want to accomplish in a short period of time.

Thank you so much.

Regards,

Welsh

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

Welsh Corgi (4/10/2010)
Thank you but I just tried this.
I'm doing this from my home HP Professional Desktop.
I'm using the SQL Server Developer Edition that I acquired via the Microsoft Academic Alliance.
I have the Enterprise Evaluation Disk as well.
I have 28 points towards the Microsoft Certified Partner (25 points Small Business Solution Specialist) but since I'm not currently associated with an entity and I do not have have access to all of the software.
Could it be an issue with the Developer Edition not applying SP3 correctly?
I should troubleshoot this on my own but I greatly appreciate the help because I have a lot that I want to accomplish in a short period of time.
Thank you so much.
Regards,
Welsh

No because I just run your code in my install and it shows SP3. So post your operating system edition and we can work to resolve your problem. The Academic edition is like all other editions only require Academic employment ID or student ID verification.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

Windows XP Pro Version 2002 SP3.

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 9

Welsh Corgi (4/10/2010)
Windows XP Pro Version 2002 SP3.
Thank you.

Then make sure you have .NET framework 3.5 and 3.5 SP1 installed before you run setup for SP3. Another thing that may help you is to install any of the free VS2008 Express editions and the system will know SQL Server 2005 must be at least SP2 and up. So go to your C drive Windows then Microsoft.NET folder and click on framework to see your version before running the SQL Server installer.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

I have used the Development version that included features only available in the Enterprise version.

I have a valid copy of the Development Version for I obtained it from the Department Head of the Academic Institution. I chose the option to purchase the disk as opposed to downloading the software.

I do not have any unauthorized software and I would never do so.

Thank you very much Sir.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 11

Welsh Corgi (4/10/2010)
I have used the Development version that included features only available in the Enterprise version.
I have a valid copy of the Development Version for I obtained it from the Department Head of the Academic Institution. I chose the option to purchase the disk as opposed to downloading the software.
I do not have any unauthorized software and I would never do so.
Thank you very much Sir.

That is a misunderstanding about my previous post, I wanted you to install VS2008 because that makes the system update all systems that requires the .NET framework. My apologies for the misunderstanding.

So download the VS2008 you can download and install it or just verify the .NET framework version in your C drive before running the SQL Server installer.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 12

Yes .NET framework 3.5 & SP1 was installed prior to the installation of the Upgrade Wizard.

Thank you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gift Peddie SSC Guru Points: 73570 More actions · Answer 13

Welsh Corgi (4/10/2010)
Yes .NET framework 3.5 & SP1 was installed prior to the installation of the Upgrade Wizard.
Thank you.

You have two options either install the SQL Server 2008 as a named instance or use Windows System Restore to roll your operating system to a point before your SQL Server 2005 SP3 install and run SQL Server SP3 setup again.

Kind regards,
Gift Peddie

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 14

I'm sorry but could you be more specific?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/