Did someone rename a service account ???

In that case, drop the login from sqlserver and add it again.

Sqlserver stores Windows account by its Windows "guid", so dropping an account and...

which network protocols are opened for connections ?

keep in mind if you start an instance manualy you need to start:

net start mssql$instancename

- Doublecheck the cluster account

- bring all resources online except for the sql-instance

- Then use 'net start yourinstance', and check the account has login rights (NO sysadmin auth needed !)

-...

Normaly if you want separate rows, perform separate selects or take things in your own hands(meaning you perform positioning yourself at front end)

Still I'd run SQLUpgradeAdvisor to check the db for possible issues with sql2005 compatibility and try to convice the customer to perform detailed testing with SQL2005 mode !

Keep in mind,...

- first of all you have to be sure you've got a valid backup.

maybe even create a new backup using the backup panels.

(tick "validate backup at the end of backup"...

use a query window in management studio

Check out Restore database in BOL.

restore database yourdatabase

from disk='\\yourfirstserver_UNC\path\backupfile'

-- with move if you want to use new filepaths for mdf and ldf

Your...

how about :

select sum(case when condition1 then 1 else 0 end ) as whatevernameyouwannegiveit

, sum(case when condition2 then 1 else 0 end ) as whatevernameyouwannegiveit_theSecond

from yourobject

have a look in the cluster log as well as the sqlserver errorlog file.

(C:\WINNT\cluster\cluster.log)

all service accounts that have a relation to your sqlserver instance need at least instance level login auth.

The clusterservice account ('RTDOMAU\svc-proxy-pclust') just needs login rights to the sqlserver instance...

use yourdb;

-- Based on (class=0,object_id=27199197,column_id=0,referenced_major_id=11199140

select object_name( 11199140 ) as ToBeRevised

, object_name( 27199197 ) as ToBeRevisedToo

Oops :blush: ... this thread is in the SQL2005 forum ...

the methode I explained is not possible with SQL2000.

So you connect to a sqlserver instance and specify a dbname,.....

with SQL2005 Express Edition, you can "in line" attach a mdf-file only on the local instance !

Attach a database file on connect to a local SQL Server Express instance

...

TommyB has given you the solution.

Afterward you should restart sqlserver "normal".

On the other hand, I wouldn't advise tempdb to reside on Raid5 ! Best is to put is on a...