SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,716 questions
2 answers
Issue with excessive error messages in SQL Server Log during the reading of Server Audit session (.sqlaudit) files
Hello, I am encountering an issue with a high volume of error messages in the SQL Server Log while reading from an active Server Audit session. This problem occurs in SQL Server 2019 and later versions. I have set up database auditing using Server Audit…
asked 2024-09-23T08:23:47.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aleksandar Miljkovic (amiljkov)
0
Reputation points
commented 2024-09-24T12:48:12.3766667+00:00
Aleksandar Miljkovic (amiljkov)
0
Reputation points
3 answers
SQL server linked server, Quering remote server instance with \ in it name
Hi All, I need to query a SQL server linked server with \ in the name like Server name \instancename. when I use [linkedservername].[db].[Schemaname].tablename then receiving an error. Error : msg 117 level 15, State 1…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 94%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
Runing SSAS Tabular Processing Script (TMSL) from SSAS Database Engine
Hello Experts, In continuation of my previous question https://learn.microsoft.com/en-us/answers/questions/2076521/processing-monthly-partition-from-sql-job-using-st?source=docs We have SSAS Tabular model database and SSAS Database engine. When trying to…
asked 2024-09-24T11:15:03.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PANDEY Prashant
125
Reputation points
edited the question 2024-09-24T11:25:50.3333333+00:00
PANDEY Prashant
125
Reputation points
0 answers
Runing SSAS Tabular Processing Script (TMSL) from SSAS Database Engine
Hello Experts, In continuation of my previous question https://learn.microsoft.com/en-us/answers/questions/2076521/processing-monthly-partition-from-sql-job-using-st?source=docs We have SSAS Tabular model database and SSAS Database engine. When trying to…
asked 2024-09-24T11:15:03.1866667+00:00
PANDEY Prashant
125
Reputation points
edited the question 2024-09-24T11:25:50.3333333+00:00
PANDEY Prashant
125
Reputation points
2 answers
Errors during build of SQL Server 2022 Projects with VS2019 Professional & AzureDataStudio
Stuck with this issue for longer time. I am trying to create SQL Server Projects for a DB being in SQLServer2022 using VS2019 Professional. DB is old running/being in use since 2009. How much ever I try I face the following warnings & errors, but…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,061 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,716 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
113 questions
asked 2024-09-18T06:08:31.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Radhai Krish
191
Reputation points
commented 2024-09-24T11:20:06.18+00:00
Radhai Krish
191
Reputation points
1 answer
One of the answers was accepted by the question author.
Processing monthly Partition from SQL Job using Stored Procedure
Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant
125
Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant
125
Reputation points
1 answer
One of the answers was accepted by the question author.
Processing monthly Partition from SQL Job using Stored Procedure
Hello Expert, I have a Tabular model which is having a fact table partitioned monthly on date field. e,g. Partition_July2024, Partition_Aug_2024, Partiton_Sept2024 etc.. I want to create a single SQL job to process these monthly partitions which should…
asked 2024-09-23T06:43:51.1533333+00:00
PANDEY Prashant
125
Reputation points
commented 2024-09-24T11:17:01.93+00:00
PANDEY Prashant
125
Reputation points
1 answer
One of the answers was accepted by the question author.
Issue with Unrestricted Telnet Access to Azure SQL Database Server Despite Firewall Rules
I have provisioned an Azure SQL Database server and configured the server security settings as follows: Public access: Selected "Selected Networks" Firewall rule: Whitelisted public IP addresses to allow access to the database However, when…
asked 2024-09-20T02:36:53.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 64%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mithila Lishan
166
Reputation points
accepted 2024-09-24T10:36:04.6466667+00:00
Mithila Lishan
166
Reputation points
1 answer
Deselecting Members In An Excel PivotTable Leads To Missing Rows version 2
Dear community, I followed the steps from this guide…
asked 2024-09-23T14:04:55.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 60%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Philip Østergaard Braun
0
Reputation points
answered 2024-09-24T09:49:57.87+00:00
MikeyQiaoMSFT-0444
2,865
Reputation points
1 answer
Move OEM SQL Server Licence to a dedicated server
Hi, can I move a OEM sql server standard licence to a dedicated server (rented hardware)? Is a licence change required/possible?
asked 2024-09-24T09:24:39.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
Wellcode Software Abuelkomboz
0
Reputation points
answered 2024-09-24T09:47:50.4933333+00:00
Olaf Helper
44,326
Reputation points
4 answers
Cannot connect to SQL Database. Please contact SQL server team for further support
Hi, I'm getting below error while connecting sql server using private endpoint and AZURE IR and Active Dir authentication Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'sqlsrv-XXXX', Database:…
asked 2022-12-20T17:10:54.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 80%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
Venkateswarlu Y
6
Reputation points
commented 2024-09-24T09:29:01.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 15%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Joydip Das
0
Reputation points
asked 2024-09-23T20:19:32.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 49%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lokesh Sivaprakash
0
Reputation points
answered 2024-09-24T09:05:14.4166667+00:00
MikeyQiaoMSFT-0444
2,865
Reputation points
1 answer
How to get License information from SQLServer installer
We are using SQLServer in our on-prem product. We need to declare open source license of all the dependencies. How can FOSSA extract license from the installer programmatically without manual installation?
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,716 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
90 questions
asked 2024-09-24T08:45:24.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 87%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lavika
0
Reputation points
answered 2024-09-24T08:50:18.2666667+00:00
Olaf Helper
44,326
Reputation points
0 answers
Using AAD login on SQL contained availability groups
I've been looking into SQL 2022's new feature of logging in on SQL servers with Entra ID accounts and got it working on the SQL server nodes in a cluster. I can't figure out if/how it can be done on instances using contained availability groups. As those…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
1 answer
RMO error after upgrading SQL server from 2019 to 2022
This script works ok until SQL upgrade from SQL 2019 to SQL2022. I use it to get scripts of replication settings. Command: New-Object "Microsoft.SqlServer.Replication.ReplicationServer" $sqlserver Error: Could not load file or assembly…
asked 2024-09-10T22:09:43.6566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 39%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
Wu, Clarissa
0
Reputation points
answered 2024-09-24T08:17:08.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 60%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Hardikbhai Velani
75
Reputation points
2 answers
How to make sql server backup files immutable
How to make sql server backup files immutable without using Azure Storage?
asked 2024-09-18T16:46:04.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dave Guo
0
Reputation points
commented 2024-09-24T08:12:42.0366667+00:00
LucyChenMSFT-4874
4,510
Reputation points
1 answer
Failover for secondary read-only endpoint in SQL failover group
Usecase My team has a SQL failover group set up where we use primary region for read-write workloads. We use secondary region to serve read only workloads. I am exploring options for ensuring data availability when secondary server/region is down. …
asked 2024-09-16T19:03:20.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devanshi Patel
0
Reputation points Microsoft Employee
edited a comment 2024-09-24T08:11:32.6233333+00:00
LucyChenMSFT-4874
4,510
Reputation points
2 answers
SQL and IIS server configuration for dot net MVC web app
I have windows server 2012 and IIS 8.5 and SQL server in same network in LAN. We are facing issue about API delayed response.
asked 2024-09-07T03:21:38.1666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 68%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dayanand Sagar
0
Reputation points
commented 2024-09-24T08:09:22.4133333+00:00
LucyChenMSFT-4874
4,510
Reputation points
2 answers
How to fix this error, I can't the error in my SQL Server 2022.
How to solve this one please ? I can't install my SQL Server 2022 on my Laptop Windows 11
asked 2024-09-06T14:58:32.3066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 25%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Gile, Joseph
0
Reputation points
commented 2024-09-24T08:08:57.28+00:00
LucyChenMSFT-4874
4,510
Reputation points
1 answer
I cannot install the SQL server developer version on my new laptop
I cannot install sql server data base engine services and couple of other sql services. It always giving me error. Below is the error details Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the…
asked 2024-09-02T10:22:43.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 76%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Manswab Nechiyil
20
Reputation points
commented 2024-09-24T08:08:31.55+00:00
LucyChenMSFT-4874
4,510
Reputation points