I have sql server 2005 and 2012 on my local system and i want to access both or one sql server on remotely, please tell me how,

i had try to access by enabling tcp/ip, given prot no as 1433, turn off windows firewall, and i also check for sql server has remote is enable.

Please solve my probleme asap...

I have sql server 2005 and 2012 on my local system and i want to access both or one sql server on remotely, please tell me how,

i had try to access by enabling tcp/ip, given prot no as 1433, turn off windows firewall, and i also check for sql server has remote is enable.

Please solve my probleme asap...

• Merged by Olaf HelperMVP Friday, June 19, 2015 12:18 PM Same question from same OP

Which error message are you getting when you try to connect? Is "SQL Server-Browser" running? Have you followed all steps mentioned here: Configure the remote access Server Configuration Option See also Configure the Windows Firewall to Allow SQL Server Access

Hi helloMahendra,

As other post, please help to post the full error message for analysis.

And I would recommend you follow the general steps in below blogs to troubleshoot connecting to SQL Server.

How to Troubleshoot Connecting to the SQL Server Database Engine
http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

Steps to troubleshoot SQL connectivity issues
http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx


Thanks,
Lydia Zhang