Home > IT Answers > Windows Server > Figuring out the SA password in order to upgrade to SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Figuring out the SA password in order to upgrade to SQL Server 2005
SBS 2003, Small Business Server 2003, SQL Server 2005, SQL Server administration, SQL Server upgrades, System administrator
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?

Software/Hardware used:
ASKED: December 5, 2008  6:38 PM
UPDATED: December 24, 2008  5:18 AM
RELATED QUESTIONS
Answer Wiki:
Each instance of SQL Server is independent unto its self. When it asks to log into the server you'll need to give it the server name and instance name to log. It is probably asking for the sa password for your specific instance.
Last Wiki Answer Submitted:  December 6, 2008  1:16 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

hello everybody
im new to this group.i completed my msccs in 2003.now im learning sqlserver dba,can anyone please send dba resume with 3yrs.
please send to my maild id: bjanaki@rocketmail.com
thanks in advance

123451
 35 pts.