tacticalts

I have a server running Windows Server 2008 Web R2. What I am trying to accomplish is to have this server host a local network and an instance of SQL Server 2008 R2 Express for

First I changed the servers IP to static and assigned it the IP that the dhcp router gave it. I then pointed the default dns to itself and the secondary to the router. I added the DNS Role to the server and created a DNS server. I then left the PCs settings for IP alone and only put in the ip to the dns server and secondary to the router. Restarted everything and now on the PCs if I try to browse for a SQL Server I see the other PC but not the phsical servers instance of sql server. I also tried to create a login from one pc for the other pc and it is still not able to "see" the other pc.

I do not have a domain setup. I was under the impression that since the PCs were already visible in the network map this was not necessary. Is DNS Server role needed for this to work correctly? The last time I setup a similar situation I was using SBS 2008 which had the ability to assign DHCP role to the server itself instead of leaving that up to the router. I think that took care of these issues but that role is not available in Server 2008 Web edition.

Thanks for the response. The setting for this is correct with Windows Authentication Mode selected for Server Authentication method. I believe this is a networking issue. When I am on a PC on the LAN and I open up SQL Server Management Studio and am about to connect to a DB I hit the drop down for server name and go to "browse for more". I then select the network tab and the only option is the actual PC that I am on. This is essentially the same problem as when I try to create a login for the PCs while on the server they are not visible in Management Studio.

I am running a small network with Server 2008 Web R2 on the server and Windows 7 on the PCs. They are all connected to a Linksys router that is setup with dhcp enabled. When I view the network map on PCs or Server I can see everything that should be on the network. However, when I try to add a login within SQL Server 2008 Express on the server to allow PCs on the network to access the database the only thing that is available is the Server. I want to use Windows Authentication as the connection method to the Sql database. Any help would be much appreciated.