A vendor installed an instance of SQL Server Express that supports an important application. Assume the vendor thought the Builtin\Administrators login was still a default for 2008 as it was for 2005. The sa password is unknown. How to gain access to the database server?
Added myself to the Windows Administrator Group.
The service owner is ‘Network Service’.
Still no connection but will keep testing ideas.
The biggest challenge to implementing a standardized maintenance plans in a wide-spread environment is finding where the SQL Server instances reside. The proliferation of SQL Server instances is a side effect the virtual environment. Super easy to just spin up a new server. Servers are created and SQL server is installed. The install is usually guided by the software vendor or a well-intentioned department professional. Maintenance does not get the consideration required.
Now a full-time DBA is on site and ready to wrangle all the servers into a stream lined configuration with a very secure and desirable assortment. Guided by Ola Hallengren http://ola.hallengren.com/ These servers will be maintained. No more log bloat, recovery ability meeting the SLA, and peak performance on the indexes. Good times ahead!
I’ve had the official title of ‘DBA’ for five years now and worked with data and databases for the past fourteen years… Wow hard to believe time has marched on like this. In my previous positions databases have been the company business. We sold data and or sold the service of managing data. Software development, data hygiene, database and data warehouse design were key to the work performed…
Not any more. Now all the applications are third-party, little custom developement and of course timelines are tight. The motto of, “Throw it out there and fix it later.” is certainly an acted upon option. We all know just when things will get fixed. Now that I am experiencing a wholly different perspective on delivering SQL Server solutions it is time to start a blog about it.
Welcome to my blog on SQL Server in the legal environment!