RE: SQL Set to System Account - Sharepoint Question

Lesa,
Although Lee has attempted to answer your question, I hope he won't mind if
I respond differently.

First, I doubt you are asking your question correctly... I'm pretty sure
you're referring to the SA (which generally is said to stand for "SQL
Administration", not System Account) account.

The app may or may not have reasons to at least run with SA permissions...,
generally to initially create a database and the supporting database
structures outside of the database itself.

But, if the app installation doesn't need to do that initially and
<definitely> after the installation there isn't normally any reason to
continue to run using SA permissions.

My recommendation:
If you must grant SA permissions, install a completely separate instance of
SQL, don't use an instance being used for anything else.
<Ask> the App Support people why SA is required. If it's needed for
installation, ask them if the app will run using a non-SA account thereafter,
even if the accounts needs to be assigned the dbo role (which essentially
gives it super user permissions but only within the database).

As for conflicts with MSDE and a later upgrade to SQL, if you keep the new
application's database completely separate offhand I don't see how you will
run into any kind of problem. If you decide to use the same SQL instance for
an SBS app and your new app, although not a critical step I'd generally
recommend upgrading first to make life easier for yourself.

HTH,
Tony






""Lee Li[MSFT]"" wrote:

> Dear Lesa,
>
> Thank you for posting.
>
> This is Lee and I am glad to meet you in the newsgroup again.
> You will NOT get any problems if you set the SQL server to be started at
> the System Account.
> After you had installed the SBS 2003 on the computer, a MSDE will be
> installed on the computer automatically.
> The MSDE is a simple version of SQL server and is used by the Sharepoint.
> By default, the MSDE service is started in the System Account.
> So it will be no problem for you to move the sharepoint DB to the SQL
> server installed on this computer which was started at the System Account.
>
> By the way, for detail steps to move the sharepoint DB, please take a look
> at the following URL:
> http://download.microsoft.com/download/1/1/6/11671e4d-fb21-489c-870f-db36fd2
> 1a7d2/SBS_MoveDataFolders.DOC
>
> Hope the above information helps. Have a nice day!
>
> Sincerely,
>
> Lee Li
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
>
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
>
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
.

Relevant Pages

  • Re: SQL Set to System Account - Sharepoint Question
    ... > Administration", not System Account) account. ... > after the installation there isn't normally any reason to ... > SQL, don't use an instance being used for anything else. ... > the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: Replacing SBS2000 - Need Guidance
    ... Actually this has changed they will support the SQL on the SBS 2008 itself. ... Installation of SQL to the SBS2008 itself is not supported. ... If the total required capacity could be easily covered by HDD*2 I would simply install a single RAID5 array consisting of 3 drives in array plus hotspare. ...
    (microsoft.public.windows.server.sbs)
  • Re: Sql express sp1 after Sql sp1 setup
    ... That is, what I want to do, to upgrade both ... as the installation from the SP1 for the SQL Express ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: ADP PC/Payroll database
    ... They don't support it because it doesn't fit the installation script ... I've had success with numerous SQL flavours on SBS, ... In my experience, ADP isn't the devil, but they have more than a passing ... If ADP won't support this, don't do it, plain and simple. ...
    (microsoft.public.windows.server.sbs)
  • Re: suncomm, drm, intel
    ... If you have a message from Rob before today regarding the support of this software, you will need to check again, as Rob now has new ... Tiger "broke" the installation of the MediaMax software, and the devs are working to fix this. ... The installation does not make a reference to Tiger not being supported. ... The brochure on SunnComm's MediaMax specifically states "Mac Protection and Compatibility" stating that "For the first time, content can be played and protected on a Mac with the same experience enjoyed on a PC..." ...
    (comp.sys.mac.advocacy)