View Jobs Authority

Jul 12, 2004

Is there a way to grant other users the ability to view jobs run by the SA login short of making them admins ?

-Dave

View 1 Replies


ADVERTISEMENT

Maintain Jobs, View Logs

Mar 13, 2006

I have a user who needs to check whether 2 jobs have run on a SQL Server 2000 instance, and be able to view logs.

Is there a way of doing this, and not allowing them access to anything else?

View 2 Replies View Related

SQL 2012 :: Ability To View Server Level Logins And Agent Jobs?

Sep 16, 2014

In one of my environments, I need to grant the ability to view all the logins and agent jobs to an account, but I don't want to give him "sysadmin" or "securityadmin".

View 2 Replies View Related

Unable To View Jobs Even After Adding Users To MSDB Roles SQLAgent...

May 20, 2008

Developers need to view and modify jobs on some servers without being sysadmin. We've added the developers to the following MSDB roles:

SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole

Technically they should be able to view and modify jobs through Management Studio when being added only to SQLAgentOperatorRole. However they receive the following error when clicking on the Jobs folder regardless of the msdb role.

Execute Permission Denied on Object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

Our original two SQL 2005 servers do not produce this message, but all other instances do. All servers, but one, are SP2 so the service pack is not an issue. Any thoughts?

Thanks, Dave

View 3 Replies View Related

How To Set NT Authority In Sql 2000?

Sep 18, 2007

We have an application store in a web server using IIS 6.0, however the application is communicating to sql 2000 that is stored in a 2000 server. In IIS 6.0 the application pool is set to Network Services, therefore sql 2000 is looking for a user called 'NT AUTHORITYANONYMOUS LOGON'.
But the login failed, and I don't see how to add NT Authority as a user in a 2000 server like you can in a 2003 server.
In all, we are trying to set permissions to certain users only by using the identity impersonate='true' in the web config file, but even with this setting set to true, and our network information set as a user in sql 2000, we still are denied access to the data.
What are some things we need to look for and what configuration do we need to set?
Thanks,xyz789 
 P.S.We also have all the permissions check to have access to all the tables and store procedures for each user.

 

View 2 Replies View Related

NT Authority Login Failed

Jan 18, 2008

I have googled this to my hearts (dis) content, and all the answers I have found either rely on 1) creating untrusted connections, or 2) hard coding your password into the page. Neither of which I am satisfied with. Here is my scenario:I am using Visual Web Developer 2008 Express Edition to construct an intranet site on my companies corporate network. I am using a development PC which sits not far from the main server I will be utilising for the hosting of the intranet site. I have local admin privileges to this server (as well as the box I am developing on). I do not have privileges to the domain controller (but that doesn't seem important to me anyway).I have created a database in SQL Enterprise Server on the intranet server and am using that database thru my development box. ie, the (test) data is already on the server and I have VWD2008EE access the data directly. Now this works as expected and without problem. I can create data sources and controls and they work on my development box. I can create data access code that also accesses the database, and it works correctly, ie, I see the data. However, when I import the code/pages to the production server, I get this error message: Login failed for user 'NT AUTHORITY/NETWORK SERVICE'."What puzzles me is that the VWD development server can access the database without a problem, yet if the pages run from the server itself, the database is no longer accessible. And it is the same database we are talking about. Disabling any form of security is not an option.Also, Windows authentication (ie using the domain controller) is the ONLY for of authentication available to me.I am guessing I have to add a particular type of user to the production server, but where and how is a little beyond the scope of my knowledge. There is no "Network Service" user (should there be?)Any help would be GREATLY appreciatedFurther info if required:Development PC - Windows XP Pro SP2 on a corporate network, logging in through a domain controllerProduction PC - Windows Server 2003 Enterprise SP2 using IIS V6.0 and SQL Enterprise Manager 8.05.02 (ODBC V: 3.52.0000)This is the code I use to access the SQL server(remember, this works from the development PC to the production SQL server, just not form production PC to production server): Imports System.Data.SqlClientProtected Sub Page_PreRender(byval sender as object, byval e as system.eventargs) Handles me.prerender Dim dbcon as new SqlConnection("Data Source=F001;Initial Catalog=Whiteboard;Integrated Security=true;") Dim myCommand as new SqlCommand myCommand.Connection = dbcon myCommand.CommandText = "SELECT * FROM tbl_rooms ORDER BY [d_date], [r_id], [t_from]"
Dim myReader as SqlDataReader dbcon.Open() ' <-- this is where the error comes in ONLY on production PC '... code which reads the table and prints it (this works)

dbcon.Close
End Sub
   

View 3 Replies View Related

Login Failed NT Authority

Aug 22, 2006

I'm having an issue with .NET and SQL Express. I have a windows service application that retrieves data from a SQL Express database. The service Log On properties are set to log on as NT AUTHORITYNetworkService. The service works as expected in my test and development environment. I have tested this on XP SP2 and WIN2K SP4.

I installed this on a production machine, running XP SP2, and I get the following error:

Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>]

