thanks for the info guys. its helped clear up my questions.

Perry Whittle (1/8/2012)

---

Is your laptop part of a windows domain. You need to be able to provide and resolve FQDNs?

To setup mirroring in a workgroup you need to take a...

thanks guys. Mirroring still wont work on my lab (laptop actually).

Setup:

Instance1 (principal)

Instance2(mirror)

Steps:

1. Full Backup of Testdb on principal

2. Restore backup of Testdb to mirror with norecovery

3. TranLog backup of TestDb...

That procedure relies on a detatch andreattach of the db, so it's not really a backup and restore of a tde database. It's moving of a tde database.

I was...

Yea,I was taking a backup of an encrypted db on one instance and restoring it to a second instance.

And yes, each instance SQL srvc is running under a different account.

Steve Jones - SSC Editor (1/3/2012)

I might recommend going with a Fire instead of a Kindle, mainly because of the additional capabilities to handle things like HTML items better. That...

thats a fair point.

It shouldnt be difficult, as kindle is just a html reader really. have the TOC as links and format the doc in HTML and your golden. publishers...

I have no specific need right now, but thought it should be possible. If you had a loooong chain of objects, and you want to ensure permissions are explicitly checked...

To follow up on this, i have the kindle a few months now. I love it and dont leave home without it.

Its awesome for reading novels but it sucks for...

Success!

After adding the accountB to the administrators group, i still could not restore the cert.

I had an idea that perhaps sql service was still operating under the credentials of...

Stewart "Arturius" Campbell (12/29/2011)

---

Please refer to FILESTREAM Overview, specifically the section regarding "Integrated Security", quoted here for ease of reference:

Only the account under which the SQL Server service account runs...

Managed to repro this issue, based on some research. not sure if it is the same issue as my collegue experienced but i get the symptoms discussed.

Your query needs...

You could use multi server jobs, see a tutorial here:

http://www.sqlservercentral.com/articles/Administration/multiserveradministration/675/

Ive tried them but found them a bit buggy and dont have time to resolve all the bugs.

Ensure you set the...

K. Brian Kelley (11/16/2011)

---

Kerberos authentication was likely set up. Was Kerberos delegation configured? This is required to go through the linked server connection to another SQL Server using the passed...

Would a bug of this scale ( its pretty big IMO that you cannot use linked servers with Windows Logins over Kerberos) go unfixed since sql server2000? Im using sql...