Windows 7 and SQL Server 2005 Standard

Question

Windows 7 and SQL Server 2005 Standard

Mark Shvarts 1

SSCertifiable

Points: 5702
More actions
December 5, 2009 at 3:56 pm

#136736

Will SQL Server 2005 Standard edition install on Windows 7 ?
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

both Standard and Enterpise will only install on server versions of windows: 2000 Server/Advanced Server, 2003 Server, etc.

Express, Professional, Workgroup, etc versions will install on any Windows Operating system, as they are for testing/development.

If you try to install Standard or Enterprise on a non server OS,, it will only let you install stuff like the client tools and BOL, but not the server service itself; they get grayed out of the installation, i believe.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

Correct, you must user server software for server versions. If you are trying to save money on licensing the server, you won't. You'll get yourself into trouble if you figure out a way to do it.

If you need to test things, you need to use developer edition on your client.

Mark Shvarts 1 SSCertifiable Points: 5702 More actions · Answer 3

Thanks Lowel and Steve for your replies, but I am little bit confused.

I have my SQL Server 2005 Standard Edition (and it is properly licenced) installed on my home PC which is Windows XP Professional Version 2002 Service Pack 2, it does not look as to be server OS.

From your replies it looks like I could not have installed my SQL Server in the first place. But everything seems to be working fine, both server and SSMS.

Lowell SSC Guru Points: 323518 More actions · Answer 4

That's weird Mark;

SQL 2000 would automatically dummy itself down to the Desktop version if you installed SQL 2000 Standard or Enterprise on a non-Server OS, but every time I've ever done 2005, it always auto-prevented the install;

could you select @@version to confirm?

mine says this on a 2000 advanced server, for example:

select @@version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

Nov 24 2008 13:01:59

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Mark Shvarts 1 SSCertifiable Points: 5702 More actions · Answer 5

Yes, here it is:

---------------------------------------------------------------------Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

Well we're wrong. It appears that as long as you don't have XP home you can install standard edition. This from BOL (http://msdn.microsoft.com/en-us/library/ms143506%28SQL.90%29.aspx)

I would assume that would apply to Win 7 in that as long as you have pro, ultimate, or something beyond the base, you can install Standard.