Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    8

    Unanswered: SQL 7.0 TCP\IP Connection Problem

    Recently we had to bring down a SQL Server 7.0 box (7.00.1096) on NT 4.0 (sp 6a) for a power backup upgrade in one of the data centers. Nothing was changed on the Server but when we rebooted it there are entries in the the error log as shown below:


    2002-10-24 09:59:40.03 ods Using 'SSMSSO70.DLL' version '7.0.1063' to listen on '1433'.
    2002-10-24 09:59:40.04 ods Error: 17826, Severity: 18, State: 1
    2002-10-24 09:59:40.04 ods Could not set up ListenOn connection '1433'..
    2002-10-24 09:59:40.03 ods Operating system error 10013.,
    2002-10-24 09:59:40.04 ods Using 'SSMSSP70.DLL' version '7.0.694' to listen on '<ServerName>,33584'.

    Coupled with these entries is the fact that we are no longer able to make TCP\IP Connections (which I am sure is due to the errors invovling the SSMSSO70.dll which from what I have found controls TCP\IP SQL Connections) The only documentation I have found so far on the OS 10013 error is shown below:

    An attempt was made to access a file in a way forbidden by its file access permissions.

    Does anyone have any idea what may have happened or how to fix this issue?

    Thanks,
    Jeremy

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is the date/size/version for the file ssmsso70.dll ?

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    There is one bug I am aware of - see the following article:

    article

    Another possibility is that some other service has bound itself to 1433 before sql server.

    Let me know if you need additional assistance.

  4. #4
    Join Date
    Oct 2002
    Posts
    8
    The time stamp for SSMSSO70.dll is 45KB 4/9/02 3:21PM. I am taking a look at the articles you left as a link and they do seem promissing. Will let you know how I do.

    Thanks for your help,
    Jeremy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •