SQL Admin Wages

May 4, 2000

Hi,
I am fairly new to SQL server admin.
What sort of wages are paid for this type of work.
Is there a shortage skilled administators in this area?
Does the MSCE DBA increase your wages?
Thanks

View 1 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out

Aug 27, 2015

I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.

I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.

I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).

So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.

View 0 Replies View Related

Admin Access To SQL Without Server/domain Admin Access

Sep 6, 2007

We are using Win2k3 R2 with SQL 2000 in a domain environment.

Is it possible to create a domain group to grant admin level and user level access to SQL2000/2005 without giving users server admin or domain admin access?

It has always been my impression that to have admin access to SQL that you had to at least had admin level access on the server.

Any clarification would be greatly appreciated.

Thanks!

View 1 Replies View Related

Web Based Admin

Jun 25, 2006

Does anyone know of a web based front end to Microsoft SQL Server 2005 Express edition? I tried using the SQL Server 2000 server web admin tool from microsoft, but it will not allow me to install it because it says it need the 1.1... framework installed. I have 1.0,1.1,and 2.0 installed, is there anyway to circumvent this? Or has anyone else figured another way to get the webadmin tool to work with 2005 express edition.
Thanks!

View 6 Replies View Related

SQL Web Admin Tool

Mar 4, 2004

Hi,

I've been having trouble getting this tool to work with my server/database. I'm using XP Pro, MSDE, .NET 1.1.4322 and IIS 5.1. IIS has been installed and tested with the help of others. .asp pages are being served locally and to another PC on the network. No obvious problem here. When I installed MSDE I used the SAPWD='strongpassword" command to create a password. I also built a new database. I had positive feedback on both of these actions.

Now to the tool - when I activate the administrator it pops with the little window saying Web Server Configuration. It lists the following options:

Desired Port:
IIS
Cassini Personal Web Server
Restore Faults

and Start and Stop buttons.

If I leave the setting on IIS and click Start it opens a webpage entitled Web Data Administrator. Moving further down I have a welcome message and then the line -

Please enter a SQL Server name:

Username: [Desktopob shadowed entry]
Password
Server (local)

Authentication Method:

Windows Intergrated
SQl Login

and then a Login button

If I select SQL Login and enter "sa" as the username and then my password leaving (local) as the server I get the following error:

Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.

I have tried all combination of \desktopsa, sa, you name it. The password I selected is correct because I made a point of writing it down so I wouldn't forget it. I have also tried all the combos using Cassini as well.

This is where I'm stuck at this point. All suggestions are appreciated.

Thanks,
Bob

View 3 Replies View Related

Web Based Admin MS SQL

Dec 1, 2005

Is there a web based admin to administer MS SQL? If there is a free one, that would be better.

View 2 Replies View Related

Help: MSCS Admin

Apr 28, 2001

I am new to MS Cluster server. Could anyone tell me the correct procedure to shutdown and restart MS SQL Server 2000 in a Clustered environment? Thanks

View 1 Replies View Related

Remote Admin

Nov 2, 2001

Are there any tools for administering SQL2000 remotely over the TCP/IP? And if this is possible what are the main hurdles on setting it up. Emulation is an option.

View 2 Replies View Related

Cluster Admin. And SQL

May 3, 2000

Anybody know if you can manage the Cluster Administrator tool from a remote workstation? I've found nothing(except PcAnywhere and the like) documented on this..

Thanks

Pete

View 2 Replies View Related

Admin Tools

Jul 5, 2000

Hi Guys

I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message:

The SQLOLE OLE object could not be registered. Class not registered (80040154)

After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled.

Still no luck.

Any ideas?


Many thanks

Stuza

View 2 Replies View Related

SQL 7 Admin Exam

Jan 4, 2000

Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.

Thanks

Ricky Kelley

View 1 Replies View Related

Domain Admin And Sa

Dec 13, 1999

A couple of newbie questions:

1) Do Domain Admins have SA rights by default in SQL7? If so, is there a way to keep domain admins out of particular databases.

2) Is it possible to create a database or table that even SA can't get into?

Thanks
JD

View 1 Replies View Related

SQL 7.0 Admin Tests

May 19, 1999

Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?

View 2 Replies View Related

A SQL 7.0 Admin Book?

Jun 5, 1999

Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.

View 2 Replies View Related

DBA Admin Plan

Jan 11, 2000

Hi there,
Could anyone please help me, I have been given the responsibility of planning and implementing the admnistration of 25 existing SQL Servers (6.5 and 7.0) countrywide and I am unsure as to where I should start. I am relatively new to SQL Server and if someone could just point me in the right direction or possibly recommend any good publications which I could refer to, I would be extremely grateful.

View 3 Replies View Related

Ms Sql Admin .....exam..help

Mar 1, 2001

Hi
Here is a mcdba admin question


Consider the following time line:
8:00 You accomplish the full database backup.
8:10 User1 enters the order 53 for customer 10, whose name in the database is
XXXXX (I
can't remember, but not Bill Smith)
8:12 User2 at remote server changes the name XXXXX to YYYYY
8:13 User3 changes the name YYYYY to ZZZZZ
8:14 User3 commit the transaction.
8:20 Media fails for database.
8:30 You restore the database from 8:00 backup. What is the status of the order
53 in the
database?
a) The order 53 is not in the database.
b) The order 53 is in the database and name is XXXXX.
c) The order 53 is in the database and name is YYYYY.
d) The order 53 is in the database and name is ZZZZZ.

Ans: B The name was already there.


The answer is B but I think th answer is A
becouse He or Her restroe the database from 8:00

I think the 53 order maked after 8:00 so
there is not order 53 in the backup database

How about you think and why !!!

Thanks kjs

View 2 Replies View Related

Database Admin

Dec 30, 1999

long, bad story here is the brief:

sql: 6.0 w/ fixes
platform: intel NT 4 sp3+

our "dba", i use that term loosly as the person who filled that position had little expertiese in managing sql, found a new job and has left; i worked with him on periphery matters so i'm less effective than he. unfortunatly ..."he with the most experience..." becomes "the man" so now i'm working to become a good dba and require some assistance.

we had a contractor come in and work out a method for archiving data using bcp, some batch files, and sql scripts; prior to this he assisted us in porting from one platform to another, digital alpha running NT to intel platform running NT.

in brief the procedure is as follows:
using options of EM create scripts to create all objects except indexes, again use EM to create sql scripts to create all objectes including indexes.

obtain sizing information and create a device and database, including log etc.

use the create objects script to create objects in the newly created database

use a custom script to create a batch file to bcp data from the primary database into flat files.

use a custom script/batch file to create a batch file to bcp data into the newly created database.

use the create indexes sql script to re-create indexes. we have to modify the sql create all objects including indexes script. i've worked up a batch file using for /f and if == to do this.

do some row counts and spot checks of tables stored procedures to verify conversion.


so now my questions:

using the information supplied causes problems, the tables end up being created but are owned by the wrong user. is there a way to change table, stored procedure, or object ownership? i create the database and objects as sa, then populate with bcp and re-create the indexes as the desired owner. my understanding is that sa has the special permissions needed to create objectes and the create objects script should make the appropriate users, logins, and changes to the db objects... where am i going wrong?

View 5 Replies View Related

Admin Task

Apr 7, 2004

Can anyone tell me whether there is any way to automatically genereate SQL script for all SQL jobs on a server?

I need to create the script for about 30 jobs and dont want to spend hours getting RSI clicking on each one and exporting the script if i can avoid it!!!!

TIA

View 3 Replies View Related

Sql Admin Training

Feb 23, 2006

has anyone tried the cd/learning from sql usa
http://www.sqlusa.com/order2005/.
Interested in any input

View 1 Replies View Related

Sql Admin Via The Internet

Mar 29, 1999

Hello,

I will soon be managing a sqlserver/iis4.0/nt box located remotely in another state. It has a permanen connection to the net. I have a dialup connection.

I have a remote control package, but it is slow. Is there a way to add that boxes sql server to my enterprise manager on my local nt server so that I can
adminsiter it from my machine? I am not over familair with sql server, but quickly learning!

Will I need to set up a vpn to do that?
I searched microsoft knowledge base, but could not find anything.
Thanks for your support.
Johanna

View 2 Replies View Related

SQL 2000 Admin

Aug 29, 2001

I am trying to find some resources for SQL 2000 admin. I have a book and will be taking a class, but am still looking for a forum and a bit of Technical expertise to discuss issues with.

