Thanks,
Sorry as I have posted in a 2008 forum but we have Sql Server 2005 and 2005 SSMS.
I have tried both Sql server and Windows.
I couldn't login so unable to check any other things except I have mentioned.
osql -L
==> Servers:
Local
MTDB
Servers:
— NONE –
>sqlcmd -L
Servers: MTDB
2) Enabled TCP/IP in SQL Server Configuration
3) All Firewall are off
4) Enable Remote Connection
5) SQL Server Browser Service is enabled
6) Created exception of sqlbrowser.exe in Firewall
7) No Alias!!!