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

Unable To Run SQL Agent With A Service Account Not In Admin Group

Jul 26, 2007

Am trying to run SQL Server Agent with a service account which is not in the Administrators group. Have done the following -
1. Removed the service account from the Administrators group on the machine
2. Assigned sysadmin privileges to the service account
3. Added it to the SQLServer2005SQLAgentUser$ComputerName$MSSQLSERVER role
4. Through SQL Configuration Manager assigned this account to the SQL Server Agent service
However, this does not start the Agent as a service. What is it that is missing?

View 4 Replies View Related

SQL Server Admin 2014 :: Configure Agent Access To A Mapped Drive?

Oct 16, 2014

I'm trying to create a job that will copy a backup file from a mapped network drive to a local folder however it keeps failing due to a privilege.

The command is:
copy 10.10.10.5f$ est.nightly H:MSSQLBackup est.nightly

I can run the command successfully from the command prompt, however using the same command in a SQL Server job it fails with "Access is denied".

How do I configure the mapped network drive to allow the Sql Server Agent to get access to it?

View 1 Replies View Related

SQL Server Admin 2014 :: Cannot Open Data File When Running Agent Job

Apr 30, 2015

I recently installed standalone version of SQL 2014 Standard on my work computer. I used Access before but I want to use a SQL server instead.

We have a shared drive that a file gets deposited every day at midnight. I want to be able to get this file and import it to the server (its basically a list of names).

Here what I have done so far:

I created the database

Created the file and successfully imported data into it using the Import Data feature.

I saved the SSIS package

Scheduled an Agent Job for this package to run at certain time,daily

At first the jobs would fail with a Access is Denied. I added a user under Credentials with my network account ( have admin rights on the work computer).Also added a Proxy for the Credential user I made.

Jobs fail with a “Cannot open data file” error. I tried changing things here and there, but I can’t get it to work.

View 9 Replies View Related

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

Execute Sql Server Agent Job Task - Job Immediately Returns Success... However Agent Job Is Still Running???

Nov 30, 2006

when I run a package from a command window using dtexec, the job immediately says success.
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 3:37:41 PM
Finished: 3:37:43 PM
Elapsed: 2.719 seconds

However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.

Thanks,

Larry

View 1 Replies View Related

Snapshot Agent && Log Reader Agent Will Not Start.

Nov 30, 2006

Hi All,

I would appreciate any help here at all. I am pulling my hair out!

I am unable to start the snapshot agent or log reader agent from within SQL management studio. it fails on executing step 2 with unknown username or bad password.

I have checked all account details and they are correctly using my domain admin account. I can connect to SQL using teh same account and it also has sysadmin permissions.

If i copy the step 2 paramters and start from the cmd prompt (again logged in using the same domain account) they both start fine.

Any ideas would be gratefully received.

View 1 Replies View Related

Cannot Start Log Reader Agent And Snapshot Agent

May 18, 2007

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas???

Also this domain account is a member of

SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER

View 3 Replies View Related

SQL Server Agent Could Not Access Replication Agent

Feb 19, 2007

We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing?

View 4 Replies View Related

Sql Agent Not Starting Can We Reinstall Just Agent ?

Feb 7, 2002

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

View 6 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

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 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