Thanks

View 1 Replies View Related

Dbforums Admin??!!

Jan 9, 2006

Hi

Does any one know what the email contact is the dbforums admin? I can't seem to locate it, neither an online mailer?

Thanks

View 9 Replies View Related

HELP, No Admin Panel!!!!

Mar 12, 2007

Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.

I need to change the number of characters permitted in a certain field.

I have to present this tomorrow morning so any help would be greatly appreciated.

My friend flew to Italy last night and I cant contact him hence the question."

View 13 Replies View Related

Admin Book

Mar 14, 2007

What is the best book for SQL Server 2005 administration? For sql programming I assume the best book is professional sql server 2005 by Rob Viera.

I was not able to find a similar book for Administration. Any suggestions?

------------------------
I think, therefore I am - Rene Descartes

View 20 Replies View Related

No Admin Panel

Mar 19, 2007

Countydown writes "Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.

I need to change the number of characters permitted in a certain field.

I have to present this tomorrow morning so any help would be greatly appreciated.

My friend flew to Italy last night and I cant contact him hence the question."

View 1 Replies View Related

Can't Run SQL Agent As Non-admin.

Mar 21, 2007

I have a SQL 2005 server and I am trying to run the SQL Agent service under a minimal permission account. Currently the service will run fine and perform all functions if it's account is a member of the administrators group on the local machine. As soon as I remove it from the local administrators group it fails to start and the only message recorded in the log for the agent is:
[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
[098] SQLServerAgent terminated (normally)

And given the service works fine as an administrator I doubt there is anything wrong with the eventlog service. I have also checked and the eventlog service is indeed running, recording, and operating properly. I am at a loss as to what to do next, i've followed the directions available on MSDN for doing this but it still doesn't work.

View 3 Replies View Related

A Day In The Work Of An SQL Admin.

Nov 14, 2007

Hello. I'm 15 years old only, but really interested in math and I'm curious what do You do in work (excepting having fun and chillin' ;))? I know a bit about MySQL and I'm now trying to write some simple queries in SQL Server Management Studio Express (I'm using MS SQL Server 2005), but I'm sure in Your work You use other programs? What should I look for and start with? I know this topic sucks and many/most of You use stuff that is worth xxxxxxx USD on specialized computers/servers but I had to ask, because I was trying soo hard with programming, and then I've found database management, and I'm excited, because it's very interesting. I have no idea why, but it's not even boring to me (yet), and maybe I will work in this business in future (I really, really hope that).

Thank You for any help/support.

View 1 Replies View Related

How To Start Using Admin Name

Mar 10, 2008

Hi,

I went to services in sql server 2000 and stoped that and i right clicked my mssql server and clicked on logon button and enter the username and password.So knw i want to access my database through that admin name and password .How to do that.

Kindly reply for this mail.

Thanks & Regards,
Swar.

View 1 Replies View Related

Admin Report

Apr 17, 2008



Hi There,

I need a report from reporting services that includes which reports(name of report not id) are run by who and when(with the ability to plug in the start and end date). The 2 database names are RSExecutionLog and ReportServer. I had a look at the admin type reports that come with the package but neither are appropriate.



Thank you for your help,

Rhonda

View 4 Replies View Related

Debugging SQL CLR As Non-admin

Apr 28, 2006

Does anyone now the minimum permissions to debug SQLCLR. I have a friend trying to develop as a non-admin and he finds that it doesn't work even if he launches Visual Studio to run as an admin account.

Is it possible? Are there certain rights required?

View 1 Replies View Related

Admin Or Other Role

Mar 22, 2007

I have one other question. How do you define roles? What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?

thanks,

View 1 Replies View Related

Process Admin

Feb 8, 2007

Can I give a developer the ability to execute DTS pkgs without this server wide permission?

View 1 Replies View Related

Default Admin Account

Jul 5, 2006

I have a bit of problem I was hoping someone could point me in the right direction.  I have a SQL Server
2005 database which leverages both the Membership and Roles APIs.  When I recreate
the database for production release, I simply run an sql file using the sqlcmd
utility - no problem.  What I need is a way to add a default administrator role,
account and assign this new administrator to the administrator role.Can someone advise on how this is typically handled?

View 6 Replies View Related







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