May 11, 2010 at 2:18 am
Hi,
We have created a local user (admin1) as member of administrator group, on our Sql 2000 server.
Now when this admin1 logs on and starts Enterprise manager, the (local) (windows NT) is not appearing under SQL Server Group.
Please guide me, on how to give full rights similar to administrator account to access SQL enterprise manager.
May 11, 2010 at 8:02 am
Two questions:
1) Have you tried to register SQL Server under SQL Server Group in Enterprise Manager?
2) Can you verify that BULTIN\Administrators group has login on SQL Server?
May 11, 2010 at 11:23 pm
I havent tried to register the sql server in this user profile's Enterprise Manager.
How can i check if this user have administraive right to sql server, I have added the user to the local administrators Group.
May 12, 2010 at 6:39 am
Try to connect with command line (you have to log in as this new user):
osql -S SQLServerName -E -d master -Q "EXEC sp_helpsrvrolemember 'sysadmin'"
May 12, 2010 at 11:09 pm
Sorry for the delayed reply, my main concern is not to interrupt any database or its related services.
as this is my production server. So the command you have mentioned will not affect any thing on my services related to the database.
May 13, 2010 at 6:45 am
No, it will not interrupt your production databases. The command is very safe. Check the output from this command. It should return list of SQL Server sysadmins. If you get an error when you run this command then it means account does not have permissions on SQL Server. If you see BUILTIN\Administrators in output it means that your account has sysadmin privileges on SQL Server.
May 14, 2010 at 4:26 pm
Just to append to what magasvs posted, you can also see if the account has permissions by opening up Enterprise Manager with that account and registering the local server and seeing if it connects to the instance. When Enterprise Manager opens up, right click on "SQL Server Group" (I believe that is the default group created) and select "Add registered server". When the wizard comes up, type the name of the system and click "Add". Go through the rest of the wizard and it will test the connection. If successful it will add the server to the list of registered servers. You should then be able to drill down in Enterprise Manager and see the objects in the SQL instance.
If it does not work, then you have a security problem somewhere. Probably Built-in\Administrators is not a part of the sysadmins role.
Joie Andrew
"Since 1982"
May 16, 2010 at 6:35 am
thanks solved.
Just simple registration wizard.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply