Remote SQl connection

I have a SQL server that was formatted and reconfigured. Prior to the
format, I was able to access this server from remote locations by creating an
ODBC connection in Administrative Tools in Windows XP. I haven't changed my
firewall or the server IP. As far as I can see, everything should be the
same. The problem now is that I can't create an ODBC connection unless I'm
on my network and a member of the domain. Even if I'm with my network, but
not a member of the domain, I can't create the ODBC connection.
The server is set up using mixed-mode authentication and as I mentioned, I
can create this connection if I'm on the domain. Any suggestions as to why I
can't do this remotely? Thanks in advance for your help.Hi
Can you see the server (using ping?). Which protocols do you have enabled?
Is the SQL Server on the domain? Have you re-created the users, logins and
trusts to be exactly the same? What error message do you get?
John
"J.B.C" <JBC@.discussions.microsoft.com> wrote in message
news:F9887DA2-34B9-42F2-A903-CBF04CE9DDD7@.microsoft.com...
>I have a SQL server that was formatted and reconfigured. Prior to the
> format, I was able to access this server from remote locations by creating
> an
> ODBC connection in Administrative Tools in Windows XP. I haven't changed
> my
> firewall or the server IP. As far as I can see, everything should be
> the
> same. The problem now is that I can't create an ODBC connection unless
> I'm
> on my network and a member of the domain. Even if I'm with my network,
> but
> not a member of the domain, I can't create the ODBC connection.
> The server is set up using mixed-mode authentication and as I mentioned, I
> can create this connection if I'm on the domain. Any suggestions as to
> why I
> can't do this remotely? Thanks in advance for your help.