Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Friday, March 30, 2012

Named pipes vs TCP/IP

Hi all.
We have a customer with some connection problems running Remote desctop
(Terminal server). In the startuplog of the SQL2000 server we can't find
anything else than:
2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
Pipes.
On our server we have the following started. What should we do to get the
server listening on the TCP/IP too? We think this could be the problem.
2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Thanks all.
geir
Is the IP netlib enabled (Server Network Utility)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geir Holme" <geir@.multicase.no> wrote in message news:u1OjFIJ5FHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> We have a customer with some connection problems running Remote desctop
> (Terminal server). In the startuplog of the SQL2000 server we can't find
> anything else than:
> 2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
> Pipes.
> On our server we have the following started. What should we do to get the
> server listening on the TCP/IP too? We think this could be the problem.
>
> 2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
> 2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
> 2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
>
>
> Thanks all.
> geir
>

Named pipes vs TCP/IP

Hi all.
We have a customer with some connection problems running Remote desctop
(Terminal server). In the startuplog of the SQL2000 server we can't find
anything else than:
2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
Pipes.
On our server we have the following started. What should we do to get the
server listening on the TCP/IP too? We think this could be the problem.
2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Thanks all.
geirIs the IP netlib enabled (Server Network Utility)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geir Holme" <geir@.multicase.no> wrote in message news:u1OjFIJ5FHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> We have a customer with some connection problems running Remote desctop
> (Terminal server). In the startuplog of the SQL2000 server we can't find
> anything else than:
> 2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
> Pipes.
> On our server we have the following started. What should we do to get the
> server listening on the TCP/IP too? We think this could be the problem.
>
> 2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
> 2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
> 2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
>
>
> Thanks all.
> geir
>

Named pipes vs TCP/IP

Hi all.
We have a customer with some connection problems running Remote desctop
(Terminal server). In the startuplog of the SQL2000 server we can't find
anything else than:
2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
Pipes.
On our server we have the following started. What should we do to get the
server listening on the TCP/IP too? We think this could be the problem.
2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
Named Pipes.
Thanks all.
geirIs the IP netlib enabled (Server Network Utility)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Geir Holme" <geir@.multicase.no> wrote in message news:u1OjFIJ5FHA.1032@.TK2MSFTNGP11.phx.gbl
..
> Hi all.
> We have a customer with some connection problems running Remote desctop
> (Terminal server). In the startuplog of the SQL2000 server we can't find
> anything else than:
> 2005-10-26 07:28:49.95 server SQL server listening on Shared Memory, Named
> Pipes.
> On our server we have the following started. What should we do to get the
> server listening on the TCP/IP too? We think this could be the problem.
>
> 2005-10-24 12:10:06.71 server SQL server listening on 10.120.1.26: 1433.
> 2005-10-24 12:10:06.78 server SQL server listening on 127.0.0.1: 1433.
> 2005-10-24 12:10:07.67 server SQL server listening on TCP, Shared Memory,
> Named Pipes.
>
>
> Thanks all.
> geir
>

Wednesday, March 28, 2012

Named Pipes and Clusters

Can the Named Pipes protocol be removed from a SQL Cluster
(SQL2000/Win2003)? And it still function properly, of course...
-Arnie Rowland
Hi Arnie,
No it cannot, see KB article:
831127 Named Pipes Support Cannot Be Removed on a Virtual Server That Is
http://support.microsoft.com/?id=831127
Dave Whitney
SQL Support
This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, March 23, 2012

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

Monday, March 19, 2012

Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.
Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.co...prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.com/sf_block_prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

Mysterious Sql2000 process blocking

