can't Configuration Database Administration Account???

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.

Shane
Mon Aug 29 18:23:52 CDT 2005

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@AAAhotmailBBB.com> wrote in message
news:emwzJ$OrFHA.3452@TK2MSFTNGP14.phx.gbl...
> 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.
>
>

willgart
Mon Aug 29 18:30:04 CDT 2005

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@tk2msftngp13.phx.gbl...
> 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@AAAhotmailBBB.com> wrote in message
> news:emwzJ$OrFHA.3452@TK2MSFTNGP14.phx.gbl...
>> 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.
>>
>>
>
>

willgart
Mon Aug 29 18:34:28 CDT 2005

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@AAAhotmailBBB.com> wrote in message
news:OTgbZGPrFHA.3444@TK2MSFTNGP12.phx.gbl...
> 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@tk2msftngp13.phx.gbl...
>> 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@AAAhotmailBBB.com> wrote in message
>> news:emwzJ$OrFHA.3452@TK2MSFTNGP14.phx.gbl...
>>> 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.
>>>
>>>
>>
>>
>

Shane
Mon Aug 29 23:20:22 CDT 2005

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

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


"Jéjé" <willgart@AAAhotmailBBB.com> wrote in message
news:OCX%232IPrFHA.528@TK2MSFTNGP09.phx.gbl...
> 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@AAAhotmailBBB.com> wrote in message
> news:OTgbZGPrFHA.3444@TK2MSFTNGP12.phx.gbl...
>> 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@tk2msftngp13.phx.gbl...
>>> 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@AAAhotmailBBB.com> wrote in message
>>> news:emwzJ$OrFHA.3452@TK2MSFTNGP14.phx.gbl...
>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>