Thursday 22 March 2012

connect to New instance on SQL Server

I have install a new instance of SQL Server and I can
connect to the new instance inside the network. But we
have users who coonect to SQL Server from Remote location
using VPN and they cannot connect to this new sql
instance, the error this 'server not found'.
They are able to connect to default instance.
Thanks in advance.
TomHow about if they use the Client Network Utility to set up an alias for the
server without a backslash in it and specify the port (if using TCP/IP).
Also make sure their MDAC version is 2.6 or higher and check whether the VPN
allows UDP 1434.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"tom" <t@.gg.com> wrote in message
news:00e301c377ad$88a88960$a101280a@.phx.gbl...
I have install a new instance of SQL Server and I can
connect to the new instance inside the network. But we
have users who coonect to SQL Server from Remote location
using VPN and they cannot connect to this new sql
instance, the error this 'server not found'.
They are able to connect to default instance.
Thanks in advance.
Tom

No comments:

Post a Comment