Jobs Lose Ownership/permissions When Server Reboots
Nov 19, 2006
This is sort of a DR issue since it involves reboots and power failures.
We have MSSQL 2005 SP1 and unpatched systems, but in particular we have this problem still with the SP1 server (in addition to the unpatched systems). Running on Win 2k3.
It seems that upon reboot, our stored SSIS jobs lose their pemissions and/or ownership for execution. It doesn't happen at every reboot or power failure, but seemingly more than half the time.
Here is the error reported:
The job failed. The owner () of job Job_1 does not have server access.
But checking the properties of the job and it shows an valid owner in the Owner field. I believe we are using Active Directory for authentication and the user listed is valid in that respect.
We have "fixed" this problem before by removing the job completely and re-installing it, with the same owner. No issues until the next system outage.
Has anyone else seen this before? Is there a fix or is this some kind of bug?
View 5 Replies
ADVERTISEMENT
Feb 20, 2007
If I, as dbo, create a stored procedure to delete a record from a table (also owned by dbo) and I grant a user (user1) permissions to execute this stored procedure does the fact that an ownership chain exists between the stored procedure and the table mean that there will be no net effect if I deny delete permissions on this table to this user?
View 2 Replies
View Related
Jul 20, 2005
Hi,I am facing one serious problem. As soon as i started the sql server firsttime after installtion, my windows 2000 machine reboots. Once the windowsmachine comes up, sql server does not get started event if i manually try tostart it.My Machine configuration is as follows:1. Windows 2000(5.00.2195 SP3) with intel 2.4 Ghz processor, having 512MBramI am using SQL server 2000 evaluation version.Event log is giving following error messages:1. The description for Event ID ( 17052 ) in Source ( MSSQLSERVER ) cannotbe found. The local computer may not have the necessary registry informationor message DLL files to display messages from a remote computer. Thefollowing information is part of the event: Error: 17822, Severity: 16,State: 1Could not load Net-Library 'SSNETLIB'..2. The description for Event ID ( 17052 ) in Source ( MSSQLSERVER ) cannotbe found. The local computer may not have the necessary registry informationor message DLL files to display messages from a remote computer. Thefollowing information is part of the event: Error: 17059, Severity: 18,State: 0Operating system error 0: The operation completed successfully...Do any one know how to fix this problem ?Thanks a lot,Dinesh
View 4 Replies
View Related
Oct 31, 2007
I am working with a client that after every reboot of there SQL 2000 DB server, they experience slow response time for a couple of hours. The server has 12 GB RAM and a Dual 3.8 processor. It is believed that the slow response is due to as queries run after the reboot, they are re-building information in memory and after the memory is built up, it goes back to the normal performance utilizing the memory for speed. Is this an accurate assumption or is there something else to be looking at after the server is rebooted?
Thanks,
JB
View 3 Replies
View Related
Jul 20, 2005
Hi,I am facing one more problem. As soon as i started the sql server firsttime, my windows 2000 machine reboots and i was not able to start sql serveragain. I had to uninstall and install again and this process repeats. Doanyone has idea about what is happening ??Thanks a lot,Dinesh
View 2 Replies
View Related
May 31, 2000
What permissions/roles/etc. are necessary for a SQL login to see and start jobs.
Thanks, I'm having trouble with sp_start_job (it says job does not exists, that another user can run just fine...)
Dano
View 1 Replies
View Related
Mar 17, 1999
I have a number of jobs that will need to be run in an adhoc fashion(no set schedule).
I will be utilizing a mainframe operations staff and would like to limit their access on SQLServer
as much as possible while allowing them start jobs and view history. What would be the best way to go about this?
Thanks in advance.
View 1 Replies
View Related
Oct 1, 2002
I have a DTS package that exports data to a file, then run Win32 process pkzip to compress it to make it 4MB from 30MB so it can be emailed.
As this is to be run daily, I scheduled it, i.e. created a Job.
When running as a Job it fails in the pkzip section. The sqlservice account is not an NT system account for security reasons.
any ideas ?
TIA
Neil.
View 3 Replies
View Related
Jul 25, 2002
I have several users that are a member
of a Windows Nt group. I want to be
able to allow this group to create,
update, and delete SQL Agent Jobs.
But I do not want them to be members
of the SYSADMIN role.
Everything that I have found states
that they must be members of this
server role to perform these actions.
Does anyone have an idea on how to
accomplish this? or point me in some
kind of direction to explore.
Windows 2000 sp2
Sql 2000 sp1
Thanks,
Robert
View 2 Replies
View Related
Apr 22, 2008
I have a job with a single ActiveX step that I have setup and am having problems running.
If i set the SQL Server Agent to run as an Administrator then my job processes fine however under the default setup which has the SQL Server Agent running as Local System I get an error.
I assume this is permissions problem so I created a basic windows user called ABC. I then created a credential called ABC linked to the windows user ABC. I then created a proxy that uses the credential ABC and then ticked the box that allows the proxy to run ActiveX scripts. I then set the ABC as a principle of the proxy.
I then set my single job step to be run under the ABC credential.
Still no luck. This is the first time i've worked with this sort of thing so I'm not sure if I'm going about it in the right way.
Please explain how i can have a job that runs as an active X script. I understand running sql server agent as administrator is bad for security so what are the alternatives?
View 7 Replies
View Related
Feb 12, 2013
Permissions on SQL Server Agent.
I would like to assign the permission to user ,who can edit all SQL agent job(even own by others) without assigning the sysadmin role.
View 14 Replies
View Related
Apr 26, 2006
Hi - quick question.
I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks!
View 4 Replies
View Related
Sep 19, 2001
We do a 4:00AM weekly reboot of every SQL 7.0 server on NT4 scheduled as a SQL Agent job using the os command "shutdown servername /l /c /y /r". The problem is some of the SQL servers recognize the NT shutdown command and gracefully exit out of SQL first with the SQL log entry "SQL Server terminating because of system shutdown", then closes all databases files. Most of the other SQL server do not list any SQL log messages and sometimes list startup error messages indicating a dirty shutdown.
Does anyone else reboot their SQL servers with a scheduled job? If so, how do you perform this task cleanly?
Thanks,
D
View 1 Replies
View Related
Oct 16, 2007
Hi,
I'm just looking into installing a second instance of SQL 2005 with SP2 on a W2K3 R2 machine that already contains a default instance, if i do so is the order of installation
1) Install named instance
2) Apply SP2 to the newly installed named instance
If i do this, will either of these require a system reboot ?
The default instance should remain operational if no reboot required as the service pack is for a specific instance in this case ?
Thanks in advance
P
View 1 Replies
View Related
Oct 25, 1999
Logged in under a login id that is a db_owner on a database, I can not bind a rule owned by dbo to a table owned by dbo.
Following does not work:
EXEC sp_bindrule 'dbo.rule1', 'table1.column1'
error:You do not own a table named 'table1' that has a column named 'column1'.
Following does not work:
EXEC sp_bindrule 'dbo.rule1', 'dbo.table1.column1'
error: Rule,table and user datatype must be in current database
To bind the rule, I had to change table ownership to my login id and then bind the rule. I then changed table ownership back to dbo. This method seems odd. I do not have this problem when binding defaults to dbo owned tables.
Any one else run into this?
View 2 Replies
View Related
May 24, 2007
Dear all,
I'm using SQL Server 2005 as my backend application. I had strange experience on it, sometime some of my records suddenly disappear without any deletion action.I've check the log files and I've already set a trigger on deletion to copy the deleted record to a history table, but I found nothing. Are there anybody that have same experience like me ?
View 6 Replies
View Related
Jun 20, 2007
We are running SQL 7 with a front end that links to the tables through ODBC.In our main table, the user has no way to delete a record through theinterface, though it is possible to delete it by opening the ODBC link.Users would have no reason to delete a record, but one of our records turnedup missing.Now, it's possible that a user may have accidentally deleted the record.But, since users don't have any reason to delete records, and since theydon't access the ODBC links, it seems unlikely (though possible).I was wondering if anyone had every heard of SQL Server ever "losing" arecord that had previously been saved. I checked the nightly backup from thenight after it was added, and the record was there. So either a user deletedit, or somehow it got lost in SQL Server. I have no code that deletesrecords in this table in any way, shape or form, so it couldn't have beenmalfunctioning code.So, while I have a hard time believing that SQL Server would just "lose" arecord, I also know that anything's possible, so I thought I'd ask if anyonehad ever heard of such a thing.Thanks!Neil
View 8 Replies
View Related
May 16, 2007
Hi all,
I have some problem :
I use sql server 2000,I have about 20000 records !
I delete all data unfortunately !
So , i need to restore all .
Are there way to do this ? I don't setup automatic backup !
My data is very important !
Thank you very much.
View 3 Replies
View Related
Mar 22, 2006
Hi,
i've a store procedure has a strange behavior, As soon as created has a good performance , but after some times (indeterminated) it takes more time to be execute.... (up to 70s!!!)
The thing that i've not understood was if i take the query inside to the store i execute it separtely I get result immediately... :eek:
Dropping and re-creating procedure,it become newly fast... I've just scheduled a maintenance plan with index optimization and integrity check, but this seems doesn't work ...
Any idea?
Thanks .
View 6 Replies
View Related
Jun 13, 2006
I've got a project with 12 packages. One of them runnning and at the same time when I try to alter another one or even add a new task I see that all the tasks on toolbox are disabled.
Why?
I would like to hear a good reason for this behaviour, afaik I don't get the point...
View 3 Replies
View Related
Feb 13, 2007
I have a database that has a table with tons of data in it and it is getting close to the 999 days before it starts deleting the oldest records. Is there a way to allow the table to keep all of the information? I don't think there is, so here is my next question. Is there a way that I can move the entire table into another database to save all the information and start over with the 999 days? My main goal here is to not lose ANY information from any table from the database.
Also, I was thinking that when an entry is added into the main table, if it can also be added into the other table where I move the old data? I think a trigger can be used here, but I'm not sure how to do one in 2005. Thank you very much in advance for your help!!!
View 1 Replies
View Related
Nov 16, 2005
I created a linked report and I see that the original height and width settings which were set for landscape have changed into portrait:
View 7 Replies
View Related
Jan 24, 2008
I used the URL approach to call the reporting service. In the ASP page, I use javascript to open a new window to view the report. But when I close the new window and work on the original window. It seems that the DB connection to the SQL server is not working.
View 1 Replies
View Related
Aug 19, 2015
We run std 2008 r2. On my col heading text boxes and data text boxes i'm purposely picking only borders above and left in an attempt to get rid of what looks like a double border between text boxes.
The only places I see what appears to be a single thickness is the left of the 1st column hdg and data, and above any col hdg text box I set this way.
Also, when I pick .5 instead of 1 pt thickness, ssrs always puts it back to 1 pt.
How can I get the appearance of single thickness borders instead double?
View 5 Replies
View Related
Dec 5, 2007
We recently had a problem were a webserver lost connection to sql 2000 database after we put in a new router. When we failed back to old router it was able to connect to database again. It is using a non standard port 2125 to connect to sql database. Why would a new router cause connection problems to a database.
View 4 Replies
View Related
Jul 18, 2007
I have several reports that are set to landscape but then lose this layout when a linked report is created from the original report. I found the link below describing Brian Welcker's workaround and my question is where do you place the vb.net code he provided?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1
View 3 Replies
View Related
Jan 25, 2007
I'm having a problem with the XML Source data flow component not transferring the length attributes from an XML Schema to the column attributes of the output table.
An example schema that I have is:
<?xml version='1.0' encoding='UTF-8'?><data xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'><xsd:schema> <xsd:simpleType name='NameType'> <xsd:restriction base='xsd:string'> <xsd:minLength value='0'/> <xsd:maxLength value='50'/> </xsd:restriction> </xsd:simpleType> <xsd:element name='Name' type='NameType' nillable='true'/> <xsd:simpleType name='FamilyType'> <xsd:restriction base='xsd:string'> <xsd:minLength value='0'/> <xsd:maxLength value='50'/> </xsd:restriction> </xsd:simpleType> <xsd:element name='Family' type='FamilyType' nillable='true'/> <xsd:element name='row'> <xsd:complexType> <xsd:sequence> <xsd:element ref='Name'/> <xsd:element ref='Family'/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name='data'> <xsd:complexType> <xsd:sequence> <xsd:element ref='row' maxOccurs='unbounded'/> </xsd:sequence> </xsd:complexType> </xsd:element></xsd:schema> <!-- data follows --> <row><Name>Fred</Name><Family>Jones</Family></row></data>
When I reference file in the XML Source data control, it correctly infers that there are two columns, but the length of the strings in the columns are set as 255.
This behaviour appears to be at odds with the SSIS documentation (SQL Server Integration Services/Integration Services Object and Concepts/Data Flow Elements/Integration Services Sources/XML Source), which states (highlighting mine):
When the data is extracted from the XML data file, it is converted to an Integration Services data type. The XSD or inline schema may specify the data type for elements, but if it does not, the XML Source Editor dialog box assigns the Unicode string data type (DT_WSTR) to the column in the output that contains the element, and sets the column length to 255 characters. If the schema specifies the maximum length of an element, the length of output column is set to this value. If the maximum length is greater than the length supported by the Integration Services data type to which the element is converted, then the data is truncated to the maximum length of the data type. For example, if a string has a length of 5000, it is truncated to 4000 characters because the maximum length of the DT_WSTR data type is 4000 characters; likewise, byte data is truncated to 8000 characters, the maximum length of the DT_BYTES data type. If the schema specifies no maximum length, the default length of columns with either data type is set to 255. Data truncation in the XML source is handled the same way as truncation in other data flow components. For more information, see Handling Errors in Data.
Has anyone had any luck in getting string lengths automatically extracted from an XML document? If so, where I am going wrong?
Regards,
Michael
View 10 Replies
View Related
Aug 20, 2003
This is related to an earlier post, but I found out that I was able to see SQL Server counters in Performance monitor before applying the patch, but the counters were not present afterwards....
do I need to edit the registry ?
View 3 Replies
View Related
Oct 11, 2007
will my fetches on a cursor continue seamlessly even if deletes and multiple commits are occuring on the underlying source table? I want to make sure the cursor will not lose it's place as I believe some older dbms's did.
View 11 Replies
View Related
Jul 9, 2015
I am running into an issue while executing a sproc from Excel VBA. Everything connects fine, and I am passing a parameter, however, after a few seconds, it seems like the connection receives a "completed" command and continues down it's code, but the sproc is still executing. The result is that I never receive the record set from the sproc.Here is the code snippet from VBA:
' Create Recordset objects.
Dim cmd As New ADODB.Command
Dim conn As ADODB.Connection
Dim prm As ADODB.Parameter
Dim sConnString As String
Dim rs As ADODB.Recordset
Dim strQry As String
Dim rowCount As Long
[code]....
And here is the sproc that is being called. the first thing it performs after the "IF" block (there are multiple steps that would consecutively be called after this, but all of the data hinges on this first step working) is a TRUNCATE statement. After running a SQL profiler while executing the VBA code, I consistently see an "account log out" entry; almost as if the connection from the Excel workbook is sent a disconnect instruction. The sproc continues to run and perform the rest of the script in the "IF" block, but the returned recordset is never returned back to Excel.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON
GO
[code]....
View 4 Replies
View Related
Sep 20, 2007
Sometime ago, I had read a posting here about where in the system we can specify default owner of all objects in user database as being a DBO.
The topic came about, because somebody found out that if an object referred to in a query, does not have a fully qualified name, then it takes some time for SQL server to figure out what the owner of the object is; this causes performance problems.
e.g. select * from employees and select * from dbo.employees.
If anybody knows what that setting is...I will really appreciate it
Regards
Paresh Motiwala
Boston, USA
View 4 Replies
View Related
Apr 1, 2008
My system was crashing so I reinstalled everything. including SQL 2005 Express with management studio. I renamed the computer from the previous install. but for some reason the sql 2005 express management studio remembers the old machine name even when I create a new DB inside the management studio with the new computer name.when I try to change the ownership in properties-files it cant find the 'new computer nameuser'i double checked the computer name its correct. The funny thing is i installed express with the 'new computerame' anyone have a clue that may help with this what file needs to be edited?Thanks inadvance for any help.
View 2 Replies
View Related
Jul 5, 2001
Is there a way in SS 7.0 to change ownership of an object from a user owned object to dbo owned object other than dropping the object and re-creating it? E.G. juser.table to dbo.table
Thank you,
GaetonC
View 2 Replies
View Related
