Configure Access project for different SQL Server port?

  • Thread starter Thread starter facklis
  • Start date Start date
F

facklis

I have a Microsoft Access Project and would like to
connect to SQL Server 2000 on an internal network.
However, since the SQL Slammer worm, our internal routers
block the default port SQL Server listens on, 1433.

How can I configure my Microsoft Access Project to
connect to SQL Server on a different port? Is this
possible?

Your help is greatly appreciated.
 
Thanks for your response.

I know that SQL Server can be configured to listen on a
different port, but can Access projects (adp files) be
configured to communicate on the new port that is set in
SQL Server.

That's the question.

Thanks.
 
Did you try to add the port (separated by a comma) after the name (location)
of the server?

S. L.
 
Yes, I did try this in the Access project
File/Connection... menu, Data Link Properties dialog, on
the Connection tab, in the "1. Select or enter a server
name" text box.

And it didn't work =(.

Any other suggestions?

Thanks.
 
Alex,

Thanks for your suggestion. I tried running the SQL
Server Client Network Utility and adding an alias, both
using the default port (1433), and by having the port be
dynamically determined.

I couldn't connect to SQL Server from my Access project
when it is running on the same machine using the alias!

I am setting the alias name in the Access project
File/Connection... menu, Data Link Properties dialog, on
the Connection tab, in the "1. Select or enter a server
name" text box.

And it didn't work =(.

Any other suggestions?

Thanks.
 
Hi,
in Server Client Network Utility you have to specify a port which SQL server
configured to, not default or dynamic

then try to connect to this port using telnet - if telnet connects - then
access should also connects with correctly defined alias

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
Hmmm. This DOES work for me. Try again!?!?!


facklis said:
Yes, I did try this in the Access project
File/Connection... menu, Data Link Properties dialog, on
the Connection tab, in the "1. Select or enter a server
name" text box.

And it didn't work =(.

Any other suggestions?

Thanks.
Click to expand...
 
Back
Top