A login is a server principal. That login does not have rights to the database in question. Check your permissions.

I'd highly disagree with this. Just because it can be done...

My $0.02 added.

Do the databases exist now? Are they in use?

I dislike multiple instances because I have to make a hard decision about how to split memory among the instances, but you...

Brandie Tarvin (12/29/2010)

---

Okay. WIT 24 hours of PASS is accepting abstracts for March. I'm assuming this is Pre-Rally 24 hours of PASS (haven't had a chance to double-check the dates)....

paul.knibbs (12/29/2010)

---

Jeff Moden (12/28/2010)

I just love the way companies like MS force you to upgrade... at gunpoint. They'll still sell you stuff so it's not like they're all holy...

The images have been corrected. My apologies for the issues.

WayneS (12/28/2010)

---

Okay, let's talk about blogging. I've seen a few posts from time to time, but I don't recall seeing anything dealing with:

(From a higher level) How to set up...

Backup history is here:http://msdn.microsoft.com/en-us/library/ms188653.aspx

A backup is typically run as a job, so any information is available as part of job history: http://msdn.microsoft.com/en-US/library/ms174997%28v=SQL.90%29.aspx

Doh!

I have seen teams like this, and while you do need to be highly skilled, it's important that you start to get new people involved, and help them grow. One...

Maybe these will help? Need to qualify based on what is "new", but these might get you started.

http://blogs.techrepublic.com.com/networking/?p=3028

http://www.simple-talk.com/sysadmin/exchange/active-directory-management-with-powershell-in-windows-server-2008-r2/

We don't have 32, but we currently have 4 cats, 3 dogs, 2 guinea pigs, and 6 horses. Had 9 horses until last month.

Actually I would suggest that you, the original poster, try to normalize this according to documentation and ask if you are correct, or ask specific questions about whether your design...

There are places that can query AD from SQL Server, here's one: http://blogs.msdn.com/b/euanga/archive/2007/03/22/faq-how-do-i-query-active-directory-from-sql-server.aspx

However what you might want to do instead is use Powershell and find new users in AD. http://technet.microsoft.com/en-us/library/ff730967.aspx