If I set the Log On properties for the service to "Local System Account", it works as expected.

I checked for any differences between my develpment installation of SQL Express, and the production installation, but could not find any descrepancies.

Does anyone have some suggestions?

View 5 Replies View Related

The Local Security Authority Cannot Be Contacted

Mar 19, 2007

We have a weird issue with one of our computers.

We have a SQL 2005 server that is running our website and is accessed by our staff to run some applications (VB and Access 2003). The SQL 2005 server is at an off-site datacenter, so all access is via VPN.

We have one individual who is recieves the The Local Security Authority Cannot Be Contacted error whenever we try to create an ODBC connection to the SQL server. If the user is in our office, his computer connects fine, when he connects via an IPSEC VPN (we have tried various connections DSL, Cable and EVDO as well as Starbucks) he gets the same error. The error is sporadic, though recently it appears 80-90 percent of the time.

More info

When he is connected to the VPN, he can ping the SQL and exchange servers, as well as any of our other servers.
The issue started when he got a new computer. The computer is less than a year old, was mine previously. Hard drive was wiped and reloaded with XP Pro, 2.6 GHz, 2 GB RAM, 100GB hard drive with 70% free space.
When he connects to the VPN, he loses access to the exchange server, when he is not connected to the VPN, he accesses exchange via Outlook 2003 via RPC over HTTPS without an issue. When he disconects from the VPN, his connection to exchange is returned.

Any help or pointing in the right direction would be greatly appreciated.

Thanks

Wayne





View 4 Replies View Related

Login Failed For User 'NT AUTHORITY/SYSTEM'.

Jun 9, 2008

Hi,
I can view the site fine on VS developlement sever, but not through IIS 7. Whenever i try to run it, i get this error: Login failed for user 'NT AUTHORITY/SYSTEM'. The problem is that i am not using this user to access my database, so i don't know where it came from. I mapped this new user to my database and changed my web.config file accordingly to see if it works, but it did not.
i have looked high and low for this, but i don't seem to find a solution that solved my problem. I am running Vista, IIS 7 and have forms security on my website.
Any suggestions will be very much appreciated.
E

View 5 Replies View Related

SQL Security :: Why (nt Authority System) Is Not A Sysadmin On Some 2014 ENT Box

Jun 22, 2015

Why 'nt authority system'  is not a Sysadmin on some SQL server 2014 ENT box? and it is on others?

View 2 Replies View Related

Access Data In Remote SQL Server With Trusted Authority

Jul 23, 2005

I have two win2003 servers. One is IIS and the another is SQL server. Ican use MyConnection=newSqlConnection("server=SQLServerName;database=myDBName;UID=sa;PWD= mypwd")to access my data. But I can not use MyConnection=newSqlConnection("server=SQLServerName;database=myDBName;IntegratedSecurity=SSPI") to access it. If I put both IIS and SQL Server in onemachine, I can do anything. How can I do something to allow trustedauthority work ?Thanks

View 1 Replies View Related

Install SQL Server 2005 Express - The Certificate Chain Was Issued By An Authority That Is Not Trusted

Sep 6, 2006

Hi
I am trying to install SQL Server 2005 Express on my machine, which has Windows Server 2003 with Service Pack 1. I could not able to install properly and i am getting error always.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.

Please help
Thanks
Here is the Error message from Summary.txt

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Tue Sep 05 12:31:18 2006

--------------------------------------------------------------------------------
Machine : SERVIDORCC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_SERVIDORCC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 05 17:12:41 2006

View 1 Replies View Related

[JavaScript Error] Cannot Delete User Or User's Authority In Specific Report After Install SQL SP2

Jan 23, 2007

 Hi,

I have several reports for users to view on our Intranet. After installation of SQL 2005 SP2 patch, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates / hotfix. Thanks a lot!

Regards,

Kenneth Lai
Programmer


Error Pic


Message Box

 

View 1 Replies View Related

SQL 2012 :: Database Mirroring And NT Authority Account For Database Engine?

Dec 2, 2014

I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domainuser. I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authorityuser a local account. I am trying to practice installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority user account. should I change the service account to a domainuser?

