asked on

Cannot connect to SQLServer from remote machine

Hello,

I install SQLServer 2005 x64 bit on my 2008 server. However, I cannot connect to it from a remote computer using ODBC or another SSMS. I cannot see the instance

It is name instance I called CQ2005 --

I did the following
-- enable remote connection
-- All service is running (SQL browser, database engine)
-- create firewall rule for port 1433 and 1256
-- I can connect to using ODBC and SSMS from the localhost

Chris Mangus

Can you at least ping between the two machines? If you can ping then you might need to enable TCP/IP protocol in SQL Server Configuration Manager.

Getsum_Bloodlust

Do you have Windows or SQL Authentication enabled?

mikeewalton

Make sure you have followed all 3 of these steps. Easier to send the kb than type it all out.

http://support.microsoft.com/kb/914277

SOLUTION

Aaron Tomosky

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SiemensSEN

ASKER

Thanks,

cmangus -- I can ping between machine
Getsum -- I have both SQL and Window Authentication
aarontomosky -- I have 1433 as the last ip all setting
but still the same issue

--Mike,
I follow the instruction in the link except for "Create exceptions in Windows Firewall" It seem to imply that this should only be done for Windows XP Service Pack 2 (SP2) and in Windows Server 2003.

My server is 2008 do I still have to do this step

Thanks

ASKER CERTIFIED SOLUTION

mikeewalton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SiemensSEN

ASKER

Also, my SQLserver is standard edition. I intall it using a domain account that is in the server admin group.

Thanks again

SOLUTION

SiemensSEN

membership