Additional SQL Server features and topics not covered by specific categories
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
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
An object-oriented programming language developed by Microsoft that can be used in .NET.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
Core component of SQL Server for storing, processing, and securing data
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
Technical documentation for SQL Server protocols and standards
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
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
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
Core component of SQL Server for storing, processing, and securing data
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
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
MySQL to C# Connection Error
Developer technologies | Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
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
Additional SQL Server features and topics not covered by specific categories
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
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories