The login Amtpl is already mapped to a different database user. Use the following to identify the logins current database user account

use [yourdb]

selectd.name as DBUsername

, s.name as Loginname

from sys.database_principals d

inner...

No, the cluster service should be left as is. The issue is because the Cluster Name object does not have permission to create Virtual Computer Objects. Either pre stage them...

dajonx (4/7/2014)

---

Please work with your domain administrator to ensure that:

- The cluster identity '2012CLUSTER$' has Create Computer Objects permissions. By default all computer objects are created in the same container...

Not necessarily, security can still be implemented effectively on workgroup computers, it's just harder...

DKG-967908 (4/7/2014)

---

Thanks Perry for the response.

1. But what the Microsoft best practice says about this.

2. If we consider from security point of view - SQL server should be on domain...

Joining a server to a windows domain provides centralisation of uses and resources.

Computers in a workgroup require users and objects to be maintained locally on each machine. When providing...

what size did you shrink the file too?

PHXHoward (4/3/2014)

---

I'm looking for a solution to have cross data center automatic failover in the event of a data center loss for highly critical databases. I would like to have...

Yes, so if you follow my steps above you'll recover with no issues

Talib123 (4/3/2014)

---

Thanks Gail, was hoping you would reply. I'll have a crack with your advise later. Only my sandpit environment so BAU comes first. If I ever get the time...

ok, didnt spot that

lol convert this

0x646F6E2774206265206120646F726B20203A2D29

Talib123 (4/2/2014)

---

While trying to move the MSDB and Model DB, I mistakenly ran the following

ALTER DATABASE model

MODIFY FILE (NAME = modelData, FILENAME = 'D:\New folder\model.mdf')

GO

ALTER DATABASE model

MODIFY FILE (NAME =...

The software requirements list Windows 2012 or Windows 2008 only for Enterprise edition, see this link

And as part of your AO group deployment you've already identified a preferred Primary 😉