SMS2003 and Dedicated SQL Server.

From: Locster (anonymous_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 14:02:42 -0700

Anyone know what I need to do to the SQL Server machine if
I want to install the Site Server and the Site Database on
2 different machines? (i.e. installing the SMS database on
a remote SQL computer). ALot of documentation says that I
need to add the Local Machine account of the SMS Site
Server into the Local Administrators' group of the SQL
Server? I cant seem to add computer accounts, I can add
users and groups but it wont let me add computer accounts
in Windows 2000 to the Local Administrators group. In
Windows 2003 I can do this just fine but selecting
the "Object Type" when the user/group selection screen
comes up when adding members to the local administrators
group.

Any help is appreciated.

Relevant Pages

  • Re: Service Account
    ... This component failed to retrieve the list of SMS ... Possible cause: SQL Server problem. ... Verify that SMS can access the SMS site database. ...
    (microsoft.public.sms.setup)
  • ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine
    ... can tell it to pickup our SQL server using SQL ... app and SQL Server. ... >user belongs to the local Administrators group, ...
    (microsoft.public.sqlserver.security)
  • Re: Top Site Customization
    ... I can see the DOC Table in the SITE Database ... Template default.aspx files have been changed, ... then need to change the SQL setting back? ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast