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
RunnexAsked:
Who is Participating?
 
Paul JacksonSoftware EngineerCommented:
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
0
 
Paul JacksonSoftware EngineerCommented:
To create a new instance you run the SQL Server 2005 install again specifying the required instance name when prompted.
0
 
IanThCommented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RunnexAuthor 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.
0
 
RunnexAuthor 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.
0
 
Paul JacksonSoftware EngineerCommented:
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
0
 
RunnexAuthor Commented:
Hi Jacko

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.