SQL Server

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…

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.

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…

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…

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…

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 …

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!

MySQL to C# Connection Error

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

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…

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…

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…

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,…

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 …

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…

SSIS Oracle Source - DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Hi All, I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 2019 database. I'm using Oracle connection (Connection Manager for Oracle Connections) for my source and an OLE DB connection for my SQL 2019 database.…

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…

Need help on parameterization of Integration Runtime and Azure Key vault Secrets on link service in Azure Data Factory pipeline

Hi, I have to migrate 90 clients database from Azure Managed Instances databases to Azure VM Data Servers. For the above requirement, I have created the below resources * 90 Azure Data Factory Pipelines * 90 self-hosted integration runtime as each…

Possible to host SQL server 2022 in AWS RDS as SSRS database?

Hello, I would like to know is that possible to host SSRS database sql server 2022 in AWS RDS? I trying to host SSRS in EC2 and SQL server in RDS then I use rds admin user to connect database on Configuration manager set up and getting this permission…

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…