View 2 Replies View Related

Creating Index On A View To Prevent Multiple Not Null Values - Indexed View?

Jul 23, 2005

I am looking to create a constraint on a table that allows multiplenulls but all non-nulls must be unique.I found the following scripthttp://www.windowsitpro.com/Files/0.../Listing_01.txtthat works fine, but the following lineCREATE UNIQUE CLUSTERED INDEX idx1 ON v_multinulls(a)appears to use indexed views. I have run this on a version of SQLStandard edition and this line works fine. I was of the understandingthat you could only create indexed views on SQL Enterprise Edition?

View 3 Replies View Related

Write A CREATE VIEW Statement That Defines A View Named Invoice Basic That Returns Three Columns

Jul 24, 2012

Write a CREATE VIEW statement that defines a view named Invoice Basic that returns three columns: VendorName, InvoiceNumber, and InvoiceTotal. Then, write a SELECT statement that returns all of the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.

This is what I have so far,

CREATE VIEW InvoiceBasic AS
SELECT VendorName, InvoiceNumber, InvoiceTotal
From Vendors JOIN Invoices
ON Vendors.VendorID = Invoices.VendorID

[code]...

View 2 Replies View Related

Calling A Stored Procedure From A View OR Creating A #tempTable In A View

Aug 24, 2007

Hi guys 'n gals,

I created a query, which makes use of a temp table, and I need the results to be displayed in a View. Unfortunately, Views do not support temp tables, as far as I know, so I put my code in a stored procedure, with the hope I could call it from a View....

I tried:

CREATE VIEW [qryMyView]
AS
EXEC pr_MyProc


and unfortunately, it does not let this run.

Anybody able to help me out please?

Cheers!

View 3 Replies View Related

Different Query Plans For View And View Definition Statement

Mar 9, 2006

I compared view query plan with query plan if I run the same statementfrom view definition and get different results. View plan is moreexpensive and runs longer. View contains 4 inner joins, statisticsupdated for all tables. Any ideas?

View 10 Replies View Related

Alter View / Create View

Aug 14, 2000

I had given one of our developers create view permissions, but he wants to also modify views that are not owned by him, they are owned by dbo.

I ran a profiler trace and determined that when he tries to modify a view using query designer in SQLem or right clicks in SQLem on the view and goes to properties, it is performing a ALTER VIEW. It does the same for dbo in a trace (an ALTER View). He gets a call failed and a permission error that he doesn't have create view permissions, object is owned by dbo, using both methods.

If it is doing an alter view how can I set permissions for that and why does it give a create view error when its really doing an alter view? Very confusing.

View 1 Replies View Related

Updating My View Changes My View Content

Feb 17, 2006

I have this view in SQL server:

CREATE VIEW dbo.vwFeat
AS
SELECT dbo.Lk_Feat.Descr, dbo.Lk_Feat.Price, dbo.Lk_Feat.Code, dbo.SubFeat.SubNmbr
FROM dbo.Lk_Feat INNER JOIN
dbo.SubFeat ON dbo.Lk_Feat.Idf = dbo.SubFeat.Idt


When ever I open using SQL Entreprise manager to edit it by adding or removing a field i inserts Expr1,2.. and I don t want that. The result I get is:

SELECT dbo.Lk_Feat.Descr AS Expr1, dbo.Lk_Feat.Price AS Expr2, dbo.Lk_Feat.Code AS Expr3, dbo.SubFeat.SubNmbr AS Expr4
FROM dbo.Lk_Feat INNER JOIN
dbo.SubFeat ON dbo.Lk_Feat.Idf = dbo.SubFeat.Idt

I don t want Entreprise manager to generate the Expr fields since I use the real fields in my application.
Thanks for help

View 4 Replies View Related

Sql Jobs

Aug 2, 2005

Hi,It may sound funny but it is true. I have 2 version of same procedure, 1 is named as "update_aggre" other named as "update_aggre_2" .if I run these procedures using sql jobs the 1st procedure takes 12 seconds and the 2nd takes 2 second. I am stil surprise why is that both of them have same code.Any ideas please?and also I need to have lock mechanism within a procedure so that if some one is calling a procedure which is already called by some one ans is stil working on it the second user shld not be able to overwrite the existing data untill the first one is finished.TIAAmit

View 3 Replies View Related

Can&#39;t Run Jobs In SQL 7!

Mar 20, 2000

We're upgrading to Sql 7 from 6.5 but having problems running jobs with the following sql statement :

SQLMAINT.EXE -D master -BkUpDB e:dump -BkUpMedia DISK -DelBkUps 2 -Rpt d:salogmaster_dump.log


