Is my SQL Server Correctly installed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Is my SQL Server Correctly installed

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2009-01-16 : 07:20:56

Hi All,

Firstly thanks for looking…..

I am having problems with an install of SQL 2005 and in particular the failover clustering.

Basically I have found its running very slow at time, but there is no problem with memory or processors.

I have inherited the box and a wondering if the SQL install was correctly done in the first instance.

If I select the version I get the following:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37 Copyright (c) 1988-2005
Microsoft Corporation Standard Edition on
Windows NT 5.2 (Build 3790: Service Pack 2)

But the Management Studio is Express Edition but running Standard Edition (is this correct?)

As its Express Edition of management studio I am limited to the functions I can perform. Maintenance tasks and so on

I know clustering is not an option with Express edition, but will the express edition of management studio stop this working? As we have had some issues with the cluster and it does not failover to the other node.

Where would be the best place for me to start?

Help!!

Kind Regards

Pete.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-16 : 10:10:19

It is showing that you have SQL Express Edition (RTM) edition in Standard Edition OS. You should atleast have SQL Server 2005 Standard Edition to do Clustering.Also you should apply recent Sp and patches.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-16 : 11:28:13

you can get the edition details directly using SERVERPROPERTY(Edition) and also level of version using SERVERPROPERTY(ProductLevel)

petek
Posting Yak Master

192 Posts

Posted - 2009-01-19 : 04:04:05

Thanks both.....

visakh16

If i run the following:

SELECT SERVERPROPERTY('productversion')AS 'Product Version',
SERVERPROPERTY ('productlevel')as 'Product Level',
SERVERPROPERTY ('edition') as 'Edition'

It returns the following.....

Product Version:
9.00.1399.06

Product Level:
RTM

Edition:
Standard Edition

But it has Management Studio Express Installed.

Kind Regards

Pete.

petek
Posting Yak Master

192 Posts

Posted - 2009-01-19 : 04:12:18

in addition properties from management studio.....

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

Kind Regards

Pete.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources