Sunday, February 19, 2012

Changing From Default Installation

Hello,

Our security center just scanned my database server and has asked that I change the database server from the default instance name and change the default port used. When installed MS SQL Server 2000 I used the default installation settings. I have installed SP4 and this is all running on a fully patched WIN 2003 Server machine. Is this possible without un-installing and then re-installing?

Thanks for any and all help.

Ben

Renaming the instance is not possible. For installing a named instance, you will have to run the installer of SQL Server and install a named instance from scratch (and patch the instance afterwards with the appropiate service packs) The port can be changed using the SQL Server Configuration Manager:

Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration manager > SQL Server Network configuration > Protocols (Select the instance to configure) > TCP/IP / IPAdresses > Condigure the port for the appropiate IP Addresses

restart the service...done.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Thanks for the help!

No comments:

Post a Comment