Kbase P115600: SQL92 user makes connection to database but gets no data from queries.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/04/2006 |
|
Status: Unverified
SYMPTOM(s):
SQL92 user makes connection to database but gets no data from queries.
SQL permissions are correct for user.
Same SQL92 user successfully retrieves data from another machine.
Machine which fails to return query is behind a firewall.
CAUSE:
The range of ports open for the firewall did not include the _sqlsrv2 process ports.
FIX:
Use the -minport -maxport options to mandate what ports will be used by the Primary or Secondary Brokers for all server processes.
P19269, How to define the range of ports for the server processes that are spawned by the database broker?