SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
2 answers
How to fix this SQL Server error Could not obtain information about Windows NT group/user 'FANSHAWE\jdonoghue', error code 0x54b. (Framework Microsoft SqlClient Data Provider)
Ho to fix this SQL server error : Could not obtain information about Windows NT group/user 'FANSHAWE\jdonoghue', error code 0x54b. (Framework Microsoft SqlClient Data Provider)
asked Oct 18, 2024, 10:44 AM
![](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(22.400000000000002, 37%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Donoghue, James
0
Reputation points
edited a comment Apr 13, 2025, 3:07 PM
![](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, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Alex Bondarev
0
Reputation points
0 answers
Improving SP performance using Non Clustered Index.
Hi Team, I need to improve performance of a SP which is in a Database in SQL Server. 1.One of the Select query uses a Table, which is having clustered index on Column A. This table is joined with other tables on columns A,B and C(all are columns of same…
asked Apr 10, 2025, 6:15 PM
![](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(275.2, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Salil Singh
40
Reputation points
edited the question Apr 13, 2025, 6:20 AM
Salil Singh
40
Reputation points
3 answers
Error with data collector step using DCEXEC.EXE
Hi all, I'm using in some query with the Data Collector feature. In my DEV host I got 3 instances: DEFAULT (sql 2019) where there is "MDW" repo DB localhost/ALEN (sql 2019) localhost/ALEN2022 (sql 2022) There seems to be a…
asked Feb 5, 2025, 5:48 PM
Alen Cappelletti
1,042
Reputation points
commented Apr 12, 2025, 11:04 AM
![](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(240, 57.99999999999999%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Денис Александрович Лёвкин
0
Reputation points
0 answers
The server is currently in 'restarting' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long.
My Wordpress website was down due to "Error establishing a database connection" I then went forward to "restart" my Azure Database for MySQL flexible server and this process has been going forever and I don't know what to do... this…
asked Apr 11, 2025, 10:55 PM
![](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(76.8, 98%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Joana Ribau Leite
0
Reputation points
asked Apr 11, 2025, 10:55 PM
Joana Ribau Leite
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL 2022 -- cte + insert doesn't work
Good day, I have the following simple SQL statement: DELETE FROM stg.stg_facets_solo; ;WITH cte AS ( SELECT * , COUNT(*) OVER (PARTITION BY f.taxid) AS cntNpi , COUNT(*) OVER (PARTITION BY f.npi ,…
asked Apr 11, 2025, 4:46 PM
![](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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,331
Reputation points
accepted Apr 11, 2025, 9:15 PM
Naomi Nosonovsky
8,331
Reputation points
1 answer
How to install an SQL server app
I just bought an HP computer with Windows 11. I am trying to install an SQL server app.Takes forever to "configure" the services. Could anyone help, please? Thank you
asked Apr 11, 2025, 1:28 PM
![](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(294.40000000000003, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HM
0
Reputation points
answered Apr 11, 2025, 8:05 PM
![](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, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
73,886
Reputation points
3 answers
One of the answers was accepted by the question author.
A script task is not functioning as expected at runtime when I use targetserverversion2019 on SSIS 2019
On my local machine, the package runs fine with any targetserverversion, but when I load it into SQL Server Management Studio the script task doesn't work as expected at runtime environment. SQL job/package run successfully, However, the "Script…
asked Jan 7, 2021, 3:01 AM
![](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(300.8, 52%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chapagain, Dilli R
96
Reputation points
commented Apr 11, 2025, 7:02 PM
![](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(64, 28.999999999999996%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
mh
0
Reputation points
0 answers
In a SQL failover cluster, do I need to license the second node if it is running a non-SQL clustered app?
If I have a two-node Windows failover cluster and I install SQL STD to this cluster in an resource group, then I also install a 3rd party app to another resource group, do I need to license both nodes for SQL (by core) if SQL and the app are running on…
asked Apr 11, 2025, 5:55 PM
![](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, 56.00000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Lee Jarvie
0
Reputation points
asked Apr 11, 2025, 5:55 PM
Lee Jarvie
0
Reputation points
0 answers
Migrating VS2019 SSIS Pkg to SQL Server 2022 - Error Encountered
I am trying to migrate an SSIS PKG that was developed using VS2019 for SQL Server 2019 on Windows Server 2019. Now we have this new test server with the following components installed: Windows Server 2022 Datacenter SQL Server 2022 Enterprise VS…
![](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, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
1 answer
An existing connection was forcibly closed by the remote host getting error in Azure managed instance
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Framework Microsoft SqlClient Data…
asked Apr 11, 2025, 10:10 AM
![](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(137.6, 19%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Murali A
0
Reputation points
answered Apr 11, 2025, 10:50 AM
UJTyagi-MSFT
695
Reputation points Microsoft Employee
0 answers
SharePoint 2013 and SQL 2014 Native Mode Reports - Mixed Content Issue even all SSL Bidning Done
SharePoint 2013 and SQL 2014 Native Mode Reports - Mixed Content Issue even all SSL Bidning Done While debugging we observed SQL Server 2014 SSRS sends a GET request to https://xxx.abc.com/Reports, but receives a response as…
asked Apr 11, 2025, 8:11 AM
![](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, 93%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFJ%3C/text%3E%3C/svg%3E)
Faiyaj Jamadar
1
Reputation point
asked Apr 11, 2025, 8:11 AM
Faiyaj Jamadar
1
Reputation point
0 answers
Error connecting to MySQL server: 'Lost connection to MySQL server at reading initial communication packet'
Encountering the following error when attempting to connect to a MySQL server: mysql.connector.errors.OperationalError: 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 This error occurs…
asked Apr 11, 2025, 7:06 AM
![](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, 44%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
jWare Automation
0
Reputation points
asked Apr 11, 2025, 7:06 AM
jWare Automation
0
Reputation points
2 answers
Where can I find R Package MicrosoftML to use with SQL Server 2022 Machine Learning Services?
Hi, I am in the middle of the testing phase within migration from SQL Server 2019 to SQL Server 2022. I am using Machine Learning Services in SQL Server 2019 and this part has changed with SQL Server 2022. I have followed the installation guide here:…
asked Jan 27, 2023, 3:40 PM
![](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(163.2, 1%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Stefan S
10
Reputation points
answered Apr 10, 2025, 10:12 PM
Bruce (SqlWork.com)
73,886
Reputation points
0 answers
Unable to find MicrosoftML R package for ML Services on Sql Server 2022
Hello, I am trying to upgrade my database to Sql Server 2022 from Sql Server 2017. My database uses ML services, including both RevoScaleR and MicrosoftML R packages. I followed the installation steps for ML Services for Sql Server 2022 from here:…
asked Apr 10, 2025, 7:58 PM
![](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, 20%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENY%3C/text%3E%3C/svg%3E)
Nick Yaculak
0
Reputation points
asked Apr 10, 2025, 7:58 PM
Nick Yaculak
0
Reputation points
0 answers
unable see data in external created based on tab delimited file
I am able to query an external table made of tab delimited file via spark engine but unable to see any data when queried from SSMS Error faced in sql: Started executing query at Line 1 Warning: No datasets were found that match the expression…
![](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(217.60000000000002, 10%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E7%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Query Availability Group Permissions to CREATE ANY DATABASE
When configuring an availability group with automatic seeding, the secondary replicas must be given the following permission in order to automatically create/seed new databases. ALTER AVAILABILITY GROUP [????] GRANT CREATE ANY DATABASE Question:…
asked Aug 11, 2022, 3:55 PM
![](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(300.8, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Crain, Brett
31
Reputation points
edited a comment Apr 10, 2025, 4:49 PM
![](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(256, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
Dylan Janszen
0
Reputation points
3 answers
SSRS report - all hyperlinks have target of _top
I am creating a hyperlink like this: ="<a href=""https://www.google.com"" target=""_blank"">Link</a>" It works but I need to open it in the tab. When I inspect the element the target is…
asked Sep 16, 2021, 11:32 AM
![](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(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
mark goldin
696
Reputation points
answered Apr 10, 2025, 4:14 PM
![](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(297.6, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zolotoy
226
Reputation points
1 answer
Why are query executed first blocked by update executed later
There are sessions 1-4, and session 1 is update, which is used to block the environment needed for other sessions to form. Symptom 1: Sessions 2 and 4 are select and 3 are update. 1-2-3-4 is executed in sequence. Once session 1 is terminated, I expect…
asked Apr 10, 2025, 7:52 AM
![](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(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
博雄 胡
565
Reputation points
answered Apr 10, 2025, 3:28 PM
Bruce (SqlWork.com)
73,886
Reputation points
0 answers
How to clone database in SQL 2022?
My customer has SQL 2022 (16.0.1000.6) and a production database. To investigate performance of the database I need the db backup. But customer cannot provide it because of some tables contain sensitive data. I have tried to clone the db because it has…
asked Apr 9, 2025, 7:49 AM
![](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(134.4, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOC%3C/text%3E%3C/svg%3E)
Oleg Cherkasenko
0
Reputation points
commented Apr 10, 2025, 2:59 PM
Oleg Cherkasenko
0
Reputation points
2 answers
Visual Studio 2019 (SSAS) - Error when trying to open my model
The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model. I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that…
asked Aug 17, 2022, 10:03 PM
![](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(304, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Tanner Yatsko
11
Reputation points
commented Apr 10, 2025, 12:52 PM
![](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, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Melissa Asher
0
Reputation points