21,638 questions

Sort by: Updated
3 answers

Baseline SQL performance on server with stacked instances

My question is what approach to take to baseline performance with multiple SQL Server instances on a server. We are building a Always On availability group cluster (SQL 2022) for a consolidation project. The cluster is as yet unused. We plan to stack…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2026-11-12T20:17:44.18+00:00
answered 2026-11-18T16:47:22.3+00:00
Deepesh Dhake 1,325 Reputation points
1 answer

After installing SQL Server 2022 CUx, Master Data Services no longer allows creation of new entities or attributes.

Expected behavior: Entity and attribute creation succeeds. Actual behavior: Creation fails with error. I can't see the exact error. Only a exclamation mark is visible Current version: SQL Server 2022 CU28 Environment: SQL Server 2022 Master Data…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2026-11-18T15:12:41.91+00:00
Ralph Koumans 0 Reputation points
commented 2026-11-18T15:37:38.7733333+00:00
Ralph Koumans 0 Reputation points
1 answer

sql query to assign system admin and system user role to all users In d365 finance in ssms

Hi Team, I need to write a sql query in Ssms to assign system admin and system user security role to all the users. Please help

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,702 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2023-01-05T07:33:42.193+00:00
Karun D 1 Reputation point
commented 2026-11-18T11:21:44.7766667+00:00
Monte Page 0 Reputation points
4 answers

Login failed for User

I get "Login failed for User" error in visual basic connection to sql-server. This error occurs when I move my database from one PC to another. I solve this problem by using same "PC-name" & "User-Name" of my old PC…

Developer technologies | VB
Developer technologies | VB

An object-oriented programming language developed by Microsoft that can be used in .NET.

2,914 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-06-27T17:45:45.307+00:00
Habib ur Rehman 21 Reputation points
edited an answer 2026-11-17T14:09:08.7566667+00:00
Erland Sommarskog 137.7K Reputation points MVP Volunteer Moderator
2 answers

Clarification Required – SQL Server Enterprise Licensing for Physical Migration, Always On HA and Read-Only Routing

Dear Microsoft Licensing Team, We are planning to migrate our existing SQL Server production environment from a virtual machine to new physical servers and implement SQL Server Always On Availability Groups. We currently have SQL Server 2019 Enterprise…

SQL Server Database Engine
asked 2026-11-16T07:11:22.2733333+00:00
Abdur Rahman M 20 Reputation points
commented 2026-11-17T07:44:37.82+00:00
Shankar Wagh 0 Reputation points
1 answer

FEDAUTH login feature

