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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.