Multiple Instances of SQL Server

[MKVAB]

I am interested in having two completely separate SQL Server instances on one server as opposed to creating a new database within an instance. The purpose of this is to separate the two instances as much as possible while still being on the same machine.

Ultimately we are hoping to limit access to the second instance of SQL Server by changing the port from it's default of 1433.

1. Any ideas how to create this second SQL Server instance? Is it an entirely new install of SQL Server? Books Online has a brief write-up about it but it doesn't say enough to know where to begin.

2. Is it even possible to restrict the ports on which a particular instance listens?

Any information, advise or suggestions anybody may have are greatly appreciated!!!

-Mary Klaire

 

[JayKusch]

It is installed just like an new setup. This time the you supply the instance name since the default instance was taken by the initial setup. Just load your CD and go for it.

I beleive you may let once instance use port 1433 and the other 1434.

Hope this helps.

Thanks

J. Kusch

 

[SQLRickster]

Jay is correct. After installation the new instance will be seen as a totally different server in EM. You can actually change the port configuration if need be, but I believe Jay is bang on.

We use it frequently to have separate dev and production databases with the same name on the same server.

 

[MKVAB]

Thanks JayKusch & SQLRickster. Our 2nd instance is now up and running. Amazingly easy! Just a simple install with no additional setup, you can't beat that!