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.
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
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 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.
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.
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?
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??
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?
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!
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.
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.
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?
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
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?
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 ?
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 :)
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?
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.
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.
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.
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