I need to know if it is possible to create a Sql Server instance on top of an existing SQL Server 2k installation.
I am trying to mimic a production setup completely and the database is setup as an instance of a SQL server. By that I mean that we connect to the database by specifying <servername>\<instancename>.
I apologize if I have been ambiguous, or have used incorrect terminology. I am not a DBA and am trying to explain this the best way I know of.
Any help that anyone can provide is greatly appreciated!!
Sure, another instance can be easily installed by using the setup disk on choosing the named instance option along with the setup. If you have a default instance installed on the server, be aware that the named instance has another port than the default instance. You will have to specify the port during connection time in the syntax of ServerName\Instancename,Portnumer (whereas the instanceName is irgnored if you specified the portnumber, but for me this is for better reading and debugging).
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Thank you for the reponse!
I will give that a try.
|||This did the trick! Many thanks!
No comments:
Post a Comment