473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Server 2000 & MS SP2

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?

Jul 20 '05 #1
5 3819
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?

Jul 20 '05 #2
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?


Jul 20 '05 #3
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?



Jul 20 '05 #4
[posted and mailed, pleaes reply in news]

William F. O'Neill (wf******@bellsouth.net) writes:
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"'s suggestion to turn off the firewall was really bad, and his
suggestion to reinstall Windows XP SP2 is even worse. First of all, if
you really need to go back, just uninstall the service pack. You did
check the option to save backup files didn't you.

For the record, I have had very few problems with Windows XP SP2.

It is difficult to say what the exact problems may be in your case, since
you don't give much details or error messages. Are you running PowerBuilder
and SQL Server on the same machine?

There are means in Windows Firewall to make exceptions so that the firewall
does not block port 1433, and you do this per network. Now, here is a very
important thing: if that network is exposed directly to the Internet, do
not unblock SQL Server! Least of all if you are using SQL Server
authentication. You are only asking for uninvited guests.

This KB article collects a whole set of KB articles on SQL 2000 and XP SP2.
http://support.microsoft.com/?kbid=841249.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #5
Erland Sommarskog wrote:

"Muzzy"'s suggestion to turn off the firewall was really bad, Well, it bothers more than helps for me at least. But frankly, i have a
hardware firewall :)
and his
suggestion to reinstall Windows XP SP2 is even worse. First of all, if
you really need to go back, just uninstall the service pack. You did
check the option to save backup files didn't you. Well, i suggested to reinstall Windows XP, not SP2.
Regarding rolling back the SP2 instalation, it failed for me - it did
complete, killing all my drivers(network, printer, scanner, video) and
also deleted a few dll's which were installed and used by some other
programms, whch was kinda weird.


For the record, I have had very few problems with Windows XP SP2.

It is difficult to say what the exact problems may be in your case, since
you don't give much details or error messages. Are you running PowerBuilder
and SQL Server on the same machine?

There are means in Windows Firewall to make exceptions so that the firewall
does not block port 1433, and you do this per network. Now, here is a very
important thing: if that network is exposed directly to the Internet, do
not unblock SQL Server! Least of all if you are using SQL Server
authentication. You are only asking for uninvited guests.


Well, again, check if you can connect to the database thru Query
Analyzer or Enterprise Manager.

Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: JShurmatz | last post by:
If anyone can shed some light on this problem I would greatly appreciate it. I am unsuccessfully trying to use a database connnection retrieved from a pool configured using Java System Web...
2
by: James Allan | last post by:
Hello -- I'm trying to get SQL Server 2000 on a Windows 2000 Server to be able to query an Active Directory. We've got two domain servers one Win2000 and one Win2003. However, I'm having...
0
by: Melanie Black | last post by:
I am currently running a windows 2000 machine with asp, sql server, mail server, ftp server etc all on the same box. The site runs several hundred ecommerce stores. Recently the processor...
2
by: Manish Naik | last post by:
Hi, Using ASP.Net, I want to store and retrive documents (Word, excel, etc) from SQL Server 2000 database. I have tried image type data field, but could not succed. Can any one help me please. ...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
9
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some...
3
navanova
by: navanova | last post by:
hi guys, I'm developing an application using vb.net and sql server 2000. the data in the database are shown on the form using datagrid. I want to delete a single row from the datagrid as well as from...
2
by: Neil | last post by:
Has anyone heard of any problems running SQL 7 under Windows Server 2003? We're upgrading to 2003 and are wondering if we can keep SQL 7 with the new OS. Question 2: If we upgrade SQL to SQL...
6
by: avcitamer | last post by:
We upgraded our system and problem below occured, pleas help me... Windows 2003 server SP1 When I set a decimal DB field value to "123,32" (using ADODB.recordset ) updated value was ok (123.32)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.