SQLServer.in

Here is a useful link from SQLTeam on sql server versions,fixes & patches till date. The link is so perfect since the page is updated on a regular basis by author Bill Graziano.

http://www.sqlteam.com/article/sql-server-versions

Follow the below guide lines when changing/selecting an SQL Server or SQL Server agent service account.

Make sure to change the service account from Enterprise Manager(SQL 2000) or Configuration manager
(SQL 2005). If we change from the services.msc panel, it will not update certain details like windows user
rights, registry rights & file system rights, which may create issue like sql or agent not starting.

Also note that , its always better to have 2 domain service accounts , 1 domain account for sql server with local system privilege
& 1 for sql server agent with local system admin privilege.
For SQL Server 2000 use Enterprise Manager , follow the guide lines

1) Open Enterprise Manager
2) Right Click in the sql server -> Properties

3) Go to Security tab, in the Startup service account, give the new service account & click ok

Also for changing the service account for SQL Agent,

1) Management -> SQL Server Agent, right click Properties

2) Modify the Service starup account & click ok

For SQL Server 2005, follow the below guide lines
1) Start SQL Server Configuration Manager.

2) Select SQL Server 2005 Services in the pane on the left.

3) In the pane on the right, select the service whose account you want to alter, right-click,
and select Properties -> Logon tab.

4) Change the account & click apply

If the Enterprise Manager or the SQL Query Analyzer is not found in the server it can be accessed by following the steps below. 

1. Go to Run and type MMC (MMC is Microsoft Management Console).
2. This would open a window with the heading Console1.
3. Go to File menu and click on Add/Remove Snap in.
4. This would open a window with heading Add/Remove Snap in.
5. There would be an add button at the bottom.
6. Click on the add button and this would open a list of applications.
7. Choose the corresponding application that is needed (In our case SQL Enterprise Manager).
8. Once this SQL Enterprise Manager has been added to the console root click on OK.
9. If the SQL Query Analyzer is not found it can be opened from SQL Enterprise Manager
10. The console with the name Console1 can be stored for future access and the same can be opened with the open command available in Console tab