Viewing 15 posts - 1 through 15 (of 19 total)
The job step runs with a proxy. The account used in the proxy/credential is a domain account with privileges on the folder, but NO privileges on the server on which...
December 6, 2016 at 12:28 am
I thought I found the cause of the issue but NO. But I still was astonished.
When you create a SSIS package, you create connection managers.
These connection managers and the values...
November 28, 2016 at 4:26 am
No, the account is simple service-account without logon privileges.
The account has no windows privileges on server A.
November 1, 2016 at 6:27 am
It must have something to do with authentication/privileges on the Server A on which the SSIS package is hosted and executed by a SQL job.
Because when I elevate the account...
November 1, 2016 at 1:18 am
Yes, the account does have access to the folder and the files in it.
October 31, 2016 at 10:37 am
oke, it can be that simple!
Thanks.
For further reference, I know use
exec sp_replicationdboption @dbname = <database name>, @optname = 'publish', @value = 'false';
November 26, 2015 at 2:43 am
dir /a:hr returns no files.
So no hidden and read only files.
November 2, 2011 at 6:32 am
The NTFS permissions are also correct. Full control for the service account.
This does not surprise me, because other databases, which are in the same folder and got the same security...
October 28, 2011 at 1:31 am
Sorry, I wasn't clear about that.
The database files are on the SQL server itself.
The SQL service account is a Active Directory account that got access to the database file location...
October 27, 2011 at 5:27 am
Jobs are executed with TSQL.
The (Exclusive Lock) is not the real problem. DBCC wants a lock on the database because it can't make the snapshot. So, the real question is:...
October 27, 2011 at 4:12 am
Ran the DBCC UPDATEUSAGE but that did not make any difference.
Mmmmm... I just realized that I posted this in the SQL 2005 section, but the server on which this occurs,...
October 27, 2011 at 2:48 am
That's not what I asked about. Does the SQL Server service account have full control (in Windows) to the files and folders involved? (all of them)
The Service account has got...
October 27, 2011 at 1:27 am
Some of the databases that fail the checked came from an other server, but the msdb also fails and that one comes with the installation of course.
The checked did run...
October 26, 2011 at 12:53 pm
GilaMonster (10/26/2011)
If you're on Enterprise Edition, see if you can create a manual database snapshot on the same drive as the data file....
October 26, 2011 at 8:19 am
[/quote]
Why do you choose to not run the full checkdb?[/quote]
I really don't know why. I inherited these servers and I never gave it a second thought.
(lame excuse, I know)
But, like...
October 26, 2011 at 8:00 am
Viewing 15 posts - 1 through 15 (of 19 total)