M?t SPN cho b?n ghi d?ch v? tr?nh duy?t my ch? SQL ?c yu c?u khi b?n thi?t l?p k?t n?i v?i m?t tr?ng h?p ?c ?t tn c?a SQL Server b?n ghi d?ch v? phn tch

D?ch tiu ? D?ch tiu ?
ID c?a bi: 950599 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

Tri?u ch?ng

Xem xt k?ch b?n sau y. B?n thi?t l?p k?t n?i v?i m?t tr?ng h?p ?c ?t tn c?a b?n ghi d?ch v? phn tch Microsoft SQL Server. Sau , cc b?n ghi d?ch v? SQL my ch? tr?nh duy?t xc ?nh c?ng m th? hi?n ?c ?t tn l c s?n. K?t n?i s? d?ng xc th?c Kerberos. Trong tr?ng h?p ny, tn nguyn t?c b?n ghi d?ch v? (SPN) cho cc b?n ghi d?ch v? tr?nh duy?t my ch? SQL l, ngoi SPN cho tr?ng h?p ?c ?t tn c?a b?n ghi d?ch v? phn tch. N?u SPN cho b?n ghi d?ch v? tr?nh duy?t my ch? SQL khng t?n t?i, Xc thc Kerberos khng thnh cng.

Nguyn nhn

Hnh vi ny x?y ra ch? khi k?t n?i chu?i ch?a cc SSPI = Kerberos tham s?. Trong tr?ng h?p ny, k?t n?i b? bu?c ph?i s? d?ng xc th?c Kerberos, v SPN cho b?n ghi d?ch v? SQL my ch? tr?nh duy?t ph?i ?c c?u h?nh.

N?u k?t n?i chu?i ch?a cc SSPI = Kerberos tham s?, Xc thc Kerberos th?ng ?c s? d?ng. K?t n?i t?i b?n ghi d?ch v? SQL my ch? tr?nh duy?t s? d?ng NTLM v ti kho?n NT_ANONYMOUS thay vo . Trong tr?ng h?p ny, k?t n?i vo b?n ghi d?ch v? tr?nh duy?t my ch? SQL ?c thnh cng. b?n ghi d?ch v? tr?nh duy?t my ch? SQL xc ?nh ng c?ng. Sau , k?t n?i b? my c s? d? li?u th?c t? s? d?ng xc th?c Kerberos nh?m xc th?c ng s? th?t.

Gi?i php

B?n ph?i t?o m?t SPN cho b?n ghi d?ch v? SQL my ch? tr?nh duy?t b?ng cch s? d?ng ti kho?n theo ch?y b?n ghi d?ch v? tr?nh duy?t my ch? SQL.

?nh d?ng c?a m?t SPN NetBIOS l nh sau:
MSOLAPDisco.3/serverHostName
?nh d?ng c?a m?t tn mi?n ?y ? i?u ki?n SPN l nh sau:
MSOLAPDisco.3/serverHostName.Fully_Qualified_domainName

Lm th? no ? ki?m nh?p SPN

B?n ph?i l thnh vin c?a nhm ng?i qu?n tr? mi?n ? ch?y l?nh Setspn .

? t?o ra SPN cho b?n ghi d?ch v? tr?nh duy?t ang ch?y d?i ti kho?n tn mi?n, h?y ch?y cc l?nh sau t?i d?u ki?m nh?c l?nh:
Setspn.exe - m?t MSOLAPDisco.3/serverHostName.Fully_Qualified_domainName Browser_Service_Startup_Account

Setspn.exe - m?t MSOLAPDisco.3/serverHostName Browser_Service_Startup_Account
N?u b?n ph?i t?o SPN cho b?n ghi d?ch v? tr?nh duy?t ang ch?y d?i ti kho?n LocalSystem, h?y ch?y l?nh sau t?i d?u ki?m nh?c l?nh:
Setspn.exe - m?t MSOLAPDisco.3/serverHostName.Fully_Qualified_domainName serverHostNameSetspn.exe - m?t MSOLAPDisco.3/serverHostName serverHostName

? xc minh SPN

Khi cc b?n ghi d?ch v? ang ch?y d?i ti kho?n tn mi?n:
Setspn l Browser_Service_Startup_Account
Khi cc b?n ghi d?ch v? ang ch?y d?i ti kho?n LocalSystem:
Setspn -l serverHostName

T?nh tr?ng

Hnh vi ny l do thi?t k?.

Thu?c tnh

ID c?a bi: 950599 - L?n xem xt sau cng: 19 Thang Ging 2014 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2005 Analysis Services
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2008 Analysis Services
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
T? kha:
kbtshoot kbprb kbmt KB950599 KbMtvi
My d?ch
QUAN TRONG: Bai vit nay c d?ch b?ng phn mm dich thu?t cua Microsoft va co th c Cng ng Microsoft chinh sa l?i thng qua cng ngh CTF thay vi mt bin dich vin chuyn nghip. Microsoft cung c?p cc bi vi?t ?c c? bin d?ch vin v ph?n m?m d?ch thu?t th?c hi?n v c?ng ?ng ch?nh s?a l?i ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng nhi?u ngn ng? Tuy nhin, bi vi?t do my d?ch hoc thm chi cng ng chinh sa sau khng ph?i lc no c?ng hon h?o. Cc bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 950599

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com