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

omit the question about the event viewer ;-)

the event viewer display nothing special when I try to change the account used to access the configuration database.
also I don't see anything special at the SQL Server level during this step.


"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message news:OTgbZGPrFHA.3444@xxxxxxxxxxxxxxxxxxxxxxx 
its an old installation.
I try to change the login to (I hope) solve SQL server issues.

SQL Server is on the same server as portal server.
This account can open locally or remotly all databases.
This account works fine on 99.9% of the queries made to the server, only 1 unidentified request cause the login error in SQL server.

where is the eventvwr?

"Shane Young" <shane at sharepoint911 .com> wrote in message news:eB8F5CPrFHA.3604@xxxxxxxxxxxxxxxxxxxxxxx 
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: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: DTS Package fails when Scheduled
    ... Apparently I was unable to pass on the database password when runninig the ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • 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)