B?n nh?n ?c m?t "c s? d? li?u <database_name>? t?n t?i" thng bo l?i khi b?n qu?n l? c s? d? li?u n?i dung Windows SharePoint Services</database_name>

D?ch tiu ? D?ch tiu ?
ID c?a bi: 828815 - 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

Khi b?n c? g?ng qu?n l? c?a b?n Microsoft Windows SharePoint D?ch v? n?i dung c s? d? li?u b?ng cch s? d?ng cc Qu?n l? n?i dung C s? d? li?u Trang SharePoint trung tm qu?n tr?, b?n c th? nh?n m?t trong cc thng bo l?i sau y:
Co? so? du? lie?u Database_Name' ? t?n t?i. (L?i M?: 1801)


Ng?i dng hi?n th?i ho?c nh?n d?ng h? bi ?ng d?ng cc my ch? ?o khng ph?i l ch? s? h?u c s? d? li?u 'sts_servername_1' trn my ch? 'server_name\share_point'.

NGUYN NHN

V?n ? ny c th? x?y ra khi ng?i s? h?u c s? d? li?u c s? d? li?u b?n ang k?t n?i ?n l khc nhau t? danh tnh h? bi ?ng d?ng SharePoint ang ch?y d?i.

GI?I PHP

? gi?i quy?t v?n ? ny, thay ?i quy?n s? h?u c s? d? li?u v cc c?p php cho c s? d? li?u n?i dung ? ph h?p v?i danh tnh c?a ?o my ch? ti kho?n Google cho n?i dung v c?u h?nh. thc hin vic nay, hay lam theo nhng bc sau:
  1. Trn my tnh ang ch?y Microsoft SQL Server, Nh?p vo B?t ?u, i?m ?n T?t c? chng tr?nh, i?m ?nMicrosoft SQL Server, sau b?m Truy vn Trinh phn tich.
  2. Trong cc K?t n?i v?i SQL Server h?p tho?i, g? tn h? ph?c v? trong cc May chu SQL h?p, v sau nh?p voOk.
  3. Trn cc Truy vn tr?nh n, nh?p vo Thay i Co? so? du? lie?u.
  4. Trong cc Ch?n c s? d? li?uServer_Name h?p, b?m vo c s? d? li?u n?i dung b?n mu?n C?p Nh?t, v sau nh?p vo Ok.
  5. Trong cc Truy vn c?a s?, g? nh sau truy v?n.

    Chu y Trong d?ng 3 v 4 c?a cc truy v?n, thay th?Domain_Name\Content_AccountvDomain_Name\Admin_Accountv?i trng m?c vng cho my ch? ?o n?i dung v cc ti kho?n tn mi?n cho my ch? ?o c?a chnh quy?n trung ng SharePoint. N?u cc ti kho?n nh v?y, SQL Query Analyzer hi?n l?i khi b?n ch?y truy v?n, nhng cc qu tr?nh v?n thnh cng.

    Khai bo @ AdminVSAccount nvarchar(255)
    Khai bo @ ContentVSAccount nvarchar(255)
    THI?T L?P @ ContentVSAccount = N'Domain_Name\Content_Account';
    ?T @ AdminVSAccount = N'Domain_Name\Admin_Account';
    EXEC sp_grantlogin @ ContentVSAccount;
    EXEC sp_grantlogin @ AdminVSAccount;
    EXEC sp_changedbowner @ AdminVSAccount;
    N?U KHNG T?N T?I (Ch?n * t? sysusers ni name=@ContentVSAccount)
    EXEC sp_grantdbaccess @ ContentVSAccount;
    EXEC sp_addrolemember 'db_owner', @ ContentVSAccount;
  6. Trn cc Truy vn tr?nh n, nh?p voTh?c thi.
N?u b?n ang ch?y Windows SharePoint Services v?i WMSDE, c cc b?c ring bi?t ? gi?i quy?t v?n ?. Trong ci ?t WMSDE, cc ?ng d?ng nh?n d?ng h? bi cho chnh quy?n trung ng SharePoint l m?ng D?ch v?. Cho SQL 2000, b?n khng th? thay ?i ch? s? h?u c s? d? li?u ?n d?ch v? m?ng v? c?a m?t gi?i h?n thi?t k?. Workaround cho vi?c ci ?t WMSDE l Thm d?ch v? m?ng vo vai General WMSDE, thm c s? d? li?u tr? l?i b?i b?ng cch s? d?ng c s? d? li?u SharePoint qu?n l? n?i dung, v sau th? vai tr? cho m?ng D?ch v? quay l?i ci ?t g?c c?a n.

? thi?t l?p d?ch v? m?ng nh ILOS, lm theo cc b?c sau:
  1. B?t ?u m?t phin OSQL.

    ? lm i?u ny, b?mB?t ?u, b?m T?t c? chng tr?nh, b?mPh? ki?n, sau b?m Ch? huy Nh?c.
  2. T?i d?u nh?c l?nh, b?t ?u m?t phin OSQL b?ng cch g? cc sau c php ni ServerName l tn c?a c?a b?n my ch?, v sau pres ENTER:
    osql -S ServerName\sharepoint -E
  3. G? l?nh sau y, sau nh?n ENTER:
    sp_addsrvrolemember 'nt authority\network service', 'General'
  4. Lo?i i, va sau o bam NH?P.
  5. Trong chnh quy?n trung ng SharePoint, thm n?i dung c s? d? li?u ?n my ch? ?o.
  6. Sau khi c s? d? li?u n?i dung ?c thm tr? l?i, th? m?ng D?ch v? vai tr? quay l?i an ninh qu?n tr? vin v ng?i sng t?o c s? d? li?u.
  7. G? l?nh sau t?i d?u nh?c l?nh OSQL, v sau nh?n ENTER:
    sp_dropsrvrolemember 'nt authority\network service', 'General'
  8. Lo?i i, va sau o bam NH?P.
  9. Lo?i b? ? thot ra phin h?p OSQL.

THAM KH?O

? bi?t thm chi ti?t, xem cc Microsoft Windows SharePoint Services qu?n tr? h?ng d?n. ? bi?t thm v? c s? d? li?u yu c?u ch? s? h?u quy?n v c s? d? li?u c?p php, xem ch? ? "Di c t? WMSDE to SQL Server" trong ch? ? "Sao lu v di c".

Thu?c tnh

ID c?a bi: 828815 - L?n xem xt sau cng: 30 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft Windows SharePoint Services 2.0
  • Microsoft Office SharePoint Portal Server 2003
T? kha:
kbtshoot kbdatabase kberrmsg kbwebservices kbprb kbmt KB828815 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? 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 ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. 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. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:828815

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