WSS SQL SERVER LOGIN QUESTION - Only 'sa' can login to SQL

I just setup a second server with SQL 2000 and WSS 2.0. Everything
seems to work OK but the bug-a-boo in my setup is, only the SQL sa User
account can login from the WSS Admin setup page; where you setup a
Content and Configuration database. Not even my administrator account
can access the SQL server from this page. Yet, my SQL enterprise
manager tools use the 'sa' account, Administrator, and a special
account I created just for this purpose. Can anyone tell me what the
proper account configuration needs to be; I don't mind using the 'sa'
account, but would prefer to create a special WSS Database account for
Sharepoint to use.

.

Relevant Pages

  • Re: Site full text not functioing
    ... For WSS, we use SQL Full Text search. ... Find out if the SQL Server account has permissions to that folder if the error message indicates a folder on the hard drive. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: WSS Installation problem, please help!
    ... I had to add my Application Pool account to the local STS-WPG and IIS_WPG ... entire WSS and SQL setup, but unfortunately it's on me to figure it out. ... SQL Enterprise Manager and it is set to 'SQL Server and Window'. ...
    (microsoft.public.sharepoint.windowsservices)
  • SQL Server Job Failed (ActiveScripting pecific error 87)
    ... I have setup a job in SQL to execute dll written in vb. ... I then assign sysadmin rights to ... account as the SQL Agent Proxy Account have the following four rights ...
    (microsoft.public.sqlserver.server)
  • SQL Mail
    ... I am trying to setup SQL mail for when my remote jobs fail. ... test email to myself thru outlook on the server. ... the mail account in SQL EM. ...
    (microsoft.public.sqlserver.server)
  • Re: Problems adding users
    ... I had to do some SQL surgery this afternoon that may or may not help. ... A domain username was ... First we tried to rename the user, but WSS ... >> account in the AD was never deleted, the account name for this user was ...
    (microsoft.public.sharepoint.windowsservices)
Loading