This is the alternate blog site for Pinal Dave. Both link to the same poster for download.

Tom Brown (5/7/2010)

---

Thank-you all.

I've had this data for 10 years now, maybe I copied it from someone's SQL 2000 book - or possibly it came from an SQL...

Paul White NZ (5/7/2010)

---

CirquedeSQLeil (5/6/2010)

---

Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped based on the...

newbie2sql (5/7/2010)

---

Hi Anshu,

As per your current scenario you will be able to login to the box if you are administrator on the...

Lynn Pettis (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Skipping the tent and...

Skipping the tent and just going straight...

Lynn Pettis (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Glad you saw his response before I...

Time for the tent

Is your windows auth account a member of the builtin administrators group?

Have you verified what permissions you have for your windows auth account?

Glad you saw his response before I did.

Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped based on the source document provided in...

I would just verify it via the GUI.

Login under your sa account and check the logins. Lynn has given some good resources for finding that.

woot - got it correct.

While providing the information already requested, you may also want to lookup linked servers in BOL.

Sounds like your windows auth hasn't been granted permissions to that database. Verify that you have the correct default database set and that your windows login has permissions to...