SharePoint - SSP Provisioning Error

Asked By Pappy

22-Aug-07 12:38 PM

I receive this error message when I try to create a SSP for a new
installation:  (Provisioning failed: Windows NT user or group
'eurotherm.local\sqladmin' not found. Check the name again.)

This account is valid and has rights to the web and database server.

Here is the message from the Event Viewer:

A runtime exception was detected. Details follow.
Message: Windows NT user or group 'eurotherm.local\sqladmin' not found.
Check the name again.

Techinal Details:
System.Data.SqlClient.SqlException: Windows NT user or group
'eurotherm.local\sqladmin' not found. Check the name again.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand
command)
at Microsoft.Office.Server.Data.SqlServerManager.GrantLogin(String user)
at
Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeConfigurationDatabaseAccess(SharedComponentSecurity security)
at
Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity)
at
Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Install()
at
Microsoft.Office.Server.Administration.SharedResourceProvider.Provision()


--
Thanks in advance,
Forrest

24-Aug-07 01:54 PM

Not sure if this make a difference ... both servers are running on VMWare.
--
Regards,
Forrest

01-Sep-07 07:52 PM

I do not really know why I had to do this but I had to change the SSP database and the Search Database to use  SQL authentication to get thru this.

03-Sep-07 04:41 AM

If you look at the security login for your sql server do you see the users in "computername/username" or "Domain/username"? I installed Sql Server before I upgraded my Win2003 computer to be a PDC but somehow the sql username stays with old format. I had to reinstall Sql Server.

04-Sep-07 11:06 AM

Wow, I was hoping to avoid using SQL Authentication
--
Regards,
Forrest

04-Sep-07 11:10 AM

It appears as "Domain/username".
--
Regards,
Forrest

05-Oct-07 09:31 AM

You need to use the Netbios name of your domain, not eurotherm.local
for all your logins and that will take care of it.

05-Oct-07 10:54 AM

I am having the exact same problem.  Am not using the 'eurotherm.local' format
for my logins, but the standard DOMAIN/ID format.  Still getting that same
error.

Is DOMAIN/ID what you mean by netbios name of the domain, or is that
something else
entirely?


Thanks,

06-Nov-07 05:10 PM

We are having the same problem. More clarity would be great.

06-Nov-07 09:19 PM

Did you use FQDNs (domain.com\username) for your initialization of the MOSS
databases?  I blogged about this a while ago [1]. FQDNs are not welcome in
MOSS.  The SQL calls choke on FQDN and thus the error that you are seeing
and non SSP provisioning.

You will have to go back through all of the service accounts that make calls
to the Database and change the accounts to the NETBIOS domain name\username.


[1] http://thaddparker.spaces.live.com/blog/cns!ECFD9E8CDB82F694!183.entry

--
Blog: http://thaddparker.spaces.live.com/blog

24-Nov-07 02:03 PM

Still not clear on what the exact name should be.

SQL Server name:REJ1
Moss server name: rejmoss
Domain:JPSC.local
user: rjones

so I type: jpsc\rjones and it excepts the user after I check name, but I get
the same error about not being able to find user or group.

Can you tell me if my entry is wrong and what it should look like?
--
RJ