SQL Instance

[duster123]

im using MS sql 2005 with the default setup. i need to create a new instance for an application im installing i dont want to use my default instance for that. How do i create a new instance from the sql menu?

 

[SQLBill]

How do i create a new instance from the sql menu?

You don't. Use the install program and reinstall SQL Server. You will get to a window where it will ask you for an INSTANCE NAME. There will be an option to use the default, but since you've already used that it will be greyed/grayed out. Give it the name you want for your new instance.

IMPORTANT....this new instance IS NOT PATCHED. If you applied any Service Packs or Hotfixes to your default install, you have to reapply them to the new Instance.

-SQLBill

Posting advice: FAQ481-4875