We help IT Professionals succeed at work.

Add New Instance in SQL 2005

Hi All Expert,

Good day to all. I have window server 2003 installed accounting software using sql 2005. Currently this accounting software using the instances named OCI2005. We need to run another accounting software which is another brand using this sql 2005 with difference instance name lets say A2006. May i know how to add this new instance? will it affect the existing database? Every instance using same sa password? Thanks a lot.




Many Thanks,
Teoh
Comment
Watch Question

Paul JacksonSoftware Engineer
BRONZE EXPERT
Top Expert 2011

Commented:
To create a new instance you run the SQL Server 2005 install again specifying the required instance name when prompted.

Commented:
see

http://www.sqlservercentral.com/Forums/Topic539002-149-1.aspx#bm543118

I dont know if it will use the same sa but you can add an ad group to the sa looking for a link

Author

Commented:
Hi,

For sql 2005 express can add new instance? i did run the 2005 express install but it never prompt me, for key in instance name.



Thanks.

Author

Commented:
Hi,

I rerun installer again and the create instance prompted. Thanks.

Meanwhile, may i know how to check my existing sql 2005 is it enterprise or express?

If let say it is enterprise, how do i run the installer? Sorry i am newbie :-(


Many Thanks.
Paul JacksonSoftware Engineer
BRONZE EXPERT
Top Expert 2011

Commented:
Have a look in tutorial here in part 3 it asks for the instance name which is quite a way into the installation process:


http://searchsqlserver.techtarget.com/tutorial/Installing-a-SQL-Server-2005-instance

Author

Commented:
Hi Jacko

Thanks.
Software Engineer
BRONZE EXPERT
Top Expert 2011
Commented:
OPen a query window and run:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Then you can compare the results with the details are the linked knowledge base article to determine the version and edition:

http://support.microsoft.com/kb/321185

Explore More ContentExplore courses, solutions, and other research materials related to this topic.