Can't get it to listen on TCP port 1433

Been having SQL Server 2000 running for some time now, but recently it stopped listening on TCP port 1433, the log reports its listening on shared memory, Named pipes and Rpc, but no sign of 127.0.0.1 port 1433 or any errors to say why it won't listen.

I've done a netstat -na and nothing else is listening on that port, tried restarting using the enterprise manager, gonna try restarting the entire Server when everyone has gone home, but I'm pretty sure its been restarted recently.

All the other archive logs going back a few days show its not listening.

Yes, I have used the Server network utility to make sure TCP/IP is enabled and set to 1433, even added a comma and 1434 to see if it will listen on multiple ports, no go.

Any help?
What service pack do you have installed?|||Have you told your firewall to allow connections to Microsoft SQL Server?|||SQL Server 2000 - 8.00.194 build 3790 Service pack 1

Mmmm, isn't SP3 out?
Lets hope it doesn't break it even more, as after the restart of the entire server last night, its now not responding to TCP connections locally 127.0.0.1

Not sure about the firewall, I'll have to check, its been fine with it for the past few years.

|||

SP4 has been out for quite some time. Here is a handy web site which lists all of the hot fix and service packs which have been released http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx.

Start by upgrading to SQL 2000 SP4. Odds are a Windows 2000 hot fix shuts down SQL from talking over the net if prior to SP3 as there is a major security flaw prior to SP3 which the SQL Slammer worm expliots.

cant get around @@TEXTSIZE

Hello all,

Having a problem getting around @.@.TEXTSIZE. Shared hosting, SQL Server 2000. @.@.TEXTSIZE Value appears to be 64000, or anyway that's what I get in a query from ColdFusion. Which would explain why some of my very long values in my text column (up to 125K) are being truncated on SELECT.

But when I crank up Management Studio and query for @.@.TEXTSIZE I get the full 2GB max. So why does a SELECT in Management Studio of a row with one of my very long values still return truncated results?

I know that my full content is indeed in the database; READTEXT Research.HTMLContent @.ptrval 124484 100 gets me the last 100 characters of the full content as expected.

Sticking SET TEXTSIZEs into my queries (in ColdFusion app or Management Studio) has no effect. Are there other settings that can behave this way that I should be looking into?

Any thoughts appreciated; I've got a busted production application and an unhappy client.Found the answer, which I'll post here for the benefit of future Googlers--

It wasn't a SQL Server issue, but a ColdFusion one. There is a ColdFusion setting, in ColdFusion Administrator under Edit Datasource, called "Enable retrieval of long text." I'm not sure whether it's on or off by default, but in my case it was off. In which case, retrieval of SELECTS of text is limited to a data size specified on the same screen, labeled something like "Long text buffer limit."

Behind the scenes it does appear that ColdFusion is manipulating @.@.TEXTSIZE with this long text buffer limit, since a SELECT @.@.TEXTSIZE sent via a ColdFusion query returns the limit value.

Can't delete full text catalog on clustered sql serer 2000

