Our Team and Culture

No matter what type of project you envision, Ideal State will help make it a smashing success. Deliver innovative solutions that improve citizen and employee experience and increase mission impact.

Contacts

Irvine, CA USA

info@globaladmins.com

+1 (949) 346 5577

Linkedin
Uncategorized

Say Goodbye to the SQL Server Native Client (SNAC) OLE DB Provider: Retiring in Azure SQL Manage

Retirement of SQL Server Native Client (SNAC) OLE DB Provider for Linked Servers in Azure SQL Manage
Overview of the Retirement of SNAC
SQL Server Native Client (SNAC) is being retired and is no longer supported. This includes the SNAC OLE DB provider for Linked Servers in Azure SQL Manage. This retirement is due to the fact that SNAC is no longer compliant with security and compliance policies and procedures. As such, all users must transition to a supported provider, such as the Microsoft OLE DB Provider for SQL Server (MSOLEDBSQL) or the Microsoft OLE DB Driver for SQL Server (MSOLEDB).

Impact of the Retirement
The retirement of SNAC has a number of impacts on users of Azure SQL Manage. First, linked servers using SNAC will no longer be able to connect to Azure SQL Manage. This means that any applications or scripts which rely on linked servers using SNAC will no longer be able to function. In addition, any existing linked servers using SNAC must be migrated to a supported provider in order to continue functioning.

How to Migrate Linked Servers from SNAC to MSOLEDBSQL or MSOLEDB
The process for migrating linked servers from SNAC to MSOLEDBSQL or MSOLEDB is fairly straightforward. First, the existing linked server must be dropped. Next, a new linked server must be created using either MSOLEDBSQL or MSOLEDB. Finally, the existing security context must be recreated on the new linked server.

Conclusion
The retirement of SNAC OLE DB provider for Linked Servers in Azure SQL Manage will have a significant impact on users of the platform. It is important for users to migrate their existing linked servers from SNAC to a supported provider in order to continue using Azure SQL Manage. The process for migrating linked servers is relatively straightforward and should not take too long to complete.
References:
Retirement of SQL Server Native Client (SNAC) OLE DB provider for linked servers in Azure SQL Manage
1. SQL Server Native Client
2. SQL Server OLE DB provider
3.