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

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

Maybe we should start over. Where do you see errors about login failed?

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


"Jéjé" <willgart@xxxxxxxxxxxxxxxxx> wrote in message
news:OCX%232IPrFHA.528@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • 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)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (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)