Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Contributor
Posts: 38
Registered: ‎10-24-2011
My Device: Torch 9800
My Carrier: Telus

In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

HI

 

This is my first time posting on this forum so if I'm missing any information please let me know.

 

I currently am running BES 4.1.7 on a windows 2003 server with SQL 2000. The BES server is syncing with exchange 2003. I would like to do an in place upgrade to BES 5.0 but I'm not sure if I need to upgrade the SQL server first or will the upgrade installation perform this upgrade for me.

 

Any help would be greatly appreciated.

Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

you need to upgrade to SQL 2005 express first which is fairly painless.

 

info here to do it

http://technet.microsoft.com/en-us/library/cc966393.aspx

 

 

then you can do the inplace upgrade to BES 5.

 

 

 

 

Here is most of the documentation you need will to install and administer the BB 5.0 server:

 

Server 5.0 Upgrade Paths:

http://na.blackberry.com/eng/services/server/upgradepath.jsp

 

Server 5.0 Intsallation Support:

http://na.blackberry.com/eng/support/software/serverinstall.jsp

 

 

Server 5.0 Upgarde guide:

http://docs.blackberry.com/en/admin/deliverables/7315/index.jsp?name=BlackBerry%20Enterprise%20Serve...=

 

BlackBerry Enterprise Server Resource Kit Docs and Files

https://www.blackberry.com/Downloads/entry.do?code=D736BB10D83A904AEFC1D6CE93DC54B8

 

http://docs.blackberry.com/en/admin/subcategories/?userType=2&category=BlackBerry%20Enterprise%20Ser...

 

Server 5.0 Admin Tutorial:

http://docs.blackberry.com/en/admin/deliverables/7466/flash_start.html

 

All Server guides:

http://docs.blackberry.com/en/admin/?userType=2

 

Then when you are done with the above follow this one if going to 2010.

 

How to migrate the BlackBerry Enterprise Server 5.0 from Microsoft Exchange Server 2003 or 2007 to M...

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Contributor
Posts: 38
Registered: ‎10-24-2011
My Device: Torch 9800
My Carrier: Telus

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

This document is for upgrading Microsoft SQL Server Desktop Engine 2000, I have Microsoft SQL Server 2000.

Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

is it a dedicated remote Full SQL server?

 

If yes then the process is still about the same to upgrade to Full SQL 2005.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Contributor
Posts: 38
Registered: ‎10-24-2011
My Device: Torch 9800
My Carrier: Telus

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

Yes it is a deticated SQL server that runs on the same physical box as the BES 4.1.7

Highlighted
Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

Are you sure it is a full blown SQL server? can you goto add remove programs and report back the version running please?

 

Many times people think it is a full blown SQL server and it is MSDE but in add remove programs it is shown as SQL.

 

I dont know many that would install such and expensive software on their BES, they usually have a dedicated SQL server for this.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

this should help you figure out its version

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Contributor
Posts: 38
Registered: ‎10-24-2011
My Device: Torch 9800
My Carrier: Telus

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

SQL 2000 v8.00.2039 which I beleive makes it SP4

Guru III
Posts: 32,114
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

in that case you should be able to install SQL 2005 with BES servies turned off, reboot and it should work.

 

Or if you dont want to buy full SQL you can use express.

 

Either way this will upgrade it

How to upgrade MSDE 2000 to SQL Server 2005 Express

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Contributor
Posts: 38
Registered: ‎10-24-2011
My Device: Torch 9800
My Carrier: Telus

Re: In place upgrade of BES 4.1.7 running SQL 2000 to BES 5.0

Hi

 

I ran the setup for SQL 2005 Enterprise and received the following error message from the Upgrade Advisor

 

 

SQL Server 2000 Meta Data Services packages are not supported

 

Existing Meta Data Services packages should be moves to SQL Server storage (in the msdb database) or to structured storage files before you upgrade from SQL Server 2000 to SQL Server 2005

 

When I look under Data Transformation Services I do not see any packages listed.

 

What do I need to do in this instance to continue with the upgrade.

 

Patrick