You said "Note that for the same servername, it works fine from a command prompt."  Do you mean that you can run a dir command on a Windows box to...

I don't remember where I got this, but perhaps it's the example you were referring to.  Works fine.

use pubs

if object_id('workaround')>0

drop view Workaround

go

create view Workaround as

select

au_id

, au_lname

, au_fname

, convert(char, contract) 'contract'

,...

Execute sp_who2 and you'll see the active node listed under Hostname somewhere.  Under Program Name you would see "Microsoft® Windows® Operating System" if you have Windows 2003.

Linda 

It may also depend on where the Access database actually sits.  Is it on a shared resource of the cluster where all nodes would be able to use it, or...

What are your jobs trying to do?  BCP or FTP files to another server?  Do they run DTS packages or procedures?  Can you run the jobs manually, or their pieces?  Are there...

I recently got a book entitled "Microsoft SQL Server 2000 High Availability" and in Chapter 6 for failover clustering it says to make the changes in Enterprise Manager.  It's a...

Thanks for the suggestion, but I've tested different log shipping intervals and got the same error.  I've also tested backing up the database, copying, and restoring to the other server...

I usually don't allow users in msdb at all, but when it's absolutely necessary I use the TargetServerRole and it works just fine.  You can control the exact permissions that...

I found Article 836873 that fixed the issue--not necessarily related to Reporting Services--of getting an error creating a database.  It says that the problem occurs because the DefaultData and DefaultLog...

Thanks, but I stated earlier that the production box is installed on F, and I cannot change that.  I can't find any documentation that it has to be on C but...

Maybe I didn't explain clearly... I don't change the ownership back and forth.  I just stated that the ownership could be changed if needed.  The vendor applications will not use...

Just for an opposing point of view, let me say "It depends".  We have a number of databases that are owned by a standard login account.  The reason?  Third party applications. ...

When you said "it could not write to this drive" meaning the quorum, what was the exact error message?  (Permission issue, Resource issue, etc.)  Why don't you try manually failing...

In case anyone is interested, I found a workaround for reporting from a log shipped database.  First, I had to find a solution to the orphaned logins on the read-only stand-by server. ...

When you're going through the Export steps you will get to a window that says "Select Source Tables and Views".  When you select a table you will see in the Destination...