Hi,

We have a/a/p cluster setup of sql server 2005 ee x64 with SP3 on windows 2003 EE x64.

on Node1 we have one instance and node3 we have 4 instances.

For the...

Thank you..

My issue hasbeen resolved!!!!

I used the cluster administrator to stop and start the sql agent and then I restarted the Monitoring tool, now everything is fine

Thank you

iam seeing this error in quest spotlight monitoring tool. Where can I look for this error in sql server.

I check the erro log and sql server agent error log but...

Cluster manager means the Cluster administrator, where we can take the resources offline and online?

even I took offline the sql server agent and bring it online from cluster administrator still...

Hi,

From BOL,

So I did start the sql server agent...

Could you plz give me some idea on this...

You can apply CU1 for SP3

Thank You,

Is his on the node where you implemented the SP3 or on one of the other nodes ?

Did you apply sp3 (for the client software (ssms)) to all nodes...

That means, I need create the report server database using report server configuration manager before the developers deploy their rdl files into report server right?

correct me If I understand wrong?

I did this by going to the active node and connecting virtualserver\instance and management studio, query editor

Hi All,

do we need to choose the Latin1_General_CI_AS_KS_WS collation setting while installation of SQL Server 2005, when we are planning to store sharepoint databases in sql server?

We installed sql server...

Thank you,

-- show advanced configuration options

EXEC sp_configure 'show advanced options', '1'

RECONFIGURE

GO

RECONFIGURE;

EXEC sp_configure;

Result:

name min maxconfig_value run_value

Agent XPs01 ...

Thank You,

-- show Agent XPs state (0/1)

EXEC sp_configure 'Agent XPs'

GO

Result:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51

The configuration option 'agent XPs' does not exist, or it may be...

Hi,

anybody experienced with maintaining sharepoint databases in sql server 2005, please advise me on rebuilding indexed and as well as the other important things to consider

Thank you

No, I did not run so far..because the agent is running fine. So even it is running fine do I need run this script?

Its happened after applying SP3. We have...