There are some details in some of the answers here: You can connect using the NT AUTHORITY\SYSTEM account (or other backdoor methods). The first two methods here do not require restarting the instance:įor SQL Server 2005, 2008, and 2008 R2 instances Once you have Management Studio installed, what you do next will depend on your SQL Server version, as well as whether you can afford to take the SQL Server service down in order to establish new credentials. (If your operating system is 32-bit, you should fix that first if you can't, you can download the 32-bit version of SSMS 2014 SP1 toward the bottom of this page.) (How else do you plan to perform maintenance tasks once you have access to the instance?) I recommend the most recent version of Management Studio which is fully functional, manages 2005 instances just fine, and is completely free of any licensing requirements. Well, you can start by installing Management Studio.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |