标题: SMS administrator console ?接的???求助? [打印本页] 作者: zwf-chopin 时间: 2007-04-14 23:14 标题: SMS administrator console ?接的???求助? 在用SMS administrator console 聯接服務器的時候﹐總是說連不上提示Connection Failed﹐我查看了adminUI.log.出現的錯誤是\"-2147023174 [ 0x800706ba ] \"。不知道誰有好的解決的辦法啊﹖﹖謝謝了作者: pl1212770 时间: 2007-04-14 23:22
? The Remote Service account (SMSSvc_sitecode_xxxx)
If you are using SMS Advanced security, create a SQL Server login account for the SMS site server computer account on the remote computer that is running SQL Server. Then, give the SQL Server System Administrator role the rights to the site server computer account.
2. Click Start, click Programs, click Microsoft SQL Server, and then click Enterprise Manager.
3. Expand Microsoft SQL Servers, expand SQL Server Group, expand the server to which you want to add a SQL Server login account, and then expand Security.
4. Right-click Logins, and then click New Login.
5. On the General tab, add the account name and the authentication information.
6. Under Defaults, click the list next to Database, and then select the SMS database that you want.
7. Click the Server Roles tab, and then select the System Administrators check box in the Server Roles list.
8. In the Server Role Properties - sysadmin dialog box, verify that the new account name is listed in the Specify which logins are members of the security role list, and then click OK.