The error message is [Microsoft SQL-DMO (ODBC SQLState :28000}] Error 18456:[Microsoft]ODBC SQL Server Driver][SQL Server]Login failed for
user 'Domainuser'. Process Exit Code 1. The step failed.

The user is a domain account and already in local administrator group. It also starts up both Sql server & Sql server agent. It can run the same job on another server. I have compared the set up and can't find any differences.

Thanks in advance for your help.

View 2 Replies View Related

SQL Jobs

Nov 17, 2000

If i've created myself a job on my SQL Server and then scripted it, how do i run this script and so doing create my job on another server?

View 2 Replies View Related

Jobs Won&#39;t Run

Jan 18, 2001

Hi, I have a DTS package that runs correctly when executed manually, but when I schedule a job via the package, the job begins executing and nevers seems to complete the run. The Package runs in less that 1 minute, but the job sticks on executing and does not complete. I have to cancel, any ideas?

Thanks

View 1 Replies View Related

Jobs

Sep 6, 2000

I have 12 scheduled daily jobs, all the jobs are depending on one job.I want to run rest all the jobs if and only if the Job#1 gets success.Now all are running independently.Is there a way to force the sequence by using SQL.
Thanks!

View 4 Replies View Related

Jobs

Aug 30, 2000

If we have several jobs running several times daily,do we have to do any clean-up with the logs/job history so that they don't run into any problem later?Will it be o.k if we do not clear off the history frequently?

View 2 Replies View Related

Jobs In 7.0 Vs. 6.5

Feb 16, 2001

Hi all,
My firm has about 15 SQL Servers. 5 of them are still 6.5 and the other 10
are 7.0. I have noticed that the jobs I have setup to perform maintenance
tasks, backups etc. almost never fail in 7.0. Similar tasks routinely
fail on the 6.5 servers.

So I did a test. I deleted a database in 7.0 and ran a backup job. Although
the log for the job said that it couldn't find the db it still said the job
was successful. In 6.5 if you try to run a job on a non-existent db it
fails. What's going on in 7.0? What has to happen for a SQL Server agent job
to fail. This seems like an awfully dangerous new "feature".

If anyone could shed light on this I would appreciate it.

Thanks
JJ

View 2 Replies View Related

DTS Jobs

Mar 5, 2001

Hi,

How do we add DTS pakages to a scheduled job ?
Ex: Lets say i have 2 DTS pakages One has got to run immediately after the other.
>Now i create a schedule for the main DTS pakage.

>Once i create a schedule, It goes into Jobs as a Scheduled job.

>Now in the propertied part of the first DTS job i need to add a second DTS
as Step2, mentioning that it should run after the First DTS.

How do we do this ?

Thanks in Advance,
Siv

View 1 Replies View Related

SQL 7 Jobs

Jul 23, 2001

Does anyone know how I can set up some form of alert that tells me which scheduled jobs are still running?

View 1 Replies View Related

Jobs Sit Up Doing Nothing

Sep 21, 2001

We had some jobs in Sql server 7.0 which ran together at the same time.
Now we have moved to sql 2000 and when we run those jobs together again they just sit up(keep on going without doing anything) and do nothing.I have monitored that there is no Blocking or any kind of Performance Overload.

These jobs run fine when they are executed Individually in Sql 2000

Any kind of help will be appreciated.

Thanks,
James

View 5 Replies View Related

What Are Jobs?

Sep 29, 2004

hey guys!! can someone tell me, what are jobs on MS SQL?
and what is a job scheduler? how do it function? what are the processes
involved? and additional information about this stuffs.. thanks..really need it.. tnx tnx..

p.s.
if your wondering
why i asked the questions
here..because it's really
hard to search the meaning
of it in the net..i hope you
guys could help me.. tnx

View 2 Replies View Related

Right To Run Jobs

Oct 5, 2004

Thanks for the help with moving jobs from one server to another.

Now that I have moved them, they now fail each and all. I have copied the script and saved them as vbs files and placed them in a folder on the server and ran them successfully. I think it has something to do with the rights, but I don't know what. Could someone shed some light on possible causes?

Thanks,
Lee

View 6 Replies View Related

MS SQL Jobs

Dec 6, 2004

Hi SQL Guru's

I am trying to run a job on Multiple SQL Servers in a domain.I am setting the job on my system,but the Radio button "Target Multiple Servers" is disabled.How do I enable the radio button "Target Multiple Servers".
Please let me know if this is possible.

Best Regards

SK.

View 1 Replies View Related







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