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
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 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
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
A Microsoft framework for building cross-platform mobile apps using .NET and C# with native performance and user interfaces.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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
Additional SQL Server features and topics not covered by specific categories
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
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
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
An Azure relational database service.
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
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.
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
Additional SQL Server features and topics not covered by specific categories