Viewing 15 posts - 1 through 15 (of 373 total)
Hi,
we got the same result with sp_who2, but our sa account is disabled.
I think, if you put the account to disabled, nobody is able to use this account for login.
The...
April 12, 2024 at 6:39 am
Hi,
is your workstation and your SSRS in the same domain?
What is your security configuration?
Maybe you are not in the loca admin group?
Kind regards,
Andreas
April 11, 2024 at 11:24 am
Hi,
in the sql server properties you can configure the memory for the sql server.
Sample:
If your server got 24 GB RAM, let 4 GB RAM for the OS. You should configure...
January 24, 2024 at 1:31 pm
Hi,
maybe we got the same error some year ago.
Can you run this query:
SELECT * FROM sys.dm_os_nodes
In our case, some nodes got the status " THREAD_RESOURCES_LOW".
The OS was...
January 24, 2024 at 12:25 pm
Hm,
are you able to delete the old backup files if you run the script from the job manually?
If the job runs via sql server agent, it uses the sql server...
December 8, 2023 at 12:24 pm
Hi,
it would be easier, if you can tell us the versions of the sql server, of the client workstation and so on.
Best regards,
Andreas
November 23, 2023 at 12:50 pm
Hello,
maybe you are able to check the query from SPID 0
DECLARE @sqltext VARBINARY(128)
SELECT @sqltext = sql_handle
FROM sys.sysprocesses
WHERE spid = 0
SELECT TEXT
FROM sys.dm_exec_sql_text(@sqltext)
Good luck,
Best regards,
Andreas
November 22, 2023 at 1:00 pm
Hello Jeff,
we take a look at the statistics at 10 a clock in the morning.
Only a view statistics were not up to date. And they were changed by the sql...
November 21, 2023 at 8:41 am
Hi,
we added some RAM, and the windows server got 96GB. We reserved 10GB for the OS.
The error was not reported since the upgrade.
Best regards,
Andreas
November 16, 2023 at 10:38 am
Hi,
please check, if the statistics and index are on the same "level", maybe rebuild them before your test.
And, check the mdop and the threshold for parallelism, and everything else which...
November 16, 2023 at 10:36 am
Hm,
your "sysadmin" was not able to find these accounts. And he was not able to create them?
Strange, I hope he knows what he is doing.
November 13, 2023 at 12:34 pm
Hi,
is your account able to see every other account? I think, only a sysadmin can see every account.
And, these 2 accounts should exist on every sql server. Please check the...
November 13, 2023 at 11:54 am
Hello Steve,
thanks for this link. I will try my best, but we are not able to change the query, and we don't know when the error occurs.
Maybe the OS got...
November 13, 2023 at 6:28 am
Hi,
did you check, if the file exists on the drive?
How about the permission on these folders, is the service account able to delete files in the folder?
Kind Regards,
Andreas
November 6, 2023 at 7:20 am
Hi,
it is not helpful, if you start the same twice.
Please be so kind, and close on of your topics!
Have you tried to open the url on the report server, or...
October 2, 2023 at 6:25 am
Viewing 15 posts - 1 through 15 (of 373 total)