July 2, 2008 at 10:44 pm
Hey,
I have a query related to both MS-SQL Server 2000 and 2005. I have SQL Server 2000 Database installed on one machine and SQL Server 2005 on another machine. Both the machines are on the same domain. Can i name both of the instances has THI-SQL ?? as this is my First Database Instance name which was in SQL 2000 and i want the SQL 2005 to be on the same name.
I want to use my SQL Sever 2005 on Cluster Based Environment which i have already configured.
Can i do that
July 2, 2008 at 11:14 pm
Hi Sherry
A default instance of a SQL Server 2000 or 2005 is usually the PC Name.
You can not have the same PC name on the same domian.
In SQL 2000 / 2005 you can create Named Instances:
SERVER01\SQLINSTANCE (SQL 2000)
SERVER02\SQLINSTANCE (SQL 2005)
This means that the SQL Instance Name is the same - but the PC or Server name is different.
In terms of the clustering - I am not 100% around this aspect of it - maybe someone else can provide input on that.
Thanks
Kevin
July 2, 2008 at 11:51 pm
Off course the server names are different but in SQL 2005 it asks for the Instance name when installing on the server
July 3, 2008 at 12:11 am
Hi - yes the instance you talk of is the Named Instance and you can have many of the same of these names as the SQL Instance is actually both the ServerName and Instance:
SERVER01\INSTANCE
SERVER02\INSTANCE
SERVER03\INSTANCE
So the Named Instances are the same but the SQL Instance is seen as 3 different instances.
Does this help? - Let us know
Thanks
Kevin
July 3, 2008 at 8:50 pm
you mean to say i can do it.... ?? there will no problem in running any of those instances
I have changed both the server names but the instance name is same... it gave an error that the specified instance already exist on the network
July 4, 2008 at 3:14 am
You mention that you changed the server names, does this mean that 2 servers have "shared" a name?
There are potentially registery entries that are still pointing to the instance name being referenced as servername\instancename
let us know.
As far as I am aware the named instance name can be used for multiple servers (maybe someone else has more info on this?)
Thanks
Kevin
July 4, 2008 at 3:56 am
hello,
I've another question concerning two instances of SQL Server on the same machine. Arte they both listening on Port 1433 ? Is that possible ? Or do I have defining two different ports ?
Thanks
manfred
July 4, 2008 at 4:06 am
i think SQL itself defines the port numbers. You can have atmost 50 Instances on one single machine but it decreases machine performance.
may be i am wrong
July 4, 2008 at 12:59 pm
Hi,
It is completely depends on the Port number.
Thanks -- Vj
November 5, 2008 at 8:04 am
I have exactly the same question. I checked on several websites but I have not found a straight forward answer. Can somebody answer this?
November 6, 2008 at 2:24 am
Hi
If the question you are asking is if you can have multiple instances with the same name on a network - the answer is yes.
Note: this assumes that these instances are one different servers.
Because the server name is different, the full path to the SQL server will be SERVER\INSTANCENAME
so because the server names are different then these SQL instances are not the same and can have more than 1 with the same name.
Additional Info:
---------------
When SQL Express is installed on PC's their default instance name is SQLEXPRESS - and there are usually many computers with this instance name that exisit on a network - but because each PC has a different name this is not a problem and there can be the same named instances on a network.
Thanks
Kevin
December 29, 2008 at 6:01 am
hi,
Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you
August 31, 2009 at 4:07 am
Hi friends,
Here are some doubts regarding the Instances in SQL Server.
1) Is there any effect to the processor (or) existing application performnce if a new instance was created on a machine.
2) I am having a scenerio as follows: There are two servers like DEV and PRODUCTION. I need to move a DB from DEV to PROD , for this i am going to create a another instance on the PROD server. Suppose if my DB name on DEV is same as one of the DB present on the PROD, is it causes any conflict at the time of restoring a DB.
Thakns in advance,
Venu Gopal.K
Software Engineer
INDIA
August 31, 2009 at 6:25 am
venki.ffcl (12/29/2008)
hi,Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you
Yes you can have multiple instance running on a single server. If I am not wrong, maximum you can have is 15 instances. Accessing them is by their name. You can have one default and multiple named instance. Just giving server name would allow you to connect to the default and servernameamed_instance would allow you to connect to named instance. Hope this helps.
---------------------------------------------------------------------------------
October 3, 2009 at 5:26 am
PP-564103 (8/31/2009)
venki.ffcl (12/29/2008)
hi,Can i have two or more instances of sql server running in my machine and access the same simultaneously. If yes how?
Please help...
thank you
Yes you can have multiple instance running on a single server. If I am not wrong, maximum you can have is 15 instances. Accessing them is by their name. You can have one default and multiple named instance. Just giving server name would allow you to connect to the default and servernameamed_instance would allow you to connect to named instance. Hope this helps.
I believe the limit on instances per server is 50 rather than 15 as sherry81hi mentioned earlier. Unfortunately I am not sure of the licence implications in doing this, i.e. whether one is limited to a maximum number of instances if they have only one SQL Server licence. Can anyone shed light on that please?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply