The following will get you login names, SIDs and hashed passwords

select name, sid, password_hash from sys.sql_logins

check the sql server log again carefully, if the backup command failed it will be in there!

if all the instances are registered under a SQL Server 2008 central management instance use the following query to add the group and assign sysadmin privileges

CREATE LOGIN [domain\group] FROM WINDOWS

EXEC...

the virtual network name already exists, ping it and see if it replies.

If it doesn't and to proceed and use this network name, delete the computer account from AD and...

Group or application it amounts to the same thing. Either way I would do what I posted above 😉

for XP Home, boot into safe mode to set share\folder permissions via the share and security tabs and then reboot normally

are you attempting to add a node to an existing clustered instance of sql server?

AK1516 (3/31/2011)

---

We have the SQL SERVER 2008 fail over Cluster installed on the Windows Server 2008 r2.There is Power outage to upgrade the system inn data center i.e The boxes...

what port numbers have you assigned to the mirroring endpoints on the principal and mirror instances

Brandie Tarvin (3/30/2011)

---

Perry,

I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it...

A database that is set as read_only is exactly that, can only be read no backups may be rstored. To write to the database you would need to perform

ALTER DATABASE...

yes and that wil be fine, the service account is only disabled for use inside the sql server instance...

launch the service pack installer and install on each passive node. Once this is done, Fail over the active node so it becomes passive and patch that.

Hi

i use BCP to dump syslogins to a file, copy it to DR server and then import

annasql (3/30/2011)

---

but I see it will also disable the old service account.

see http://msdn.microsoft.com/en-us/library/ms345578.aspx

But we do want to keep the old login for other server's access. How can we make this...