Remote Access to SQL Server 2008

[Anthony Smith]

God Bless You Everyone,

I hope everyone is doing well. I'm a new excited father and husband that
just saw the ultrasound of our babe in the womb!

Can anyone tell me if it is possible to connect to Sql server through an
ODBC driver & utility? We have an MS Access application that we want to
connect to a remote SQL Server. Please advise, thanks!

Sincerely,
Anthony Smith
Praise God for our new babe in the womb!

[Alex Dybenko]

Hi,
yes, it is possible, but you need to be sure that sql server port (1433 by
default) is open on remote server and you connecting using TCP/IP protocol

Have a look here:
http://msdn.microsoft.com/en-us/library/ms345343(SQL.90).aspx

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

"Anthony Smith" <antsm...@gmail.com> wrote in message
news:OpkmEdiE...@TK2MSFTNGP03.phx.gbl...

[Mary Chipman [MSFT]]

In addition to the resource Alex pointed you to, you'll want to
research best practices from the Access side:

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

Congratulations on your happy event :)

--Mary