sql server connect: Hi,
Now there is a requirement for me to connect the remote server via internet.

Is it possible?
If yes, what i want to do.
I'm the beginner.

Please explain in detail.

Thanks in Advance.

Regards,
E.S.Mohammed Igbal M.Sc.,
Chella Software Pvt Ltd.,
Madurai.
Phone No: 5391927

Hello
If the SQL Server is behind a firewall, certain ports will have to be opened.

Try to use the following to connect
SQL authentication instead of Windows authentication
IP address of the SQL Server instead of Server name. Also use the port number.
Make sure that the port on which SQL Server is listening is opened at the firewall.

The following articles my help you get started.

287932 INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/?id=287932

265808 INF: How to Connect to an SQL Server 2000 Named Instance with the
http://support.microsoft.com/?id=265808

328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306

Hope this helps,

Deepali Ananth
Microsoft SQL Server Support

----------------------------------------------------------------------------
This posting is provided “AS IS” with no warranties, and confers no rights."
----------------------------------------------------------------------------