Remote web server(linux) connot connect to sql 2000
-
hi all , i have rpoblem with connection on mssql 2000
i'll exp. i tell to my hosting (is not free) , they up setting on connection with mssql , but my server(mssql) block request, why..?
i use firewall , but the port 2433 , i change it for securety reasons!
i change the password on "SA" acc , not work... i create new user , does not work again...
they server (linux) TRY to connect to me, i see that because i have one program.
i test to check the port on linux (hosting server) , but the port is opened :w00t:
where I wrong?
-
Hello,
Is SQL Server returning an error message to the Linux Machine, or can you see any Logon Failures in the SQL Server Log? If so, please post an example.
Using the same Connection String as the ISP, can you connect from a local Client to the SQL Instance?
Can the ISP successfully Ping your SQL Server?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group -
no back error from sql to linux
last errors , download the txt file
telnel "MY WAN IP" 2433 and i see black sreen only, but i go to my freind with other ip and then enter the telnet command - error msg somethink like that ;connection lost;
see the attachment files..
why no have TCP open port to sql ?
cmd2 - one program, i see everything in there
only local ip have on port 2433 - cmd1 :crying:
-
Hello again,
As an attempt at a quick fix you could try disabling "Force Protocol Encryption" in the SQL Server Network Utility.
If that doesn’t work then have a look at this MS Troubleshooting guide:
http://support.microsoft.com/kb/827422
The Section “Troubleshoot stress on TCP/IP sockets” may relate to your issue.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group -
"Force Protocol Encryption" is unchecked
-
on clear windows.. (fresh windows
)and that fuc*in error again !! :w00t:
Why ?!
-
Hello again,
There are a couple of Threads around relating to the Error Message that you receive which suggest it could be a problem with the Driver your ISP is using. Can you check exactly which Driver they have?
Also, did you go through the MS Troubleshooting guide? Any positive findings from that?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply