Named Pipes or TCP IP in LAN

I have read that Named pipes work faster/better in a LAN environment ? I
have a question.. so would it make sense if the Web Servers (IIS on Windows
2000) that talk to the database servers on the same LAN communicate via
Named pipes as opposed to TCPIP . Also same with regards to the business
tier thats also on the same LAN that talks to the databases that can
communicate using Named pipes
Please provide your inputs here . Currently we use TCPIP. Using SQL 2000HASSAN AFTER READING THIS YOU BE THE JUDGE
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ORNMyEE8DHA.3360@.tk2msftngp13.phx.gbl...
> I have read that Named pipes work faster/better in a LAN environment ? I
> have a question.. so would it make sense if the Web Servers (IIS on
Windows
> 2000) that talk to the database servers on the same LAN communicate via
> Named pipes as opposed to TCPIP . Also same with regards to the business
> tier thats also on the same LAN that talks to the databases that can
> communicate using Named pipes
> Please provide your inputs here . Currently we use TCPIP. Using SQL 2000
>

Named Pipes or TCP IP in LAN

I have read that Named pipes work faster/better in a LAN environment ? I
have a question.. so would it make sense if the Web Servers (IIS on Windows
2000) that talk to the database servers on the same LAN communicate via
Named pipes as opposed to TCPIP . Also same with regards to the business
tier thats also on the same LAN that talks to the databases that can
communicate using Named pipes
Please provide your inputs here . Currently we use TCPIP. Using SQL 2000HASSAN AFTER READING THIS YOU BE THE JUDGE
Named Pipes vs. TCP/IP Sockets
In a fast local area network (LAN) environment, Transmission Control
Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are
comparable in terms of performance. However, the performance difference
between the TCP/IP Sockets and Named Pipes clients becomes apparent with
slower networks, such as across wide area networks (WANs) or dial-up
networks. This is because of the different ways the interprocess
communication (IPC) mechanisms communicate between peers.
For named pipes, network communications are typically more interactive. A
peer does not send data until another peer asks for it using a read command.
A network read typically involves a series of peek named pipes messages
before it begins to read the data. These can be very costly in a slow
network and cause excessive network traffic, which in turn affects other
network clients.
It is also important to clarify if you are talking about local pipes or
network pipes. If the server application is running locally on the computer
running an instance of Microsoft® SQL ServerT 2000, the local Named Pipes
protocol is an option. Local named pipes runs in kernel mode and is
extremely fast.
For TCP/IP Sockets, data transmissions are more streamlined and have less
overhead. Data transmissions can also take advantage of TCP/IP Sockets
performance enhancement mechanisms such as windowing, delayed
acknowledgements, and so on, which can be very beneficial in a slow network.
Depending on the type of applications, such performance differences can be
significant.
TCP/IP Sockets also support a backlog queue, which can provide a limited
smoothing effect compared to named pipes that may lead to pipe busy errors
when you are attempting to connect to SQL Server.
In general, sockets are preferred in a slow LAN, WAN, or dial-up network,
whereas named pipes can be a better choice when network speed is not the
issue, as it offers more functionality, ease of use, and configuration
options.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ORNMyEE8DHA.3360@.tk2msftngp13.phx.gbl...
> I have read that Named pipes work faster/better in a LAN environment ? I
> have a question.. so would it make sense if the Web Servers (IIS on
Windows
> 2000) that talk to the database servers on the same LAN communicate via
> Named pipes as opposed to TCPIP . Also same with regards to the business
> tier thats also on the same LAN that talks to the databases that can
> communicate using Named pipes
> Please provide your inputs here . Currently we use TCPIP. Using SQL 2000
>|||Another thing to consider with Named Pipes is that the
user's Windows user accounts must have permission to
establish a NetBEUI connection to the Windows box that
SQL Server is running on. This is not the case when
using TCP/IP Sockets.
Just out of curiosity, where did you read that Named
Pipes was faster/better in a LAN environment? The last
time I experienced Named Pipes to be noticeably faster
was with a 16 bit client.
Matthew Bando
matthew.bando@.CSCTGI(Remove this).com
>--Original Message--
>I have read that Named pipes work faster/better in a LAN
environment ? I
>have a question.. so would it make sense if the Web
Servers (IIS on Windows
>2000) that talk to the database servers on the same LAN
communicate via
>Named pipes as opposed to TCPIP . Also same with regards
to the business
>tier thats also on the same LAN that talks to the
databases that can
>communicate using Named pipes
>Please provide your inputs here . Currently we use
TCPIP. Using SQL 2000
>
>.
>

