i have four computers connected to broadband ADSL router
MS SQL Server is installed in all computers while i have done steps given here http://support.microsoft.com/kb/914277 it had worked on local networking some time ago but now its not accessing remotely. i m confused its just because of broadband ADSL. if yes then what's the solution..if NO then why it is not working because if i want to ping the IP from client computer so it is pinging like
prompt> ping 192.168.1.20
but when i am logging from microsoft management studio as
authentication: sql server
even if i use this command
prompt> osql -S 192.168.1.20\sqlexpress -U sa
on local computer where main database is attached so it is working properly but when i am using the same command on the client computer of the network where ping is working there it is also not working....