I have made several posts regarding my sql2000 cpu mysteriously staying at
100% for 10 minutes at a time. Using a performance monitor, I finally
noticed that during these times there is a sql process that is blocking the
others and causing some kind of "race" condition. The blocked processes
time out, but the blocking process seems to stay blocked often until the
service is restarted. It seems like sql should not allow this. I have not
been able to find out the cause or statements that produced the problem.
The only application using the sql server is an ASP.NET application that
uses 100% stored procedures (no dynamic sql). Does anyone have any
suggestions for finding the cause of process blocking like this? Thanks.Dan,
You'd have to examine the code to determine this.
These may help:
http://www.sql-server-performance.c..._prevention.asp
and
http://www.support.microsoft.com/?id=224453
and
http://www.support.microsoft.com/?id=271509
and
http://support.microsoft.com/?id=224587
and
http://support.microsoft.com/?id=243589
and
http://support.microsoft.com/?id=243588
HTH
Jerry
"Dan English" <dan_english2@.cox.net> wrote in message
news:eUAAmR4zFHA.2960@.tk2msftngp13.phx.gbl...
>I have made several posts regarding my sql2000 cpu mysteriously staying at
>100% for 10 minutes at a time. Using a performance monitor, I finally
>noticed that during these times there is a sql process that is blocking the
>others and causing some kind of "race" condition. The blocked processes
>time out, but the blocking process seems to stay blocked often until the
>service is restarted. It seems like sql should not allow this. I have
>not been able to find out the cause or statements that produced the
>problem. The only application using the sql server is an ASP.NET
>application that uses 100% stored procedures (no dynamic sql). Does anyone
>have any suggestions for finding the cause of process blocking like this?
>Thanks.
>

Friday, March 9, 2012

MySQL and SQL2000

Hi,
Not sure of the version of MySQL but do these 2 co-exist well together on
W2K3?
Thanks
Chris
As long as there is no contention for memory, hard drive, or processor, I
don't see why not.
But then, I don't see why you would want MySQL anyway.
"Chris Wood" <anonymous@.microsoft.com> wrote in message
news:OEb9$NE4HHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Not sure of the version of MySQL but do these 2 co-exist well together on
> W2K3?
> Thanks
> Chris
>
|||In article <eSBJUcE4HHA.3684@.TK2MSFTNGP02.phx.gbl>, nospam@.nospam.org
says...
> As long as there is no contention for memory, hard drive, or processor, I
> don't see why not.
> But then, I don't see why you would want MySQL anyway.
>

>
Several of our 3rd-party app's are coded to use it and have no intention
of converting to Sql2k/2k5. We are able to pretty much isolate them on
separate hardware but my guess is not everone is that lucky.
Graham (Pete) Berry
PeteBerry@.Caltech.edu

MySQL and SQL2000

Hi,
Not sure of the version of mysql but do these 2 co-exist well together on
W2K3?
Thanks
ChrisAs long as there is no contention for memory, hard drive, or processor, I
don't see why not.
But then, I don't see why you would want mysql anyway.
"Chris Wood" <anonymous@.microsoft.com> wrote in message
news:OEb9$NE4HHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Not sure of the version of mysql but do these 2 co-exist well together on
> W2K3?
> Thanks
> Chris
>|||In article <eSBJUcE4HHA.3684@.TK2MSFTNGP02.phx.gbl>, nospam@.nospam.org
says...
> As long as there is no contention for memory, hard drive, or processor, I
> don't see why not.
> But then, I don't see why you would want mysql anyway.
>

>
Several of our 3rd-party app's are coded to use it and have no intention
of converting to Sql2k/2k5. We are able to pretty much isolate them on
separate hardware but my guess is not everone is that lucky.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu

MySQL and SQL2000

Hi,
Not sure of the version of MySQL but do these 2 co-exist well together on
W2K3?
Thanks
ChrisAs long as there is no contention for memory, hard drive, or processor, I
don't see why not.
But then, I don't see why you would want MySQL anyway.
"Chris Wood" <anonymous@.microsoft.com> wrote in message
news:OEb9$NE4HHA.5980@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Not sure of the version of MySQL but do these 2 co-exist well together on
> W2K3?
> Thanks
> Chris
>|||In article <eSBJUcE4HHA.3684@.TK2MSFTNGP02.phx.gbl>, nospam@.nospam.org
says...
> As long as there is no contention for memory, hard drive, or processor, I
> don't see why not.
> But then, I don't see why you would want MySQL anyway.
>
>
Several of our 3rd-party app's are coded to use it and have no intention
of converting to Sql2k/2k5. We are able to pretty much isolate them on
separate hardware but my guess is not everone is that lucky.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu