Is this your only SQL server or a new server to your environment. If so why arent you using domain account to run the services? I always use one account...

You would need to ensure the server collation is set to what you would expect and rebuild your master database (and any others).

Read the section on rebuilding master. It...

liteswitch (10/30/2008)

---

The NT Authority\Anonymous Logon is the clue here I think, as I've had this before.

quote]

Also, good practive is to run the SQL services as a domain account.

Makes it easier...

Like I have siad in recent posts, you need to have two instances of RS.

Is it direct attached or NAS/Shared Disk?

Unless you can set disk shares up you cannot run a clustered solution. It is possible with vmware.

There must be shared disk for quorum,...

1. All data processing kept on an already active SQL server (no need to install, configure and maintaine...

madhu.arda (10/29/2008)

---

do we need to place 1 set of the report server n tempdb on Production server 1(for sharepoint)

and other report server n tempdb on Production server 2(Native mode...

ThomasLL (10/29/2008)

---

Based on the couple of questions you have posted, I would suggest to you to go to some SQL Server Administristration classes focused on databases, files and maintenance.

You questions...

Ok, so think I understand a bit more now what your trying to achieve. Below is a link to a web cast which will explain basic SQL clustering setup and...

Schadenfreude-Mei (10/29/2008)

---

Ok so if you have a read of: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx it explains some key considerations. Figure 4 gives you...

So...

Thats correct. Though...

I may have misunderstood at some point so apologise if this is wayyyyyy off track.

If you want to have the 4th server as the RS server, that is actually...

What you can do is set up a job to back the t-log up frequently and then have a job on the other server to restore the log to a...

Not sure what you are trying to achieve here. Clustering is essentially for fault tolerance NOT performance (load balancing), so active/active is not going to share your work load.

With regard...