Jaime's questions

I am adding a new Login with SQL Server Authentication. I set its Server Role as public and then went into User Mapping, selecting the only database this user should have access to. I then change the Default Schema to dbo and made this user the db_owner.

I then connect to the instance using the new user's credentials and I can see not only the database he should have access to but all the other attached databases.

How can I limit this user to just see the database he has access to?

Thanks in advance!

I am trying to configure the LAN settings of a Windows 2008 server remotely via netsh. I've been trying this command (issued at the client) assuming the IP address of the server is 192.168.0.1:

netsh -r 192.168.0.1  -u 192.168.0.1\Administrator -p password lan show config

but I keep getting the following message:

WARNING: Could not obtain host information from machine [192.168.0.1]. Some commands may not be available.

The RPC server is unavailable.

Am I understanding the command above properly? Is there a step or two that I missed in setting this up?

Thanks in advance.

P.S. The Routing and Remove Access service on the server is enabled.