System.Data.SqlClient.SqlCommand.RunExecuteReader
(1)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery
(1)
System.Data.SqlClient.SqlConnection.OnError
(1)
SQL Server
(1)
JPSC.local
(1)
Office
(1)
BulkCopySimpleResultSet
(1)
TdsParserStateObject
(1)

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

Not sure if this make a difference ... both servers are running on VMWare.

Asked By Pappy
24-Aug-07 01:54 PM
Not sure if this make a difference ... both servers are running on VMWare.
--
Regards,
Forrest

SSP Provisioning Error - Pappy

Asked By Alex Wu
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.

SSP Provisioning Error

Asked By Alex Wu
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.
SSP Provisioning Error - Pappy
Asked By Pappy
04-Sep-07 11:06 AM
Wow, I was hoping to avoid using SQL Authentication
--
Regards,
Forrest
SSP Provisioning Error
Asked By Pappy
04-Sep-07 11:10 AM
It appears as "Domain/username".
--
Regards,
Forrest
SSP Provisioning Error
Asked By willie5
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.
SSP Provisioning Error
Asked By KVoller
05-Oct-07 10:39 AM

         
I am having the exact same problem. Am not using the 'eurotherm.
Asked By KVoller
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,
SSP Provisioning Error
Asked By TheMa
06-Nov-07 05:10 PM
We are having the same problem. More clarity would be great.
Did you use FQDNs (domain.
Asked By TParker
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
Still not clear on what the exact name should be.
Asked By ro
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
Post Question To EggHeadCafe