Sql Server database access as client from outside over internet

Question

Dear Everyone i have installed Sql server 2005 enterprise manager in my home. now i want to access this database from my office as a client role. how is it possible please help to do the same as step by step.

Answer 1

Hi,

if it is a standard installation of SQL Server you have act as follows:

1. Enable port rule on your firewall to allow access to sql server on port 1433 tcp
2. Create a sql server login on the sql server
3. Open SSMS and enter the dns of the location.
4. Logon with SQL Server Authentication
5. Use your created sql login and password

Get more details for accessing sql server over the internet here:
http://msdn.microsoft.com/en-us/library/ms175483(v=sql.105).aspx

---

Uwe Ricken

MCSE - SQL Server 2012
MCSA - SQL Server 2012
MCITP Database Administrator 2005
MCITP Database Administrator 2008
MCITP Microsoft SQL Server 2008, Database Development

db Berater GmbH
http://www-db-berater.de
SQL Server Blog (german only)

Answer 2

Hi

Fast you have to check your IP and ping in client place and then you have to check named pipes TCP/IP is Enable 

and also you have to check port 1433 is open or not

example : Start menu-->Run-->CMD-->telnet  (IP Add and port no) 1.1.10.1 1433