SQL Server Access through MMC on client machine 1

[ShabanaHafiz]

I installed SQL Server 2000 Database Server on a machine. Operating System on this machine is Windows Server 2003. Default instance and windows authentication were selected.

Then I installed SQL Server Client Tools on a client machine. Operating System on this machine is Windows 2000.

Now I need to access databases from client machine. On client machine, I created a group, Group1. But No items is being shown in this SQL Server Group.

On client machine, I started Query Analyzer, selected windows authentication, clicked select server button. In the Active Servers List, I selected the database server. When OK button was clicked, the following message appeared:
Unable to connect to server [servername]
Server: Msg 18456, Level 16, State 1
Login failed for user ‘username’

On client machine, I entered the following at the command prompt:
C:\>osql –E
Following message appeared:
[Shared Memory] SQL Server does not exist or access denied
[Shared Memory] Connection Open (Connect())

 

[ShabanaHafiz]

On client machine, I logged in as Administrator, deleted Group1 and again created SQL Server Group. Now I was able to access SQL Server databases.

But when I login with username other than Administrator on client machine, No items is shown in SQL Server Group.

 

[mutley1]

Log on to the server as administrator and open Enterprise manager. Expand the tree to your server, then expand the server and select security. Right click on logins and select "add". You need to add the domain account you want to use in here (e.g. DOMAIN\ShabanaHafiz) and give it relevant rights (if you are going to be the DBA then click on server roles and tick "system administrators"). The reason you can see everything logging on as administrator is the BUILTIN\Administrators has probably not been removed.

Once you have added the domain account, go back to your client machine and right click on the group and select "New SQL Server registration". Type the name of the server in the "available servers box" and then click the "add" button then "next". Then select windows authentication and that should register it on the client (provided you are logged in on the client as the account you added!).

Rgds,

M.