14,669 questions

Sort by: Updated
4 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,669 questions
asked 2026-11-12T20:17:44.18+00:00
answered 2026-11-19T16:36:24.9933333+00:00
Bruce (SqlWork.com) 85,421 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,669 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,669 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,669 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
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,669 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,669 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,669 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,669 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,669 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,669 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,669 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
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,669 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,669 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,669 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,669 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
1 answer

How connect to sql database | server | not local | not use web service, api

I have quite a bit of experience developing for Windows, but not so long ago I switched to Xamarin. I need to connect to a Microsoft SQL database, without using web services and api, the database is not local, it is on a public server. I need any…

Developer technologies | .NET | Xamarin
Developer technologies | .NET | Xamarin

A Microsoft framework for building cross-platform mobile apps using .NET and C# with native performance and user interfaces.

5,342 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,669 questions
asked 2021-03-22T19:07:17.363+00:00
Nort ⠀ 576 Reputation points
edited an answer 2026-11-13T04:28:11.8433333+00:00
Nort ⠀ 576 Reputation points
3 answers

Cannot connect to SQL Server Express

I have a Server running Windows Server 2019 Essentials and SQL Server Express 2019. This can be accessed on the machine through SSMS. I have followed the configure the SQL Server remote access ( Enable TCP/IP Port 1433, restarted services, Added rules in…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,669 questions
asked 2021-02-21T09:53:12.73+00:00
Ian Taylor 21 Reputation points
edited an answer 2026-11-13T04:23:58.91+00:00
Ian Taylor 21 Reputation points
5 answers

Best Practice: which database should I use when creating an audit table for a SQL SERVER LOGON TRIGGER

Hi All, I have a requirement to create a LOGON TRIGGER to monitor logins for auditing purposes. The requirement is to create a table and capture all known logins. I am using SQL Server 2017, enterprise edition. I'm curious which database I should…

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,669 questions
asked 2020-12-16T19:03:09.453+00:00
Abrams, Dan 66 Reputation points
edited an answer 2026-11-13T04:14:02.49+00:00
Abrams, Dan 66 Reputation points
0 answers

How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '

Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…

Azure SQL Database
Azure App Service
Azure App Service

Azure App Service is a service used to create and deploy scalable, mission-critical web apps.

10,031 questions
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,669 questions
Developer technologies | C#
Developer technologies | C#

An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.

11,581 questions
asked 2025-01-03T00:29:43.2+00:00
Krishna Basavaraj K S 0 Reputation points
1 answer

Add member failed for DatabaseRole

TITLE: Microsoft SQL Server Management Studio Add member failed for DatabaseRole 'db_accessadmin'. (Microsoft.SqlServer.Smo) For help, click:…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,669 questions
asked 2024-08-08T12:48:22.54+00:00
Sayed Ahmad Alrefai 0 Reputation points
edited an answer 2026-11-13T04:05:10.17+00:00
Sayed Ahmad Alrefai 0 Reputation points