Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Server 2008 Upgrade Gotchas & Fixes Expand / Collapse
Author
Message
Posted Tuesday, November 17, 2009 12:12 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 11, 2014 1:02 PM
Points: 64, Visits: 360
Comments posted to this topic are about the item SQL Server 2008 Upgrade Gotchas & Fixes
Post #819840
Posted Tuesday, November 17, 2009 2:33 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 1,451, Visits: 2,911
Another gotcha you need to add the hotfix for filestream regardless of whether you select to use it (Windows 2003) http://support.microsoft.com/kb/937444/.

Also on a new install of a 2008 cluster no matter what you do the default collation installed willl be SQL_Latin1_General_CI_AS so to change it you need to rebuild the Master database, its OK if you upgrade from 2005 the collation won't be altered, so you won't have this issue.


Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #819903
Posted Tuesday, November 17, 2009 3:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 1:06 AM
Points: 1, Visits: 25
I recently upgraded a SQL Server 2005 Express installation to 2008 Express (with advanced).

My gotchas were:
1)Permissions on the new reporting services installation - much fiddling required to allow anonymous users to render reports without being prompted for username/password
2)Reporting services on port 8080 - I had to make changes to the web app to allow a port to be specified in report URL's, I also had to get port 8080 opened on the firewall, because the server in question was locked down to only allow traffic on port 80.

Post #819919
Posted Tuesday, November 17, 2009 7:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
we might go to R2 next year, but will probably wait until 2011. for the 2005 upgrade we waited until SP2 was released and PSS was still swamped with support calls and the quality of the support was so so.

i priced out some new hardware yesterday and it's amazing how much power you can get. but the 32nm CPU's come out next year and we'll probably wait for that as well


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #820022
Posted Tuesday, November 17, 2009 9:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 9:26 AM
Points: 21, Visits: 25
If the DB server doesn't have Visual Studio installed, but does have software that uses .NET 3.5, is it really necessary to install VS2008 SP1? Isn't there a .NET framework patch or something that will do the job?

Seems like a lot to install VS just to upgrade SQL Server.
Post #820189
Posted Tuesday, November 17, 2009 11:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 11, 2014 1:02 PM
Points: 64, Visits: 360
BIDS is VS2008. CRM & MOSS2007 have the updated .NET framework.
Post #820263
Posted Tuesday, November 17, 2009 1:00 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:28 PM
Points: 962, Visits: 940
If you have VS already installed, you'll need SP1 to proceed. No need to install VS 2008 just for the SQL install.

Hope that helps.

Great little article, and the gotcha about the filestream fix should get added to the main article. I found that to be problematic.

If you are using a slipstream install, I would also make sure to do the 1) installer 4.5, 2) .net 3.5 sp1, and 3)filestream fix, then a reboot, then do the SQL install.

Take care,
Steve
Post #820342
Posted Wednesday, November 18, 2009 7:28 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 5,847, Visits: 12,579
requiring RS for SUA seems a right royal pain. You have to ask yourself why.

could 2008 clients have been rolled out before the server upgrades? Does 2008 client tools support earlier versions as 2005 does 2000?


---------------------------------------------------------------------

Post #820829
Posted Wednesday, November 18, 2009 7:31 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
i run SQL 2008 management tools on my PC's and 2005 in production. the client tools work great and offer more functionality than the 2005 Management studio. only thing is SSIS won't work. packages created in 2008 won't work on 2005 servers

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #820832
Posted Wednesday, November 18, 2009 7:41 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 5,847, Visits: 12,579
SQL Noob (11/18/2009)
i run SQL 2008 management tools on my PC's and 2005 in production. the client tools work great and offer more functionality than the 2005 Management studio. only thing is SSIS won't work. packages created in 2008 won't work on 2005 servers


thanks!


---------------------------------------------------------------------

Post #820842
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse