Server 2008 Web R2 Networking Issue

[tacticalts]

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.

 

[ICTCity]

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.

From msdn:

To change security authentication mode

1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
3. In the SQL Server Management Studio dialog box, click OK, to acknowledge the need to restart SQL Server.

To restart SQL Server from SQL Server Management Studio

1. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.


Tell me if this resolves your problem

 

[tacticalts]

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.

 

[ICTCity]

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.

Excuse me... do you have a domain? Is your server / are yours clients joined in that domain?

 

[tacticalts]

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.

 

[ICTCity]

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.

From what I know it's not possible without a domain...

I'm not sure at 100% but... well how can SQL server authenticate users without query a domain???

So I can say I'm almost sure you can't do that without a domain

 

[tacticalts]

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.

 

[ICTCity]

(...) 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 don't understand... what you mean by "browse for a SQL server"? You try to discover the SQL server from network or from SQL Server Management Studio?

Then I don't understand what you are trying to do by creating a login to one pc (local user), you want to try to connect locally from one pc to another?


Tell me: if you open the SQL server manager from a client and you put the IP in the server's field, are you able to connect to it via SQL credentials / windows auth?

Sorry for all these questions but I'm not understanding what's the point...