Is It Possible To View Which Users Belong To Which Security Group In SSRS
Hi I am new to Sql/SSRS and I have been looking at security roles. It looks like the secrity roles are applied at group level. I was wondering if there is a way I can tell which users belong to which security group from the reporting server. If it is…
Quick Connection to SQL Server in Management Studio
Hello, I am using Management Studio to manage my databases, and I have multiple servers with several different databases. Is there a way to avoid having to enter the server name and user name every time? Perhaps by presetting all connection settings?
sql server agent alert failed
hello I have this problem with my SQL Server Agent, the service is working properly but when I make alert by some program running by SQL Server it shows that SQL Server agent is not working even if it is working, where should the problem be?
Debugging SQL Server on Linux from remote VS 2022 pc
Is it possible to debug an SQL-Server on an Ubuntu 22 machine from Visual Studio 2022? I can reach the server an can execute queries from within VS2022. But debugging fails with no useful message (error 80004005). Firewall on the server pc is inactive.…
Microsoft (R) Visual Basic Compiler asking the upgrade the version.
We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…
How to transfer SQL Agent Jobs using SSIS with Job owner
Hi Team, Want to transfer SQL Agent Jobs using SSIS with Job owner one server to another server. Thanks in advance
"Sync to other databases" is missing
Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.
Why isn't code working as an expression for parameters in SQL Server Reporting with connection to Databricks SQL Warehouse using Simba Spark
Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)…
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
SSRS Report Subscription Windows Share File Option Failed
We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Availability Groups in depth
Hi, I want in depth information on Availability Groups. Any link that I can read?
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
Getting Access error while trying to enable TCP/IP in Sql server configuration manager
Hi All, I wanted to enable TCP/IP protocols in SQL server configuration manager in my local but getting access denied error Can any one please let me know how to resolve this issue and enable the protocols
I cannot install sql server on my windows 11. Keep getting an oops, exit decimal error code
I am unable to install sql server on my windows computer
Transfer roles and permissions
Hi, By using sp_help_revlogin, we can transfer the logins and passwords to the secondary replica. How to transfer roles and permissions?
Windows 11 Microsoft SQL 2022 Express Edition
Hey, currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers. We want to add new software database into MS SQL 2022 Express Edition but software creator said we need…
How to solve secondary availability group is an unhealthy status in SQL server distributed availability group?
Hello, I would like to help one thing that is my SQL server issue. When I create distributed availability group, secondary available group is show an unhealthy status in SQL server Clustering. Please see the below photo. I already alter in secondary AG…
Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block
Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…
The MSSQLSERVER and AGENT service terminated unexpectedly
Dear All SQL expert, Do you know what is the case that make The MSSQLSERVER service terminated unexpectedly? Recently, The SQL server (MSSQLSERVER) and SQL Server Agent are stopped automatically during running import data to sql server through scheduled…