Recovering access to a SQL Server that you don't have 'sa' access to anymore

It's happened to most all of us at one time or another; an instance of SQL Server has been inherited where no one knows the sa password, or is a member of the sysadmin role, it's annoying when it's a SQL Server instance on a Development or Test server, but becomes far more problematic when it's on a production system. Fortunately, there's a way to solve this.

About Rob

I've been interested in computing since the day my Dad purchased his first business PC (an Amstrad PC 1640 for anyone interested) which introduced me to MS-DOS batch programming and BASIC.

My skillset has matured somewhat since then, which you'll probably see from the posts here. You can read a bit more about me on the about page of the site, or check out some of the other posts on my areas of interest.

No Comments

Add a Comment