Hi, in section 2.2.6.4 of [MS-TDS] specification for FEDAUTH Options is always defined as bFedAuthLibrary, fFedAuthEcho however the correct order is fFedAuthEcho, bFedAuthLibrary as fFedAuthEcho is the lower bit, not the higher (so for instance 5…

SQL Server | SQL Server Open Specifications
asked 2023-11-10T07:33:22+00:00
Frediano Ziglio 121 Reputation points
answered 2026-11-17T06:17:17.34+00:00
1 answer

PBIRS Scheduled Refresh displays incorrect timestamp – one-hour discrepancy in LastRunTimeDescription

Product:Power BI Report Server (On-premises) Issue type: Technical / Break-fix Description: Following our recent server timezone configuration changes to use British Columbia local time, we noticed an inconsistency in the Scheduled Refresh timestamp…

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

3,178 questions
asked 2026-11-04T03:54:58.9+00:00
Karduri, Naveen 0 Reputation points
commented 2026-11-16T21:41:32.6866667+00:00
Karduri, Naveen 0 Reputation points
2 answers

Create a linked server in SQL 2025 connecting to a SQL 2017 Instance

Hi- I currently have a linked server on a SQL 2019 Sql Server Instance connecting to a SQL 2017 instance using provider SQLCLNI11 which has been deprecated. I need to migrate the Linked Server to a SQL 2025 Instance connecting to the same SQL 2017…

SQL Server Database Engine
asked 2026-11-13T19:02:31.75+00:00
Thomas E Rozzi 0 Reputation points
commented 2026-11-13T21:10:01.38+00:00
Erland Sommarskog 137.7K Reputation points MVP Volunteer Moderator
4 answers

Differences between ALTER ANY LOGIN & securityadmin Server level role?

Hello, what are the differences between ALTER ANY LOGIN & securityadmin Server level role? Think I have an idea that securityadmin Server level role probably has higher permissions but would like to know more specifics. Thanks in advance.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-07-04T19:51:01.053+00:00
techresearch7777777 1,961 Reputation points
edited an answer 2026-11-13T05:07:26.15+00:00
techresearch7777777 1,961 Reputation points
2 answers

I need help making an ado connection string from ms access to sqlexpress 15.

I've been trying to figure out a connection string for a couple days now. I'm new to ado. I've been using odbc for years, but I want to update the old colde. Please also let me know if I need quotation marks and apostrophes and does there need to be…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-05-28T14:49:46.333+00:00
Sam Coburn 1 Reputation point
edited an answer 2026-11-13T05:05:03.69+00:00
Sam Coburn 1 Reputation point
3 answers

Login failure

I have posted many questions regarding this and don't seem to get it right. However, there is a twist to this. I think I succeeded in granting permission to the user 'quirverT', because when I tried to create a new account on my website, the error…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-05-13T09:48:11.46+00:00
Donald Symmons 2,996 Reputation points
edited an answer 2026-11-13T05:02:39.03+00:00
Donald Symmons 2,996 Reputation points
2 answers

Can't deploy SSIS package - An error occurred during decryption. (Microsoft SQL Server, Error: 15466)

When trying to deploy an SSIS .dtsx package, I get the below error message: --------------------------------------------------------------------------------------------------- TITLE: SQL Server Integration Services …

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,786 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-04-10T00:09:47.347+00:00
Santiago S 1 Reputation point
edited an answer 2026-11-13T04:57:59.71+00:00
Santiago S 1 Reputation point
2 answers

How do I create a view using existing tables from another database just like using dblinks?

Hi experts, Would like to kindly ask for help with creating a view using a query that selects from tables from another database in the same server. Thanks!

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,702 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-03-25T06:54:08.513+00:00
SomebodyHelpMePlease 6 Reputation points
edited an answer 2026-11-13T04:54:27.07+00:00
SomebodyHelpMePlease 6 Reputation points
0 answers

MySQL to C# Connection Error

Developer technologies | Windows Forms
Azure Database for MySQL
Azure Database for MySQL

An Azure managed MySQL database service for app development and deployment.

1,249 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-03-19T04:18:03.63+00:00
Mohamed Rafi N 26 Reputation points
2 answers

sqllogin user log in

i need a help, i need to have sql server account where this sql user should not user ssms . ssms should be blocked how to do it

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2022-03-07T11:13:21.19+00:00
k muthus 21 Reputation points
edited an answer 2026-11-13T04:50:18.7733333+00:00
k muthus 21 Reputation points
0 answers

Lost Database encryption (TDE) password, How to recover?

Hi , Our DBA lost the password of the certificate with which our database was encrypted. We've to migrate the database to latest. How can I recover? If I create a new on can I apply new cert to the DB? Can I disable the TDE, then backup and…

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

603 questions
asked 2022-02-03T09:21:22.123+00:00
Raveendar Oddi 6 Reputation points
1 answer

Lost acces to sqlexpress

I have a problem with permmisions. IN company we must changed our computer name and settings after migration to active directory. But I forget that my old PC name is admin in sql express. And I do not know sa password becouse in time of instalation I…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2021-12-14T08:31:08.563+00:00
d.o.m.i.n.i.k 1 Reputation point
edited an answer 2026-11-13T04:40:52.27+00:00
d.o.m.i.n.i.k 1 Reputation point
1 answer

Seeking help on storing keys in Azure Key vault for on premise database?

Hello, We want to implement Transparent Data Encryption (TDE) for some of our on premise databases and we want to store the keys/certificates in Azure Key Vault.. Given the below constraints, Is it really possible ? ON premise and Azure…

Azure Key Vault
Azure Key Vault

An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.

1,524 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2021-11-30T11:05:03.267+00:00
anil kumar 1,626 Reputation points
edited an answer 2026-11-13T04:39:11.8466667+00:00
anil kumar 1,626 Reputation points
4 answers

Looking for script to for login creations and assigning permissions.

Hi Experts, Does anybody has a script or stored procedure which takes care of login creation, user creation and adding roles and permissions. Basically, looking for script which does the following : We will pass loginame, login type, db name,…

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,702 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2021-10-07T06:46:25.64+00:00
Sam 1,456 Reputation points
edited an answer 2026-11-13T04:36:51.2966667+00:00
Sam 1,456 Reputation points
1 answer

Help for Linked server code

Hi, I am unable to run the following query from server:cd_pdserv02.DBTBB_BACK and getting the linked server error. How I can grant the access of linked server to run the query. OR is there anyway to run the query successfully. Thanks for your help …

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

4,702 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,661 questions
asked 2021-05-26T03:10:30.69+00:00
Kenny Gua 411 Reputation points
edited an answer 2026-11-13T04:30:27.3566667+00:00
Kenny Gua 411 Reputation points