Named Pipes Connection

Any use for having Named pipes turned on? Can i turn it off? Will it
be more secure after named pipes is turned off? These servers are
behind a corporate firewall and are not going to be exposed to the
outside world.Extreme security folks would have you turn off named pipes... Inside the
firewall it doesn't bother me personally..
If you do turn it off, be aware that upgrading to the next version of SQL
Server ( in the past) using the upgrade wizard REQUIRES that named pipes be
installed. ( So you might have to turn in back on when you upgrade next
time.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Shaun Farrugia" <far!!!!ugia!!!s@.dte!!!!ener!gy.com> wrote in message
news:u#ZHs7pjDHA.2536@.tk2msftngp13.phx.gbl...
> Any use for having Named pipes turned on? Can i turn it off? Will it
> be more secure after named pipes is turned off? These servers are
> behind a corporate firewall and are not going to be exposed to the
> outside world.
>|||In your environment, turning off named pipes is probably not necessary.
With named pipes, only NT authenticated users can connect to SQL Server so
you can completely control who can connect.
Rand
This posting is provided "as is" with no warranties and confers no rights.

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

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.

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:

---

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

hi,
i wanted to have my 2 node server cluster as active-active. DO i need to put
the named pipes in both servers before i install sql2000 or just on the one
that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
do i need to put both of them in CNU and install sql on first node and
proceed to another? pls advice.. just a bit blur on that part.Also when do i
need to remove this named pipes? JUST after installation and sqlspa3
completed?
TIA
Hi
During the SQL Server Install on a cluster, the setup creates the instances
and copies the binaries to all nodes. It is not a good idea to have any SQL
server installed intances prior to configuring clustering.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:

> hi,
> i wanted to have my 2 node server cluster as active-active. DO i need to put
> the named pipes in both servers before i install sql2000 or just on the one
> that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
> do i need to put both of them in CNU and install sql on first node and
> proceed to another? pls advice.. just a bit blur on that part.Also when do i
> need to remove this named pipes? JUST after installation and sqlspa3
> completed?
> TIA

Mystery Proccess

I have set up a job on one of my sql servers to inform me
of any processes that run for more than a specified
amount of time. It eails me and the message tells me the
SPID, Host name, login and duration. A proccess keeps on
cropping up that i cannot account for so is causing me
concern. This procces is a bulk insert, the host is one of
out test servers, it is issued using dts designer and the
login used is for the server that the job is running on. I
also return the last TSQL command issued using dbcc
inputbuffer but this is blank. I have looked on the test
server and there are no jobs.
Can any one suggest a way that i can trace the source of
this process
Hi,
Start a trace with SQL Profiler. You can even specify the minimum duration
for a statement before it is show in the trace.
Karl Gram
"Mat" wrote:

> I have set up a job on one of my sql servers to inform me
> of any processes that run for more than a specified
> amount of time. It eails me and the message tells me the
> SPID, Host name, login and duration. A proccess keeps on
> cropping up that i cannot account for so is causing me
> concern. This procces is a bulk insert, the host is one of
> out test servers, it is issued using dts designer and the
> login used is for the server that the job is running on. I
> also return the last TSQL command issued using dbcc
> inputbuffer but this is blank. I have looked on the test
> server and there are no jobs.
> Can any one suggest a way that i can trace the source of
> this process
>
|||I have never realy used SQL profier before, can you
suggest which event i should be tracing
Cheers

>--Original Message--
>Hi,
>Start a trace with SQL Profiler. You can even specify the
minimum duration[vbcol=seagreen]
>for a statement before it is show in the trace.
>--
>Karl Gram
>"Mat" wrote:
me[vbcol=seagreen]
the[vbcol=seagreen]
on[vbcol=seagreen]
of[vbcol=seagreen]
the[vbcol=seagreen]
on. I[vbcol=seagreen]
test[vbcol=seagreen]
of
>.
>
|||Mat,
From the 4 default events classes only the Stored Procedures (RPC:Completed)
and TSQL (SQL:BatchCompleted) events should be enough. The rest should be
removed.
Karl Gram
"mat" wrote:

> I have never realy used SQL profier before, can you
> suggest which event i should be tracing
> Cheers
> minimum duration
> me
> the
> on
> of
> the
> on. I
> test
> of
>
|||Solved the problem..
Maybe you may wish to know the cause...
a dts package was moved from the test server to the
production server. The connectins were changed to reflect
this but the name was left as the original name (test
server)
For what ever reason, sp_who, current activity and SQL
profiler pick up the conection name as the host name for
proccesss created by scheduled dts packages.

>--Original Message--
>Mat,
>From the 4 default events classes only the Stored
Procedures (RPC:Completed)
>and TSQL (SQL:BatchCompleted) events should be enough.
The rest should be[vbcol=seagreen]
>removed.
>--
>Karl Gram
>"mat" wrote:
the[vbcol=seagreen]
inform[vbcol=seagreen]
keeps[vbcol=seagreen]
me[vbcol=seagreen]
one[vbcol=seagreen]
and[vbcol=seagreen]
source
>.
>

Mystery Proccess

I have set up a job on one of my sql servers to inform me
of any processes that run for more than a specified
amount of time. It eails me and the message tells me the
SPID, Host name, login and duration. A proccess keeps on
cropping up that i cannot account for so is causing me
concern. This procces is a bulk insert, the host is one of
out test servers, it is issued using dts designer and the
login used is for the server that the job is running on. I
also return the last TSQL command issued using dbcc
inputbuffer but this is blank. I have looked on the test
server and there are no jobs.
Can any one suggest a way that i can trace the source of
this processI have never realy used SQL profier before, can you
suggest which event i should be tracing
Cheers
>--Original Message--
>Hi,
>Start a trace with SQL Profiler. You can even specify the
minimum duration
>for a statement before it is show in the trace.
>--
>Karl Gram
>"Mat" wrote:
>> I have set up a job on one of my sql servers to inform
me
>> of any processes that run for more than a specified
>> amount of time. It eails me and the message tells me
the
>> SPID, Host name, login and duration. A proccess keeps
on
>> cropping up that i cannot account for so is causing me
>> concern. This procces is a bulk insert, the host is one
of
>> out test servers, it is issued using dts designer and
the
>> login used is for the server that the job is running
on. I
>> also return the last TSQL command issued using dbcc
>> inputbuffer but this is blank. I have looked on the
test
>> server and there are no jobs.
>> Can any one suggest a way that i can trace the source
of
>> this process
>>
>.
>|||Solved the problem..
Maybe you may wish to know the cause...
a dts package was moved from the test server to the
production server. The connectins were changed to reflect
this but the name was left as the original name (test
server)
For what ever reason, sp_who, current activity and SQL
profiler pick up the conection name as the host name for
proccesss created by scheduled dts packages.
>--Original Message--
>Mat,
>From the 4 default events classes only the Stored
Procedures (RPC:Completed)
>and TSQL (SQL:BatchCompleted) events should be enough.
The rest should be
>removed.
>--
>Karl Gram
>"mat" wrote:
>> I have never realy used SQL profier before, can you
>> suggest which event i should be tracing
>> Cheers
>> >--Original Message--
>> >Hi,
>> >
>> >Start a trace with SQL Profiler. You can even specify
the
>> minimum duration
>> >for a statement before it is show in the trace.
>> >
>> >--
>> >Karl Gram
>> >
>> >"Mat" wrote:
>> >
>> >> I have set up a job on one of my sql servers to
inform
>> me
>> >> of any processes that run for more than a specified
>> >> amount of time. It eails me and the message tells me
>> the
>> >> SPID, Host name, login and duration. A proccess
keeps
>> on
>> >> cropping up that i cannot account for so is causing
me
>> >> concern. This procces is a bulk insert, the host is
one
>> of
>> >> out test servers, it is issued using dts designer
and
>> the
>> >> login used is for the server that the job is running
>> on. I
>> >> also return the last TSQL command issued using dbcc
>> >> inputbuffer but this is blank. I have looked on the
>> test
>> >> server and there are no jobs.
>> >>
>> >> Can any one suggest a way that i can trace the
source
>> of
>> >> this process
>> >>
>> >>
>> >.
>> >
>.
>|||Hi,
Start a trace with SQL Profiler. You can even specify the minimum duration
for a statement before it is show in the trace.
--
Karl Gram
"Mat" wrote:
> I have set up a job on one of my sql servers to inform me
> of any processes that run for more than a specified
> amount of time. It eails me and the message tells me the
> SPID, Host name, login and duration. A proccess keeps on
> cropping up that i cannot account for so is causing me
> concern. This procces is a bulk insert, the host is one of
> out test servers, it is issued using dts designer and the
> login used is for the server that the job is running on. I
> also return the last TSQL command issued using dbcc
> inputbuffer but this is blank. I have looked on the test
> server and there are no jobs.
> Can any one suggest a way that i can trace the source of
> this process
>|||Mat,
From the 4 default events classes only the Stored Procedures (RPC:Completed)
and TSQL (SQL:BatchCompleted) events should be enough. The rest should be
removed.
--
Karl Gram
"mat" wrote:
> I have never realy used SQL profier before, can you
> suggest which event i should be tracing
> Cheers
> >--Original Message--
> >Hi,
> >
> >Start a trace with SQL Profiler. You can even specify the
> minimum duration
> >for a statement before it is show in the trace.
> >
> >--
> >Karl Gram
> >
> >"Mat" wrote:
> >
> >> I have set up a job on one of my sql servers to inform
> me
> >> of any processes that run for more than a specified
> >> amount of time. It eails me and the message tells me
> the
> >> SPID, Host name, login and duration. A proccess keeps
> on
> >> cropping up that i cannot account for so is causing me
> >> concern. This procces is a bulk insert, the host is one
> of
> >> out test servers, it is issued using dts designer and
> the
> >> login used is for the server that the job is running
> on. I
> >> also return the last TSQL command issued using dbcc
> >> inputbuffer but this is blank. I have looked on the
> test
> >> server and there are no jobs.
> >>
> >> Can any one suggest a way that i can trace the source
> of
> >> this process
> >>
> >>
> >.
> >
>

Mysql on different servers

Is it possible to connect to different databases on different servers
so i can merge them as one.

I heard there is a tool that does this but still to come accross it
any help appreciated.[posted and mailed]

kev (bairdoid@.hotmail.com) writes:
> Is it possible to connect to different databases on different servers
> so i can merge them as one.
> I heard there is a tool that does this but still to come accross it
> any help appreciated.

In MS SQL Server you would set up a linked server and use four-part notation
for your queries:

SELECT * FROM SERVER.db.dbo.tbl

But what MySQL offers, I have no idea. You need to find a forum devoted
to MySQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

My Report Manager Broke "The underlying connection was closed"

Our company recently re-located the servers and somehow in the process of
disconnecting -> reconnecting the Report Server the Report Manager now cannot
be run. All we get is the error:
"The underlying connection was closed: Unable to connect to the remote
server."
Interestingly, this affects ONLY the Report Manager, the Report Service is
running OK and all reports run fine via our web application and in Visual
Studio IDE etc...
Any clues?Hi!
We had a similar problem and resolved it by correcting the Applications
Extensions Mapping for the ReportServer virtual directory. Information about
configuring Reporting Services' virtual directories is available here:
http://support.microsoft.com/Default.aspx?kbid=867872
Good luck,
Bob
"neokortex" wrote:
> Our company recently re-located the servers and somehow in the process of
> disconnecting -> reconnecting the Report Server the Report Manager now cannot
> be run. All we get is the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> Interestingly, this affects ONLY the Report Manager, the Report Service is
> running OK and all reports run fine via our web application and in Visual
> Studio IDE etc...
> Any clues?|||thanks for the tip,
but Im not quite sure this will help me. I checked the extensions for our
ReportServer virtual directory and they are already mapped exactly as
specified in the Support article. Also, ReportServer is working fine in so
far as reports can still be run through it.
It is only the Report Manager Web UI that is flaking out.
"bobhug" wrote:
> Hi!
> We had a similar problem and resolved it by correcting the Applications
> Extensions Mapping for the ReportServer virtual directory. Information about
> configuring Reporting Services' virtual directories is available here:
> http://support.microsoft.com/Default.aspx?kbid=867872
> Good luck,
> Bob
> "neokortex" wrote:
> > Our company recently re-located the servers and somehow in the process of
> > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > be run. All we get is the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > running OK and all reports run fine via our web application and in Visual
> > Studio IDE etc...
> >
> > Any clues?|||I am having the exact same problem. ReportServer is working fine, but report
manager web interface gives The underlying connection was closed. was there a
resolution to this problem?
"neokortex" wrote:
> thanks for the tip,
> but Im not quite sure this will help me. I checked the extensions for our
> ReportServer virtual directory and they are already mapped exactly as
> specified in the Support article. Also, ReportServer is working fine in so
> far as reports can still be run through it.
> It is only the Report Manager Web UI that is flaking out.
> "bobhug" wrote:
> > Hi!
> > We had a similar problem and resolved it by correcting the Applications
> > Extensions Mapping for the ReportServer virtual directory. Information about
> > configuring Reporting Services' virtual directories is available here:
> > http://support.microsoft.com/Default.aspx?kbid=867872
> >
> > Good luck,
> > Bob
> >
> > "neokortex" wrote:
> >
> > > Our company recently re-located the servers and somehow in the process of
> > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > be run. All we get is the error:
> > >
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > running OK and all reports run fine via our web application and in Visual
> > > Studio IDE etc...
> > >
> > > Any clues?|||No resolution yet. Since that was a test server and we were/are in the
process of migrating to a production server, it is not a emergency for us. I
do know this is a general web service error, not necessarily specfic to RS.
However if you find the answer please respond. I am curious.
"Paul" wrote:
> I am having the exact same problem. ReportServer is working fine, but report
> manager web interface gives The underlying connection was closed. was there a
> resolution to this problem?
> "neokortex" wrote:
> > thanks for the tip,
> >
> > but Im not quite sure this will help me. I checked the extensions for our
> > ReportServer virtual directory and they are already mapped exactly as
> > specified in the Support article. Also, ReportServer is working fine in so
> > far as reports can still be run through it.
> >
> > It is only the Report Manager Web UI that is flaking out.
> >
> > "bobhug" wrote:
> >
> > > Hi!
> > > We had a similar problem and resolved it by correcting the Applications
> > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > configuring Reporting Services' virtual directories is available here:
> > > http://support.microsoft.com/Default.aspx?kbid=867872
> > >
> > > Good luck,
> > > Bob
> > >
> > > "neokortex" wrote:
> > >
> > > > Our company recently re-located the servers and somehow in the process of
> > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > be run. All we get is the error:
> > > >
> > > > "The underlying connection was closed: Unable to connect to the remote
> > > > server."
> > > >
> > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > running OK and all reports run fine via our web application and in Visual
> > > > Studio IDE etc...
> > > >
> > > > Any clues?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"neokortex" wrote:
> No resolution yet. Since that was a test server and we were/are in the
> process of migrating to a production server, it is not a emergency for us. I
> do know this is a general web service error, not necessarily specfic to RS.
> However if you find the answer please respond. I am curious.
> "Paul" wrote:
> > I am having the exact same problem. ReportServer is working fine, but report
> > manager web interface gives The underlying connection was closed. was there a
> > resolution to this problem?
> >
> > "neokortex" wrote:
> >
> > > thanks for the tip,
> > >
> > > but Im not quite sure this will help me. I checked the extensions for our
> > > ReportServer virtual directory and they are already mapped exactly as
> > > specified in the Support article. Also, ReportServer is working fine in so
> > > far as reports can still be run through it.
> > >
> > > It is only the Report Manager Web UI that is flaking out.
> > >
> > > "bobhug" wrote:
> > >
> > > > Hi!
> > > > We had a similar problem and resolved it by correcting the Applications
> > > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > > configuring Reporting Services' virtual directories is available here:
> > > > http://support.microsoft.com/Default.aspx?kbid=867872
> > > >
> > > > Good luck,
> > > > Bob
> > > >
> > > > "neokortex" wrote:
> > > >
> > > > > Our company recently re-located the servers and somehow in the process of
> > > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > > be run. All we get is the error:
> > > > >
> > > > > "The underlying connection was closed: Unable to connect to the remote
> > > > > server."
> > > > >
> > > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > > running OK and all reports run fine via our web application and in Visual
> > > > > Studio IDE etc...
> > > > >
> > > > > Any clues?