I just Installed SQL Server on 2nd Machine in our LAN. No domain is created, all PCs have same workgroup.
1st installation of SQL Server is visible on all networked computers, but 2nd Installation on another PC is only visible on local machine, no other networked machines can connect or view this SQL Server.
Following is services status:-
SQL Server (MSSQLSERVER) Started Automatic
SQL Server Agent (MSSQLSERVER) Manual
SQL Server Analysis Services (MSSQLSERVER) Started Automatic
SQL Server Browser Started Automatic
Please guide as to what else should be checked.
Aman
-------
Lets fly away to the Land where there is Love & Peace