I am upgrading my firm’s legal software to a version that uses SQL Server 2005. We are on a Windows 2003 Small Business Server, and SQL Server was installed before I started at this firm. My new software needs me to login as the System Administrator. I cannot seem to do that, as I do not know what the password is. I have installed SQL Server Management Studio Express but I cannot seem to figure this out. I can go into each of the instances and change the SA password for each of them, but it seems that there needs to be some way to log into SQL in general. The install gets to a point and asks to log into the server and has a note that states that this is the SQL login, not the administrator login. What can I do?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!