No SQL sysadmin Access

I was working on a Dev environment today and found that when the developer had configured SQL they left themselves as the only sysadmin. This was before we had created a standard Dev image and I found myself unable to log into SQL.

Apparently in Server 2008 you no longer get access to SQL by default if you are in the local admin group.

Fortunately I found this script @ which did the trick for me. Kind of a useful little item to keep handy.


About Mr_SHeister

Geek, Dad, SharePoint Administrator
This entry was posted in Troubleshooting and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s