• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

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
0
Runnex
Asked:
Runnex
  • 3
  • 3
1 Solution
 
Paul JacksonCommented:
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 JacksonCommented:
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
 
Paul JacksonCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now