User Administration Tools

Nov 6, 2001

Does anyone have a user administration tool that they like? It seems that there are two common operations that have to be performed:

1. Create a new login for a user, and grant all of the database access rights and role memberships already assigned to another user. In other words, "Make User B just like User A." This same operation has to be performed for multiple servers.

2. Copy a login to a different server. This is usually done to add someone to a test environment. The database names and role names are the same, but the server is different.

In our environment, adding a new employee involves going to three different servers, finding a "model" login, and adding the database access rights for three or four databases, with three or four role memberships in each database. Some databases have thirty or more roles defined, so it's easy to miss a checkmark when scrolling through a list of that size.

I have tinkered with some scripts to do this, but they usually fail because things like sp_addrolemember only work in the current database. I am about to start writing something in VB to do this, but I don't want to reinvent the wheel if someone has already done something similar.

View 1 Replies


ADVERTISEMENT

SQL Server Administration Tools

Jul 20, 2005

I'm searching for some alternate administration tool (permisions, rights,etc.) on sql server, something not so complicated as default. Does anyonehave some info about that? ThanksPete

View 1 Replies View Related

User Administration ...

Mar 15, 2007

Hi pals,

I want to create a user in sql server 2000 and i need to give only
INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,CREATE PROCEDURE,ALTER PROCEDURE,DEBUG PROCEDURE,EXECUTE PROCEDURE permissions. i dont want give Administrative priviliges. He should not be able to alter table structures/drop tables.

In SQL server 2005 ihave the concept of DDL triggers so that i can track and restrict whatever suspcious activities (dropping columns,changing datatypes) being done by the database users.

But in SQl Server 2000, what i can do i want restrict the users. to

I need this.can any one me help me out.

Regards,
franky

View 2 Replies View Related

SQL Tools :: When Was Database Last Accessed By Each User / Login In Server

Jul 6, 2015

I have a plan of decommissioning of unused databases which are not been in use for quite some time. is  there any simple way/t-sql to find out When was the database last accessed by each user/login in sqlserver.

View 2 Replies View Related

SQL Tools :: Error - Unable To Access User Principal Information From The System

Aug 25, 2014

I am not able to launch the Kerberos Configuration Manager due to the above error.

View 4 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View 3 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
 sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
 

View 2 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Server Tools Or Client Tools?

Jun 16, 2008

Dear All,
how can we know that wether we had server tools or client tools on my machine?

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Tools Tools Tools For Performance ???

May 16, 2002

Know any good performance monitoring and analysis tools for SQL server.

View 1 Replies View Related

Administration

Nov 7, 2007

Hi,

I am looking for TSQL book for Administration
Could anybody help ASAP.

Frozen

View 3 Replies View Related

DBA Administration Db

Mar 13, 2007

HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?



Thanks

View 1 Replies View Related

Can You Do SQL Server Administration From An ASP.NET App?

Jun 11, 2007

Is it possible to write an ASP.NET app that can do certain SQL Server 2000 administration tasks, specifically add sql server users, and change sql server user passwords?  Would it just be a matter of running the appropriate system stored procedures (sp_password, etc.), or does .NET provide any hooks into SQL Server for something like this?  Thanks!

View 5 Replies View Related

MSSQL Administration

Feb 17, 2008

The job failed.  The Job was invoked by User SERVER110Administrator.  The last step to run was step 1 (Subplan_1).
anyone know what this error means?

View 1 Replies View Related

Database Administration

Oct 5, 2001

To All SQL Guru's

I have this simple problem. How can I make SQL Enterprise Manager list only one database that is accessible by client who registered the SQL Server on his / her Enterprise Manager. The user has been granted access to only one database. But every time I register the server in the client's SQL Server Enterpise Manager it lists all database and user database with it.

I just want it to show only one or two or as how many database that login has granted access to and eliminate the database from the SQL Server Enterprise Manager's database list.

Please Help

Thanks

View 3 Replies View Related

Remote Administration

Apr 13, 2000

Hi!
I need to connect to a database located in another city and administer it from my place.Can any one suggest the basic hardware and sql server(std/enterprice edition?).Shall it be on NT work station or server?Any limitations in administering this way due to some reason we can't move it entirely here.Please advice.
Thanks.

View 2 Replies View Related

Remote Administration

Nov 28, 2000

Hi all,
We are about to have 'colocated servers' for our web pages, mail and on line catalogues. The NT administrator is going to use 'pcAnywhere' to administer the servers. I prefer to register the SQL server in Enterprise Manager,using the IP address.

Are there any known advantages between pcAnywhere against using enterprise manager, particularly any security issues?

Many thanks in advance
Keith

View 1 Replies View Related

Administration Of SQL 7 Over The Internet

Jan 21, 2000

Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet

Vijay

View 1 Replies View Related

MSX Multiserver Administration

Feb 18, 2002

I have configured a master server to do multiserver administration and configured my production server as a client. My problem is that when I try to create a multi system maintenance plan it says that I get a security error and it won't create the plan. I have local admin rights to both systems. Do I need domain admin rights?

