YIKES! Someone Installed SQL Server And Then Left The Building

Although Oracle is our main database vendor for our bread butter application, there tends to be several supporting applications that utilize everything from MYSQL to MS SQL Server and often times without consulting with the DBA team.

Today we needed to grant access to one of the application MS SQL Server that we were unaware existed. The individual has since left the company. We needed to gain access to the SA account and this is the way we did it without having downtime.

Thank you Mark Sussinovich and Aaron Bertrand for sharing.

It worked without issue for us. Wanted to ensure that I had this marked so that I remember the information as I’m sure it will happen again.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: