You mean that the developers can? If so, you may want to investigate what rights they have in msdb. Jobs aren't normally something they should be able to execute (if...

That sounds possibly like a permissions issue at one of the folder levels. You may have one of your admins take a look.

Does the account specified for the cluster service account have administrative rights to both nodes? Have you verified you can ping both nodes from each other?

You must put the correct password for the Windows account you've specified will be the proxy account. And yes, when a non-Sysadmin runs xp_cmdshell, xp_cmdshell will execute as this Windows...

Nita Reddy (3/28/2008)

---

The AD account was created

I went to SQL server and through Management studio I went to Security and created a New Login through which was already created...

Tom Garth (3/28/2008)

---

Another option would be to setup a Server 2003 on a Virtual PC. they usually run better from an external drive, but since you have 2 HDs on...

For everyone's convenience:

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 1)

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 2)

How to create SQL...

Agreed, don't evict the node, it should not be necessary unless something is drastically wrong with the operating system configuration.

The maintenance plans not running makes sense from the perspective of...

In this case you'll need to add the login to SQL Server. If you're using SQL Server Management Studio, connect to your local server, expand the Security folder and right-click...

If it makes you feel any better, it's my particular department that has the current group problem since we once had a name that pushed us over the 25 characters....

If the web server is a different server than the SQL Server, then you can't. IUSR is a local account on the web server. When you get to the SQL...

This report will show you what changed, but it won't show you how it changed, like in an ALTER situation. The report actually derives from traces which you can find...

If you don't have a license for the developer edition of SQL Server 2005, Express is free, and you can always go the route of the time-limited evaluation copies. But...

As Steve indicates, the move itself doesn't usually impact SQL Server. The biggest issue is getting the servers to talk again on the network. Is anything else changing other than...

Can you describe your setup between the two nodes? Shared disk, network, etc.?