View Jobs Authority
Jul 12, 2004Is there a way to grant other users the ability to view jobs run by the SA login short of making them admins ?
-Dave
Is there a way to grant other users the ability to view jobs run by the SA login short of making them admins ?
-Dave
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?
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 RelatedDevelopers 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
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.
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
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?
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
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
Why 'nt authority system' is not a Sysadmin on some SQL server 2014 ENT box? and it is on others?
View 2 Replies View RelatedI 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 RelatedHi
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
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
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 RelatedI 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 RelatedWrite 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]...
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!
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 RelatedI 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.
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
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 RelatedWe'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.
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 RelatedHi, 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
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!
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 RelatedHi 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
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
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 RelatedWe 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
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
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
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.