View 2 Replies View Related

SQL 2000 Administration

Oct 11, 2006

Can anyone help me how to monitor the growth of transaction log of our SQL Server?... How will I maintain it?..

View 4 Replies View Related

Multiserver Administration

Oct 29, 2005

I want to set up Multiserver Administration.The problem I encounter is a firewall between the master server and sometarget servers.What ports need to be set open to make this possible ?

View 1 Replies View Related

SSAS05 Cube Administration?

Jul 25, 2006

Hi all!

We would like to create an Intranet based cube administration tool.
Power users should be able to process cubes and dimensions. This works
and all the cubes, dimensions and even databases from the SSAS can be
displayed in the web! ASP.NET@C# combined with
Microsoft.AnalysisServices offer a lot of very good possibilities!

But we still have a problem:
How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window??)??
When a cube/dimension is processed the user does not get ANY feedback
(of course the webserver waits to finish the process() method.
I tried to start a different thread an this even works!
I want to show our powerusers at least some kind of progress (%, events, what ever).

can someone help?? we are totally lost with that topic!

I already had a look at the example from:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1
But it did not lead me to a propper solution :)

TIA and regards

JohnnyR

View 1 Replies View Related

SQL Server Administration And Config

Mar 2, 2004

I'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration.

1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and DB Backups, however the Integrity Checks fail with the error that the DB's must be in single user mode, how can I go about to make this and what are the implications of doing so?

2. There's been a few reports of MSSQL server compromises through UDP port 1433, so I closed it at firewall level, only TCP 1433 is going through, do I really need UDP 1433?

Thank you very much.

View 1 Replies View Related

SQL Database Administration Tool

Jun 26, 2005

Hi...
Does anybody know of an open source script I can download that will enable me to manage an SQL database? I basically need to access and modify the database from any machine that may not have SQL Enterprise Manager Installed. I was thinking of writing my own script to do this but I assumed that there is probably already one out there.

View 6 Replies View Related

SQL7 & SQL2000 Administration

Dec 1, 2000

Is it possible to administer both SQL7 & SQL2000 databases from the same console ?? It's fine administering SQL 6.5 & SQL7, as 6.5 had no MMC, but it seems that SQL7 & SQL2000 have the same MMC.

Thanks,
Jazz.

View 1 Replies View Related

SQL Server 7 Remote Administration II

Oct 30, 1999

Sorry for starting a new thread on this subject but my situation is a bit different.

I want to connect to a remote SQL-server in a DIFFERENT domain, using Enterprise Manager. Whatever I try, I allways get an "SQLserver not found"-error.

The ASP's on the server that make use of the SQL server are functioning without any problems, so I guess the SQL-server itself is OK.

I tried:
servername = URL remote server
setting up a linked server
setting up a remote server

I'm a webdesigner and a newbe to SQLserver7. Please keep in mind I could be overseeing something that very obvious for you.

So what could be the problem. Any tips? Thanks!

View 2 Replies View Related

Remote Administration Of SQL Server 7.0

Jan 26, 2000

Is there a way to remotely control SQL server 7.0 from NT workstation
and win98?

Thanks
williams

View 1 Replies View Related

Web Administration Of SQL Server 2000

Jul 11, 2001

Hi

i Would like to know is there any tool which would allows me to manage database over the web i.e from a brower

if any tool is there can any one let me know from where i can get it


thanks
Prasad

View 1 Replies View Related

System Management Administration

Oct 19, 2006

what is the best firewall protection for network computer?

View 1 Replies View Related

SQL Server Administration Jobs

Mar 27, 2007

(Post removed)

View 3 Replies View Related

Database Administration Survey

Jul 23, 2005

Hi,We are a systems research group at the Computer Science departmentatRutgers University, and are conducting a survey to understand detailsabout network, systems and database administration. We hope that thisinformation would help us recreate a realistic environment to helpresearch in 'systems management'.We request network, systems, and database administrators to take thissurvey. As an incentive, all surveys completed in their entirety willbeentered into a drawing of a number of $50 gift certificates (fromAmazon.com).We hope you have a few minutes to take the survey which is located at:http://vivo.cs.rutgers.edu/administration_survey.htmlResearch in our group:The goal of our research is to improve the overall availability andmaintainability of services. Since administrators form an integral partof these services, a key aspect of this work is to build environmentsand tools that ease the task of service administration. In particular,environments which would help administrators know how their actionsmight impact the real service (before performing them for real), webelieve would be useful in preventing inadvertent actions. This surveytries to understand the existing environments, what administrators docurrently to test the 'validity' of their actions, and the difficultiesthey face in doing so. The two specific systems we are looking at arenetworks and databases, as we believe these are important components ofmany services.If you have any questions regarding this survey or our work, feel freeto email us:Fabio Oliveira (fabiool at cs || rutgers || edu), orKiran Nagaraja (knagaraj at cs || rutgers || edu)Thanks for your time,Fabio OliveiraPhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)Rutgers University

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved