Well, first of all, SQL Server by default listens on port 1433, not 1033.
Then, if you have a visual studio.net, you can try to run the following
function:
Public Function IsSQLServerAvailable( _
ByVal ServerAddress _
As String) As Boolean
' Tests an SQL Server connection by
' name or IP address
Try
' Attempt to get server address
Dim objIPHost As New System.Net.IPHostEntry()
objIPHost = _
System.Net.Dns.Resolve(ServerAddress)
Dim objAddress As System.Net.IPAddress
objAddress = objIPHost.AddressList(0)
' Connect to port 1433, most common SQL Server
' port. If your target is different, change here
Dim objTCP As System.Net.Sockets.TcpClient = _
New System.Net.Sockets.TcpClient()
objTCP.Connect(objAddress, 1433)
' No problems (hurrah!)
' Close and cleanup
objTCP.Close()
objTCP = Nothing
objAddress = Nothing
objIPHost = Nothing
' Return success
Return True
Catch ex As Exception
' Server unavailable, return fail value
Return False
End Try
End Function
It basicly tests if theer is a server running at address 'ServerAddress' on
port 1433, or whatever port is setup on your system.Also, if it's not a big
issue for you meaning that it's just a test server, not a production one,
i'd recommend to reinstall SQL Server, because as i've posted earlier,
Service pack 2 SUCKS real bad. I literaly couldn't find half of my programs'
dlls after the beast got it's paws on my CPU :)I wish i was at that
computer, i might figure out something more valuable, but in the meantime if
i was you i'd first reinstall Windows XP to get rid of Service Pack 2, and
then reinstall the rest... Pain in the ass, man, but Microsucks teaches us
patience and respect for repetitive work :)Anyway, can you access your sql
server using Query Analizer or Enterprise Manager? If no, then your database
is not running. period.
"William F. O'Neill" <wf******@bellsouth.net> wrote in message
news:E%******************@bignews3.bellsouth.net.. .
I disabled the firewall, and still cannot connect; get error message about
connect(). Any other suggestions? Should I attempt to reinstall SQL
Server 2000?
"Muzzy" <le*******@yahoo.com> wrote in message
news:VD7Zc.78561$9d6.23796@attbi_s54... You don't reset the port itself.
What hapened is that XP SP2 by default enables built-in firewall
blocking incoming and outgoing connections
on all the ports other than the service ones (like http:80)
What you can do is just disable the firewall - for this you right click
on your network connection
and somewhere in properties you will find firewall settings
But frankly, SP2 sucks, half of my apps didn't want to start after i've
installed the beast, and teh only remedy was to reinstall the OS.
HIH
Andrey
"William F. O'Neill" <wf******@bellsouth.net> wrote in message
news:cj***************@bignews4.bellsouth.net... Am using Powerbuilder 8.0.4 and SQL Server 2000. Have just installed
Windows XP SP2, and can no longer connect to my SQL Server db. Someone
suggested that I need to reset the port for the db at 1033. Is this
the correct port number, and how do I change the port?