| Author |
Topic |
|
indigo480
Starting Member
7 Posts |
 Posted - 2006-09-29 : 14:12:14
|
| I have a server running one instance of sql server enterprise edition. I want to install an additional application that requires sql enterprise edition. Can I install sql enterprise an create another instance for the new app. I know that I would have to give it's unique instance name. Thanks in advance. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-29 : 14:17:07
|
| Yes you can - be aware that a second instance is a second full copy of SQL Server so you will need enough memory (and other resources) on the server to run two servers at the same time. You will also need two licenses. |
 |
|
|
indigo480
Starting Member
7 Posts |
Posted - 2006-10-02 : 12:08:05
|
That being said, can I simply create a seperate database in the existing SQL Enterprise and point the new app to the created database. Would this require a separate full license? The current SQL Enterprise is a "per processor", where we have two processors. Thanks again.quote:
Originally posted by snSQL
Yes you can - be aware that a second instance is a second full copy of SQL Server so you will need enough memory (and other resources) on the server to run two servers at the same time. You will also need two licenses.
|
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-02 : 13:39:23
|
| creating a new database in the existing instance is probably the way to go for you. If you wanted to install a 2nd instance you would not need any additional licensing. The license for enterprise edition allows you to install as many instances as you want on a given server.-ec |
|
|
|
indigo480
Starting Member
7 Posts |
Posted - 2006-10-02 : 17:40:24
|
| I am little confused here. Earlier in the post snSQL said:"be aware that a second instance is a second full copy of SQL Server so you will need enough memory. You will also need two licenses."You are telling me that:"If you wanted to install a 2nd instance you would not need any additional licensing."Which is correct, will I need another license to install a second instance of SQL? If not, do I only need to rerun the exisiting SQL setup again to create the second instance. If this is true, it would be great as a second seperate SQL Server would have a high impact on resources as snSQL mention.Thanks again |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-02 : 18:52:12
|
| I just reviewed the SQL 2005 licensing docs online and microsoft has actually made a change to how multiple instances are licensed. Is your system SQL 2000 or 2005? becuase it looks like these changes are only for SQL 2005. Here is the pertinent information on SQL 2005: http://www.microsoft.com/sql/howtobuy/multipleinstances.mspxThis is different then how SQL 2000 was licensed. With SQL 2K you had to pay for every instance of SQL server installed, unless you were using the enterprise edition.-ec |
|
|
|
indigo480
Starting Member
7 Posts |
Posted - 2006-10-02 : 23:25:16
|
I have SQL 2000 Enterprise running under a per processor license. After reviewing the link, other links, and your input, it looks like I can run a second instance under the existing enterprise server. I am assuming that the SQL Server should not care if the applications are two different apps, correct? As this will be the first time that I will install a second instance, do I omly need to run the setup again to create the second instance or is there a different procedure.Thanks again, this has help me tremendously.quote:
Originally posted by eyechart
I just reviewed the SQL 2005 licensing docs online and microsoft has actually made a change to how multiple instances are licensed. Is your system SQL 2000 or 2005? becuase it looks like these changes are only for SQL 2005. Here is the pertinent information on SQL 2005: http://www.microsoft.com/sql/howtobuy/multipleinstances.mspxThis is different then how SQL 2000 was licensed. With SQL 2K you had to pay for every instance of SQL server installed, unless you were using the enterprise edition.-ec
|
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-03 : 01:27:07
|
| yes, just run the setup again and create a new instance. THe new instance will be referred to as a Named Instance instead of a Default Instance. The difference is that a named instance has a '\' in the name and listens on a randomly determined port instead of 1433 by default.Check in BOL for more details about named instances.-ec |
|
|
|
|
SQL Instances