Conference heron::dw_tools

Evelyn,
Please check out the comments in note 25 on Powermart installation and startup
problems.
It seems the foolproof change is to use a system account
(Control-panel/services/ - choose powermart service -/startup/log on as/check
the System Account checkbox.)

Cheers, Rob

	This sounds similar to the problems that I have had with the
	PM Server.

	>> The event of interest appears to be "Failed to log on NT user".

	I don't believe from what you have said that the startup is
	reaching SQL Server. If the service startup fails then the chances are 
	that the service is trying to start under an invalid user/password for 
	NT. Try changing the service startup to use the system account and see
	if that works. If it does then double check the user/password 
	for the logon account for that service and try again.

	If it still fails then use PM Server Configure to check the username,
	password and connect string for the server connection to SQL Server.
	Using ODBC trace may provide you with some other information.

	Nick.	

    

Rob and Nick,
Thanks for your replies.  I neglected to mention that I had tried 
using the system account also and got the same error.

>	If the service startup fails then the chances are 
>	that the service is trying to start under an invalid user/password for 
>	NT. 

I verified that the PowerMart user was a valid nt user by logging in
using that user name and password.

>	If it still fails then use PM Server Configure to check the username,
>	password and connect string for the server connection to SQL Server.

Is this the repository entries in the PM Server Configuration task?  
What repository are they asking for?  The entries I made are:
	Repository name:	repositorydb
	DB type:		sql server
	User Name:		DMUser1
	PW:			dmuser1
	Confirm PW:		dmuser1
	Connect string		radc06@repositorydb

	Use trusted connections is checked.

Now this is the repoistory that I created from the client side.  I can
get to it fine using an ODBC connection from the client.

>	Using ODBC trace may provide you with some other information.
Am I supposed to have an ODBC driver on the NT system for use by PowerMart
Server?

Thanks for your help.
Regards,
Evelyn

    

Evelyne,
Hmmm, using the System account usually always works.
According to your .0 list of what's happening, it really does seem that it is
an issue of NT username specified in the Services Startup which is not being
validated.
Now this is a little more complex than it appears, because it depends upon
the NT domain configuration. If you are using the Powermart username, that the
name has to be validated on the Domain security server. It could be that you
have defined the Powermart username on the local server, which is NOT the
domain security server. The solution in this case is to define the Powermart 
username on the domain security server, if you have the rights to do so.
If you don't, use the default system account. However you check that the latter
is authorised to be used as service username. For this, check in NT User
Management that the username can be a service username account "log on as a
service" (advanced Right).

Hope this helps,
Rob

>> Is this the repository entries in the PM Server Configuration task?  
>> What repository are they asking for?  The entries I made are:
>>	Repository name:	repositorydb
>>	DB type:		sql server
>>	User Name:		DMUser1
>>	PW:			dmuser1
>>	Confirm PW:		dmuser1
>>	Connect string		radc06@repositorydb
>>
>>	Use trusted connections is checked.


	Evelyn,

	It sounds to me as if you are following the Digital Data Mart
	Software Installation Guide. Have you created a respository yet?

	The reason that I ask is that I came up against numerous problems
	following the guide, some because of the information that wasn't
	there and others because the order in which the installation is 
	documented.

	The parameters that you have listed are for creating a repository
	and are referenced in the 'Create the Database' section. To do
	this you do need an ODBC driver. 

	Once you have created the repository then you configure the 
	PowerMart Server with the username and password and connect string
	for the repository. The connect string consists of the server name
	and the repository (database) name. 

	The configuration I am using for Bob's Video is:

	    Username: demosa
	    Password: demosa
	    ConnectString: systemname@DemoMetaData

	where the system name is the name of the server holding the repository
	and DemoMetaData is the repository name. 

    	I have seen the 'internal Windows NT error' message before when I
	was following the DDM Install Guide. 

    	I managed to recreate the message by changing the PowerMart
	Server configuration to be invalid. If I configured an incorrect
    	connect string or invalid username/password then I got the 'internal
	Windows NT error' error message.

	Hope this helps.

	Nick
    

OK, here's what the problem was.

The DMUser1 account that I had set up on the NT system was in a group that 
I created and was not in any other group.  When I tried to logon to NT with 
this user name, I could not logon interactively.  So, I went back and 
checked the system and found out that the only ones who could logon were 
users in the adminstrator group.  So, I put DMUser1 in the admin. group and
viola!! the server started.

As usual, it was just some minor little problem that only took me 3 days to 
find...

Thanks for your help.
Evelyn

    
    	Evelyn,
    
    	that's the wonder of the world of Microsoft....how long are we 
    	quoting to deliver these Digital Data Marts? 
    
    	Nick.
    
    	(good feeling of relief when it works though isn't it)