Installing SQL Sever 2005 Developer Edition 1

[seaport]

I already have the Management Studios installed on my PC so I can work on the database which sits on the Server computer. Now I got the Developer edition. Should I install it on top of the existing software, or I should remove existing software and then install the Developer Edition?

Also, I guess, after the installation, I should see two severs in the management studio, the one sitting on my PC and the one sitting on the Sever computer, right?

Seaport

 

[mrdenny]

You can simply install over the current managment studio.

After you install the developer edition do not forget to install the service pack.

You may need to manually register your workstation in the registered servers list.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[seaport]

Denny,

Thanks for the quick reply.

Do you mean the Service Pack2 for the SQL Server 20005, as the following link:

http://www.microsoft.com/downloads/...B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en

Seaport

 

[mrdenny]

Yep, that's the one.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[avanderlaan]

Ideally you will install the same service pack on your developer edition that matches your production server.