Configure Access project for different SQL Server port?

[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.

 

[Sylvain Lafontaine]

You can change the default port the SQL-Server is listening on:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;815146
http://www.itsecurity.com/asktecs/oct3903.htm

It is also possible to configure some routers or to use a proxy so that the
internal port 1433 is mapped to another port on the outside.

However, making security by obscurity is not a big deal.

The ideal solution would be to use a VPN or some other kind of secured
tunnel.

S. L.

 

[Sylvain Lafontaine]

Instead of blocking the port 1433 for everybody, you can also use IPSEC
instead to protect it:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/HTUseIPSec.asp

S. L.

 

[facklis]

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.

 

[Sylvain Lafontaine]

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

S. L.

 

[Alex Dybenko]

run cliconfg.exe, add new alias for your SQL server, define a port there.
now you cn use this alias in access

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

 

[facklis]

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.

 

[facklis]

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.

 

[Alex Dybenko]

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

 

[Malcolm Cook]

Hmmm. This DOES work for me. Try again!?!?!

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.