Autentikasi Kerberos Terintegrasi (Penyedia OLE DB Klien Asli)
Berlaku untuk: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Sampel ini menunjukkan cara mendapatkan autentikasi Kerberos bersama dengan menggunakan OLE DB di SQL Server Native Client. Sampel ini berfungsi dengan SQL Server 2008 (10.0.x) atau yang lebih baru.
Untuk informasi selengkapnya tentang SPN dan autentikasi Kerberos, lihat Dukungan Nama Prinsipal Layanan (SPN) di Koneksi Klien.
Anda harus menentukan server. Dalam file .cpp, ubah "MyServer" menjadi nama komputer yang memiliki instans SQL Server 2008 (10.0.x) (atau yang lebih baru).
Anda juga harus menentukan SPN yang disediakan pelanggan. Dalam file .cpp, ubah "CPSPN" menjadi SPN yang disediakan pelanggan.
Pastikan variabel lingkungan INCLUDE Anda menyertakan direktori yang berisi sqlncli.h. Kompilasi dengan ole32.lib oleaut32.lib.
// compile with: ole32.lib oleaut32.lib
#pragma once
#define WIN32_LEAN_AND_MEAN // Exclude rarely-used stuff from Windows headers
#include <stdio.h>
#include <tchar.h>
#include <sqlncli.h>
#define CHECKHR(stmt) \
do { \
hr = (stmt); \
if (FAILED(hr)) { \
printf("CHECK_HR " #stmt " failed at (%hs, %d), hr=0x%08X\r\n", __FILE__, __LINE__, hr); \
goto CleanUp; \
} \
} while(0)
#define CHECKVB(stmt) \
do { \
if ((stmt)!= VARIANT_TRUE) { \
printf("CHECK_VB " #stmt " failed at (%hs, %d)\r\n", __FILE__, __LINE__); \
goto CleanUp; \
} \
} while(0)
#define CHECKBOOL(stmt) \
do { \
if (!(stmt)) { \
printf("CHECK_BOOL " #stmt " failed at (%hs, %d)\r\n", __FILE__, __LINE__); \
goto CleanUp; \
} \
} while(0)
#define CHECKNULL(stmt) \
do { \
if ((stmt) == NULL) { \
printf("CHECK_NULL " #stmt " failed at (%hs, %d)\r\n", __FILE__, __LINE__); \
goto CleanUp; \
} \
} while(0)
#define SAFERELEASE(p) \
do { \
if ((p)!= NULL) { \
p->Release(); \
p = NULL; \
} \
} while(0)
#define SAFE_SYSFREESTRING(p) \
do { \
if ((p)!= NULL) { \
::SysFreeString(p); \
p = NULL; \
} \
} while(0)
int _tmain(int argc, _TCHAR* argv[]) {
HRESULT hr = S_OK;
IDBInitialize* pInitialize = NULL;
IDBProperties* pProperties = NULL;
DBPROPSET PropertySet[1];
DBPROP rgdbprop[1];
LPCWSTR lpwszProviderString = L"Server=MyServer;" // server with SQL Server 2008 (or later)
L"Trusted_Connection=Yes;"
L"ServerSPN=CP_SPN;"; // customer-provided SPN
DBPROPID rgdbPropID[2];
DBPROPIDSET rgdbPropIDSet[1];
ULONG cPropertySets;
DBPROPSET *prgPropertySets;
CHECKHR(CoInitialize(NULL));
CHECKHR(CoCreateInstance(CLSID_SQLNCLI11, NULL, CLSCTX_INPROC_SERVER, __uuidof(IDBProperties), reinterpret_cast<void **>(&pProperties)));
// set provider string
rgdbprop[0].dwPropertyID = DBPROP_INIT_PROVIDERSTRING;
rgdbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
rgdbprop[0].colid = DB_NULLID;
VariantInit(&(rgdbprop[0].vValue));
V_VT(&(rgdbprop[0].vValue)) = VT_BSTR;
V_BSTR(&(rgdbprop[0].vValue)) = SysAllocString(lpwszProviderString);
// set the property to the property set
PropertySet[0].rgProperties = &rgdbprop[0];
PropertySet[0].cProperties = 1;
PropertySet[0].guidPropertySet = DBPROPSET_DBINIT;
// set properties and connect to server
CHECKHR(pProperties->SetProperties(1, PropertySet));
CHECKHR(pProperties->QueryInterface(__uuidof(pInitialize), (void **)&pInitialize));
CHECKHR(pInitialize->Initialize());
// get properties
rgdbPropID[0] = SSPROP_INTEGRATEDAUTHENTICATIONMETHOD;
rgdbPropID[1] = SSPROP_MUTUALLYAUTHENTICATED;
rgdbPropIDSet[0].rgPropertyIDs = &rgdbPropID[0];
rgdbPropIDSet[0].cPropertyIDs = 2;
rgdbPropIDSet[0].guidPropertySet = DBPROPSET_SQLSERVERDATASOURCEINFO;
CHECKHR(pProperties->GetProperties(1, rgdbPropIDSet, &cPropertySets, &prgPropertySets));
wprintf(L"Authentication method: %s\r\n", (LPWSTR)V_BSTR(&(prgPropertySets[0].rgProperties[0].vValue)));
wprintf(L"Mutually authenticated: %s\r\n", (VT_BOOL == V_VT(&(prgPropertySets[0].rgProperties[1].vValue)))?L"yes":L"no");
CleanUp:
SAFERELEASE(pProperties);
SAFERELEASE(pInitialize);
VariantClear(&(rgdbprop[0].vValue));
CoUninitialize();
}