Re: can't Configuration Database Administration Account???

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is this a new install or existing portal that broke recently?

Are you sure that SharePoint can access the SQL server over the network?
Have you checked eventvwr for error messages?

--
Shane Young
SharePoint911 - "SharePoint Help...Now!"


"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
news:emwzJ$OrFHA.3452@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I receive some login failed error to SQL Server which come from Portal
> Server 2003.
> So I want to make sure that the login used in the Configuration Database
> Administration Account is correct.
>
> but when I try to change it (or reapply the password) I receive this error
> :
> Error accessing database. Verify that the database server name and the
> instance name (if present) are correct. Also, ensure the configuration
> database administration account has sufficient permissions on the server
> or instance and the service corresponding to your SQL Server instance is
> running.
>
> My login is the administrator account and this user as access to all the
> databases. (its a domain admins member)
>
> any idea?
>
> thanks.
>
> Jerome.
>
>


.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)