Post reply

Upgrade default instance to named instance

  • September 30, 2005 at 6:17 am

    #111792

    Hi All

    I have situation where i need to

    1. upgrade default instance to named instance

    2. and install three instances on SQL Server 2000.

    Plesae help me in both scenario... I am really confuse about this installation.

    Thanks a lot in Advance..

    SqlIndia

  • October 3, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • October 3, 2005 at 11:01 am

    #594647

    I am not sure you can switch from Default instance to Named. But as a workaround I would install a named instance and move a database and logins (and other objects like DTS jobs) to this instance similar like you are moving from server to server. You may find out that a lot of things like DTS jobs, Backup Jobs, queries, data sources have to be modified to reflect the new server name. Do not forget Firewall ports that will change from 1433 (default for default instance) for example to other port.

    Regards,Yelena Varsha

  • October 3, 2005 at 10:47 pm

    #594718

    Hi

    thanks for response... any refer for document on it cos could able find any thing in BOL.

    regards

    SqlIndia

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply