login to mssql2k on win2003 from linux/php

  • Hello!

    I have a problem connecting from a php script witch runs on linux server to a MS SQL Server 2000 on Windows 2003 Enterprise os.

    I noticed that the port for sql 1433 is not opened by server ???

    How do I enable the port?

  • What edition of sql server are you using? If MSDE the network libraries are disabled as part of the install.

    Was it installed with tcp-ip?

    You can check the sql server log files to see what port (if any it is listerning on), and you can use the 'Server Network Utility' to enable/disable a protocol.

    Hope this helps

    Steven

    Steven

  • I have enterprise version of SQL server and TCP/IP protocol enabled with port 1433.

    netstat doesnt print the sql server port, when I am connected to the SQL server I have a connection with a port named microsoft-ds.

  • Check the sql server log file to see if the sql server service could take the port. Sometimes other applications take the port before sql, and this is reported in the log file.

    Steven

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply