pbyrum (1/18/2010)

---

I can use Remote Desktop to this same server and use SSMS to connect and see other instances on the SQL Server, while having full admin rights to the...

:crying:

Other than Steve's suggestion there is the possibility that somebody removed the "Builtin\Administrators" from this Instances Security.

Are there other instances on this server? Are they properly functioning?

Also, could you...

pbyrum (1/18/2010)

---

Well, my account is a domain admin account and I have DBA rights to other databases when I login to other servers with SQL Server. I checked my AD...

envious

Are you able to login with an alternative account? (A SQL Login).

What about locally from the box, are you able to login with your NT account when you have remoted...

I agree with this. A senior person is oftentimes also a team lead...

Jealous

Just found this article. I thought this was a well-thought out article. There is useful information in the article - with some good ideas.

Like others, I am not...

michanne (1/18/2010)

---

I expect there are a lot of differing opinions out there and job description plays a role. Talking real world here - not certification requirements. Mainly I am looking...

This is good information to know. Thanks for the question.

I wouldn't mind seeing it move around. There are plenty of locations throughout the US that seem like viable options (Orlando, Las Vegas, Denver, Chicago, Dallas).

Splitting up into multiple...

GilaMonster (1/18/2010)

---

You can't. If I recall (and this needs to be checked preferably with...

felicitations

Chili