Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 626
  • Last Modified:

Microsoft SQL Server 2005 - 9.00.3062.00 (X64) Jan 8 2008 20:12:21 Copyright (c) 1988-2005 Microsoft Corporation Windows Internal Database (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)

Hi,

I am running SBS 2008 and have been told by some developers I need to install SQL Server 2005 Service Pack 2, can someone let me know if this is supported and where I can download the link?

Regards

Tahir Ahmed
0
Tahir2008
Asked:
Tahir2008
  • 4
  • 3
1 Solution
 
Matt BowlerDB team leadCommented:
http://www.microsoft.com/en-us/download/details.aspx?id=9969

However SQL Server 2005 is no longer under mainstream support, and support for service pack 2 has ended. My recommendation would be to go to Service Pack 4 if your application supports it.
0
 
Tahir2008Author Commented:
Thanks Matt,

I will speak with developer after SQL Server 2005 SP2 has been installed.

Regards

Tahir
0
 
Tahir2008Author Commented:
I've requested that this question be deleted for the following reason:

Unnecessary question, as per Matt's recommendation all the information is listed online.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Matt BowlerDB team leadCommented:
If my recommendation provided the answer, shouldn't I receive points?
0
 
Tahir2008Author Commented:
Quick question Matt,

When I run the SP2 upgrade it lets me select the files but does not let me select SBSMonitoring
|
|_Database Services

Or Client Components.

Any ideas? Is this normal?
0
 
Matt BowlerDB team leadCommented:
Yes, the service packs are pretty automated. If the components are not upgraded then you wont be able to select them.
0
 
Tahir2008Author Commented:
Matt,

I have received the following notice:

'By default, users on Windows Vista and later operating systems are not members of the System Administrators role for SQL Server or Analysis Services. To add users to the System Administrator role, user the check box below to launch the SQL Server 2005 user Provisioning Tool for Windows Vista after SP2 installation completes.

Do I need to do this step?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now