2013-11-13 Perils of SSIS Logins Transfer

9pm – Harman gets me on Lync. He’s running some SSIS Logins transfer wizard for one of the new TAKO SQL servers we’re preparing to migrate to tomorrow and he’s now lost SQL access!

Great! looks like the wizard has dropped the builtin\administrators and a bunch of other logins.  what’s more he cant logon to the server to investigate.  So, I help the poor guy out (after all he is working evenings at my request):

Its the old trick – start sql in single user mode, add yourself as sysadmin ……

Resolution


Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer’s local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.

http://msdn.microsoft.com/en-us/library/dd207004(v=sql.100).aspx

 

Advertisements
This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

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

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