Good day,
There is a 2-node microsoft sql 2000 cluster in active/active mode. .
Default instance is on node A, another named instance is on node B.
Client uses BDE while connecting. When the node A fails over to the
node B, it's not possible to connect to the default instance while
using trusted logins. When sql login is used, users can connect..
I can connect via Query Analyzer, but via tcp/ip only(when named pipes
aren't used) at this very moment.
As far as I understand, BDE uses named pipes with trusted logins.
Are there any workarounds?
Thank in advance,
Andrew.
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
Windows NT 5.2 (Build 3790: Service Pack 1)
Andrew,
What is the service pack level for your SQL Server 2000 clustered instance?
As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a Virtual Server That Is Running SQL Server 2000 SP3
Here is the link that explains this
http://support.microsoft.com/default.aspx?kbid=831127
Note: If you are already on SP3a --> On a virtual server that is running SQL 2000 SP3a, an administrator can disable Named Pipes support through SQL Server Enterprise
Manager in SQL Server 2000 SP2 or earlier.
Recommendation:
Although Named Pipes support is not required for a virtual server, Microsoft recommends that both network libraries must be present on the system because of the
following reasons:
Having both network libraries available permits an administrator or an alternative interprocess communication (IPC) mechanism to repair the system.
Clients can continue to work with the virtual server, even if only one server-side network library is available.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi Uttam,
sp3a was installed..
named pipes aren't disabled. I can see them enabled while viewing the
sql servers logs.
Moreover, i can't connect to the moved instance via named pipes using
Query Analyzer as well. Not only our application can't connect.
Andrew.
Uttam Parui[MS] =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> Andrew,
> What is the service pack level for your SQL Server 2000 clustered instanc=
e?
> As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a V=
irtual Server That Is Running SQL Server 2000 SP3
> Here is the link that explains this
> http://support.microsoft.com/default.aspx?kbid=3D831127
> Note: If you are already on SP3a --> On a virtual server that is runnin=
g SQL 2000 SP3a, an administrator can disable Named Pipes support through S=
QL Server Enterprise
> Manager in SQL Server 2000 SP2 or earlier.
> Recommendation:
> Although Named Pipes support is not required for a virtual server, Micros=
oft recommends that both network libraries must be present on the system be=
cause of the
> following reasons:
> Having both network libraries available permits an administrator or an al=
ternative interprocess communication (IPC) mechanism to repair the system.
> Clients can continue to work with the virtual server, even if only one se=
rver-side network library is available.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> Are you secure? For information about the Strategic Technology Protectio=
n Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their =
Microsoft software to better protect against viruses and security vulnerabi=
lities. The easiest way
> to do this is to visit the following websites: http://www.microsoft.com/p=
rotect
> http://www.microsoft.com/security/guidance/default.mspx
Showing posts with label active. Show all posts
Showing posts with label active. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Named Pipe Connection through ASP - HELP!
We have a problem with interfacing a dll which is called through an Active Server Page. Our network infrastructure uses Named Pipes on Windows 2000 with SQL Server 2000 IIS version 5.0 and MDAC 2.5.
When the ASP calls the dll which (should) insert a new record into a SQL table via a stored procedure call (wrapped as a COM object), we receive the following error:
80004005 SQL Server does not exist or access denied error.
We have tried running this from the Server Admin account, but makes no difference. If we use TCP/IP the mechanism works fine, unfortunately this is not a route we can utilse without significant overall network security implications.
Any advice much appreciated!As you probably know, that's a generic error code. It could be network problems (firewall etc), file permissions or location, or any number of other things. This link shows some of the possible causes (http://support.microsoft.com/support/kb/articles/Q169/3/77.ASP?LN=EN-US&SD=gn&FR=0&qry=80004005&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL).
When the ASP calls the dll which (should) insert a new record into a SQL table via a stored procedure call (wrapped as a COM object), we receive the following error:
80004005 SQL Server does not exist or access denied error.
We have tried running this from the Server Admin account, but makes no difference. If we use TCP/IP the mechanism works fine, unfortunately this is not a route we can utilse without significant overall network security implications.
Any advice much appreciated!As you probably know, that's a generic error code. It could be network problems (firewall etc), file permissions or location, or any number of other things. This link shows some of the possible causes (http://support.microsoft.com/support/kb/articles/Q169/3/77.ASP?LN=EN-US&SD=gn&FR=0&qry=80004005&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL).
named instances
I am setting up a 3 + 1 Windows 2003 Server cluster hosting 3 named instances of SQL Server 2000 on the active servers. This SQL Farm will support approximately 150 databases supporting 15 different groups of applications distrbuted amongst a user population of 5000 desktops over mutiple sites. Each named instance of SQL Server will initially host a different subset of the databases. To optimise the server load on each of the 3 active cluster members, over time I want to be able to move the databases supporting any particular application group from one server to a different server in the cluster. Ideally I would like to do this without having to change anything on the client side. I cannot think of any way to do this as I think the client connections will have to refer to the instance name, which in turn will refer to the virtual server name. If anyone knows how I can do this I would appreciate your directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
>you issue.
>As my understanding of you question, you want to
optimise the server load
>within a clustered SQL Server environment and you want
to move the database
>from one serve to another. If you want to move the
databases from one
>virtual server to another (in the cluster), you have to
make changes to
>your client connections as they now need to connect to a
new server that
>has the databases. The client machines can have alias
that point to a
>virtual server. In this case, the clients can use the
same alias but still
>you still have to change alias to point to the new
virtual server after the
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||Hello Geoff,
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>>--Original Message--
>>Hi,
>>Thank you for using the newsgroup and it is my pleasure
>to help you with
>>you issue.
>>As my understanding of you question, you want to
>optimise the server load
>>within a clustered SQL Server environment and you want
>to move the database
>>from one serve to another. If you want to move the
>databases from one
>>virtual server to another (in the cluster), you have to
>make changes to
>>your client connections as they now need to connect to a
>new server that
>>has the databases. The client machines can have alias
>that point to a
>>virtual server. In this case, the clients can use the
>same alias but still
>>you still have to change alias to point to the new
>virtual server after the
>>databases are moved.
>>Hope this helps and if you still have questions, please
>feel free to post
>>new message here and I am ready to help!
>>Thanks.
>>Best regards
>>Baisong Wei
>>Microsoft Online Support
>>----
>>Get Secure! - www.microsoft.com/security
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>Please reply to newsgroups only. Thanks.
>>.
>|||Vikrant
Thanks for your reply. We'd come to the same conclusion but I'm glad it has been confirmed by you guys
Cheer
Geoff.sql
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
>you issue.
>As my understanding of you question, you want to
optimise the server load
>within a clustered SQL Server environment and you want
to move the database
>from one serve to another. If you want to move the
databases from one
>virtual server to another (in the cluster), you have to
make changes to
>your client connections as they now need to connect to a
new server that
>has the databases. The client machines can have alias
that point to a
>virtual server. In this case, the clients can use the
same alias but still
>you still have to change alias to point to the new
virtual server after the
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||Hello Geoff,
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>>--Original Message--
>>Hi,
>>Thank you for using the newsgroup and it is my pleasure
>to help you with
>>you issue.
>>As my understanding of you question, you want to
>optimise the server load
>>within a clustered SQL Server environment and you want
>to move the database
>>from one serve to another. If you want to move the
>databases from one
>>virtual server to another (in the cluster), you have to
>make changes to
>>your client connections as they now need to connect to a
>new server that
>>has the databases. The client machines can have alias
>that point to a
>>virtual server. In this case, the clients can use the
>same alias but still
>>you still have to change alias to point to the new
>virtual server after the
>>databases are moved.
>>Hope this helps and if you still have questions, please
>feel free to post
>>new message here and I am ready to help!
>>Thanks.
>>Best regards
>>Baisong Wei
>>Microsoft Online Support
>>----
>>Get Secure! - www.microsoft.com/security
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>Please reply to newsgroups only. Thanks.
>>.
>|||Vikrant
Thanks for your reply. We'd come to the same conclusion but I'm glad it has been confirmed by you guys
Cheer
Geoff.sql
named instances
I am setting up a 3 + 1 Windows 2003 Server cluster hosting 3 named instance
s of SQL Server 2000 on the active servers. This SQL Farm will support appro
ximately 150 databases supporting 15 different groups of applications distrb
uted amongst a user populat
ion of 5000 desktops over mutiple sites. Each named instance of SQL Server
will initially host a different subset of the databases. To optimise the se
rver load on each of the 3 active cluster members, over time I want to be ab
le to move the databases su
pporting any particular application group from one server to a different ser
ver in the cluster. Ideally I would like to do this without having to chang
e anything on the client side. I cannot think of any way to do this as I th
ink the client connections
will have to refer to the instance name, which in turn will refer to the vir
tual server name. If anyone knows how I can do this I would appreciate your
directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
to help you with
optimise the server load
to move the database
databases from one
make changes to
new server that
that point to a
same alias but still
virtual server after the
feel free to post
confers no rights.
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
--
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>to help you with
>optimise the server load
>to move the database
>databases from one
>make changes to
>new server that
>that point to a
>same alias but still
>virtual server after the
>feel free to post
>confers no rights.
>|||Vikrant,
Thanks for your reply. We'd come to the same conclusion but I'm glad it has
been confirmed by you guys.
Cheers
Geoff.
s of SQL Server 2000 on the active servers. This SQL Farm will support appro
ximately 150 databases supporting 15 different groups of applications distrb
uted amongst a user populat
ion of 5000 desktops over mutiple sites. Each named instance of SQL Server
will initially host a different subset of the databases. To optimise the se
rver load on each of the 3 active cluster members, over time I want to be ab
le to move the databases su
pporting any particular application group from one server to a different ser
ver in the cluster. Ideally I would like to do this without having to chang
e anything on the client side. I cannot think of any way to do this as I th
ink the client connections
will have to refer to the instance name, which in turn will refer to the vir
tual server name. If anyone knows how I can do this I would appreciate your
directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
quote:
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
quote:
>you issue.
>As my understanding of you question, you want to
optimise the server load
quote:
>within a clustered SQL Server environment and you want
to move the database
quote:
>from one serve to another. If you want to move the
databases from one
quote:
>virtual server to another (in the cluster), you have to
make changes to
quote:
>your client connections as they now need to connect to a
new server that
quote:
>has the databases. The client machines can have alias
that point to a
quote:
>virtual server. In this case, the clients can use the
same alias but still
quote:
>you still have to change alias to point to the new
virtual server after the
quote:
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
quote:
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
quote:|||Hello Geoff,
>Please reply to newsgroups only. Thanks.
>.
>
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
--
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>to help you with
>optimise the server load
>to move the database
>databases from one
>make changes to
>new server that
>that point to a
>same alias but still
>virtual server after the
>feel free to post
>confers no rights.
>|||Vikrant,
Thanks for your reply. We'd come to the same conclusion but I'm glad it has
been confirmed by you guys.
Cheers
Geoff.
Named Instance On Cluster.
I am running a default instance on my Active\Passive cluster and want to
install a named instance on the same cluster. How is that done?
Hi
Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>I am running a default instance on my Active\Passive cluster and want to
>install a named instance on the same cluster. How is that done?
>
|||The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||You'll have to specify a new virtual server name and then specify an
instance for it.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||And a new ip as well?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
> You'll have to specify a new virtual server name and then specify an
> instance for it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
> The problem is, I have a default instance running and when I run SQL
> install, The Named Instance option is not available.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||New IP, New Virtual Server\Instance Name, and all new disks for each SQL
Instance.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:ulFCVLVbFHA.2520@.TK2MSFTNGP09.phx.gbl...
> And a new ip as well?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
install a named instance on the same cluster. How is that done?
Hi
Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>I am running a default instance on my Active\Passive cluster and want to
>install a named instance on the same cluster. How is that done?
>
|||The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||You'll have to specify a new virtual server name and then specify an
instance for it.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||And a new ip as well?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
> You'll have to specify a new virtual server name and then specify an
> instance for it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
> The problem is, I have a default instance running and when I run SQL
> install, The Named Instance option is not available.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||New IP, New Virtual Server\Instance Name, and all new disks for each SQL
Instance.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:ulFCVLVbFHA.2520@.TK2MSFTNGP09.phx.gbl...
> And a new ip as well?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
Friday, March 23, 2012
Named Instance in a SQL 2000 Cluster
Hi,
When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?
Do I must to install two named instances instead one default instance
and one named instance ?
thanks,
Rubens
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can only have one default instance, the rest have to be named. You can
also create only named instances, and not have a default.
At this point, you can uninstall the default instance. Then, install a
second named instance.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Rubens Sanches" <rubensluque@.yahoo.com.br> wrote in message
news:%23SB%233M9LFHA.1472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Rubens Sanches wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
>
yes, but you can run every instance on the cluster at the default port 1433.
When clients connect to the instance they do not need the instance name when
connecting to the server as long as they use tcp/ip and now the
sqlserverport. Try osql -E -Sserver02,1433 or server02,1433 when
registering the server whith the enterprise manager. When you create an odbc
connection deselect automaticly detect the server port, fill in the port
number and forget the instance name.
Hans
|||Hi
Check that SERVER01 is actually a cluster resource. For clusters, the only
way for it to be correct is virtualservername\instancename
SERVER02/I2 is correct, but SERVER01 can not be.
Regards
Mike
"Rubens Sanches" wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
|||Mike,
SERVER01 is a default clustered SQL instance and is the virtualservername. Since it is a default instance, it will work. It does not need an instance name.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?
Do I must to install two named instances instead one default instance
and one named instance ?
thanks,
Rubens
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can only have one default instance, the rest have to be named. You can
also create only named instances, and not have a default.
At this point, you can uninstall the default instance. Then, install a
second named instance.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Rubens Sanches" <rubensluque@.yahoo.com.br> wrote in message
news:%23SB%233M9LFHA.1472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Rubens Sanches wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
>
yes, but you can run every instance on the cluster at the default port 1433.
When clients connect to the instance they do not need the instance name when
connecting to the server as long as they use tcp/ip and now the
sqlserverport. Try osql -E -Sserver02,1433 or server02,1433 when
registering the server whith the enterprise manager. When you create an odbc
connection deselect automaticly detect the server port, fill in the port
number and forget the instance name.
Hans
|||Hi
Check that SERVER01 is actually a cluster resource. For clusters, the only
way for it to be correct is virtualservername\instancename
SERVER02/I2 is correct, but SERVER01 can not be.
Regards
Mike
"Rubens Sanches" wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
|||Mike,
SERVER01 is a default clustered SQL instance and is the virtualservername. Since it is a default instance, it will work. It does not need an instance name.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Subscribe to:
Posts (Atom)