Basically SQL Server has allowed me to create a full text catalog on a drive
which is not part of the cluster's shared resources, and I believe doesn't
exist either (I not familiar with clustering at all).
Now the problem is that it now won't let me remove this full text catalog,
giving me the error that it can't *create* a full text catalog on a disk
which isn't part of the cluster's shared resources. How can I delete it?
Ian.Ian,
Most un-usual! As by design, you should be only able to create FT Catalogs
on the shard drive in a clustered environment. How did you do this? If it
can be reproduced, it should be filed as a bug. Have you tried the
following:
use <your_database_name>
go
exec sp_fulltext_catalog '<Your_FT_Catalog_Name>','drop'
go
If not, try it. If it fails, please post the error that it returns. If it
does fail, you may have to try:
EXEC sp_fulltext_service 'clean_up'
if this too fails, I have some code I can email you directly code (the code
is not for the faint-of-heart) that can get you out of this "catch-22"
situation.
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ian" <Ixpah@.newsgroup.nospam> wrote in message
news:#rqy8sFBFHA.3588@.TK2MSFTNGP11.phx.gbl...
> Basically SQL Server has allowed me to create a full text catalog on a
drive
> which is not part of the cluster's shared resources, and I believe doesn't
> exist either (I not familiar with clustering at all).
> Now the problem is that it now won't let me remove this full text catalog,
> giving me the error that it can't *create* a full text catalog on a disk
> which isn't part of the cluster's shared resources. How can I delete it?
> Ian.
>|||Hello Ian,
To understsand the issue better, I'd like to know the exact steps you
create and delete the full text catalog. What is the exact error message
you encountered?
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
| From: "Ian" <Ixpah@.newsgroup.nospam>
| Subject: Can't delete full text catalog on clustered sql serer 2000
| Date: Thu, 27 Jan 2005 10:30:33 -0000
| Lines: 11
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#rqy8sFBFHA.3588@.TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: host81-137-218-140.in-addr.btopenworld.com
81.137.218.140
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.programming:499844
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Basically SQL Server has allowed me to create a full text catalog on a
drive
| which is not part of the cluster's shared resources, and I believe
doesn't
| exist either (I not familiar with clustering at all).
|
| Now the problem is that it now won't let me remove this full text
catalog,
| giving me the error that it can't *create* a full text catalog on a disk
| which isn't part of the cluster's shared resources. How can I delete it?
|
| Ian.
|
|
||||I used a script which was very similiar (if not the same) as this:
exec sp_fulltext_database 'enable'
exec sp_fulltext_catalog 'popall_ft','create'
exec sp_fulltext_table 'dbo. articles','create','popall_ft','pk__arti
cles'
exec sp_fulltext_column 'dbo.articles','comment','add'
exec sp_fulltext_table 'dbo.articles','activate'
exec sp_fulltext_table 'dbo.articles','start_change_tracking'
exec sp_fulltext_table 'dbo. articles','start_background_updateindex'
Unfortunately I tried disabling/enabling full text search in order to try
and fix this problem and now can't re-enable it due to the following error:
Server: Msg 7627, Level 16, State 1, Procedure sp_fulltext_database, Line 61
Full-text catalog in directory 'e:\mssql\ftdata' for clustered server cannot
be created. Only directories on a disk in the cluster group of the server
can be used.
Ian.
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:z8KjaoOBFHA.2732@.cpmsftngxa10.phx.gbl...
> Hello Ian,
> To understsand the issue better, I'd like to know the exact steps you
> create and delete the full text catalog. What is the exact error message
> you encountered?
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> --
> | From: "Ian" <Ixpah@.newsgroup.nospam>
> | Subject: Can't delete full text catalog on clustered sql serer 2000
> | Date: Thu, 27 Jan 2005 10:30:33 -0000
> | Lines: 11
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#rqy8sFBFHA.3588@.TK2MSFTNGP11.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.programming
> | NNTP-Posting-Host: host81-137-218-140.in-addr.btopenworld.com
> 81.137.218.140
> | Path:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP
08
> phx.gbl!TK2MSFTNGP11.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.programming:499844
> | X-Tomcat-NG: microsoft.public.sqlserver.programming
> |
> | Basically SQL Server has allowed me to create a full text catalog on a
> drive
> | which is not part of the cluster's shared resources, and I believe
> doesn't
> | exist either (I not familiar with clustering at all).
> |
> | Now the problem is that it now won't let me remove this full text
> catalog,
> | giving me the error that it can't *create* a full text catalog on a disk
> | which isn't part of the cluster's shared resources. How can I delete it?
> |
> | Ian.
> |
> |
> |
>|||Hi lan,
Thanks for your posting!
Peter Yang is OOF and I am his backup!
From your descriptions, I understood that you would like to create a
full-text index catalog, which is on a disk on which the SQL Server
resource is not dependant. In SQL Server 2000 virtual server instance, you
will have to add the disk as a dependency to the SQL Server resource in the
Cluster Administrator.
Refer to the Knowledge Base article for more information and how to add the
disk as a dependency
INF: Creating Databases or Changing Disk File Locations on a Shared Cluster
Drive on Which SQL Server 2000 was not Originally Installed
http://support.microsoft.com/?id=295732
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a w to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||I have *already* created a full text catalog on a drive which isn't part of
the cluster and probably doesn't exist either. This is the problem I'm
experiencing: not able to delete it or enable full text search because of
it.
I think I've worked out a way round the problem of re-enabling full text
search for the database by changing the path column in the
sysfulltextcatalogs table to a clustered resource. Hopefully once ft is
re-enabled I can then either delete the catalog or use it as is.
Ian.
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:BrTuYlRDFHA.3744@.cpmsftngxa10.phx.gbl...
> Hi lan,
> Thanks for your posting!
> Peter Yang is OOF and I am his backup!
> From your descriptions, I understood that you would like to create a
> full-text index catalog, which is on a disk on which the SQL Server
> resource is not dependant. In SQL Server 2000 virtual server instance, you
> will have to add the disk as a dependency to the SQL Server resource in
> the
> Cluster Administrator.
> Refer to the Knowledge Base article for more information and how to add
> the
> disk as a dependency
> INF: Creating Databases or Changing Disk File Locations on a Shared
> Cluster
> Drive on Which SQL Server 2000 was not Originally Installed
> http://support.microsoft.com/?id=295732
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a w to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/defaul...rnational.aspx.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Cant connect to remote server using SSMSE in Vista

Hi,

Sorry if this is the wrong forum.

I'm trying to connect to a remote server (on shared hosting) with Management Studio Express. I tried using it on Vista and it connects to the server and database perfectly. However, on Vista it gives the following error everytime:

TITLE: Connect to Server
----------

Cannot connect to sgc.gbdns.net.

----------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

----------
BUTTONS:

OK
----------

However, the host obviously has SQL server to allow remote connections as I'm able to connect from XP.

Both the XP and Vista PCs are running Avast free edition (the same builds) and both are running Windows firewall with management studio allowed through. Can anyone help?

I do not seam to have that problem on vista. I am running the sql express service pack 2 ctp(service pack 1 and earlier do not run on vista). Also when I start SSMSE I right click on the icon and select run as admin.|||

Thanks for your reply.

I don't habe the SP2 CTP installed. But isn't that for SQL Server rather than management studio? Plus, is your network set up as home, office or public location? I tried running as admin, running with compatibility mode set to XP SP2, nothing's working.

I also noticed that in windows firewall, management studio isn't listed as one of the programs by default. When trying to connect to the remote server, windows firewall doesn't ask me if I should allow the connection. I manually added management studio as an exception in windows firewall, but that didn't help. It seems the connection request isn't even going to windows firewall as it's not asking me to allow permission. Any ideas?

|||I also tried turning firewall and avast off. Didn't work.|||I could not even log into my local sql express on my machine until I loaded sql express with service pack 2.|||Thanks for the info. I guess I'mm lucky. I'll try SP2, but I still have doubts. I think our ISP may be blocking that port. Not sure, but I tried connecting from an XP of a friend who uses my ISP, and it failed. I'll check more possibilities tomorrow.|||

Hi,

The SQL Server 2005 might don't allow remote connection by default. You can try to enable it according to the following KB article.

http://support.microsoft.com/kb/914277/en-us

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and we will look into it again. Thanks!