Last post Nov 13, 2008 04:49 PM by penguinview
Oct 29, 2008 11:32 AM|penguinview|LINK
I am using (a modified - modifications are simply consolidating the servers even more) Randy Zhong's Unofficial Consolidated Server guide to experiment with HMC 4.0. My problem occured when I did not notice the warning about SP2 not working with HMC. I
uninstalled SP2 ( during the uninstall I found the hotfix from Microsoft to fix the SP2 issue, but then it was too late to stop the uninstall of SP2) and then it went down hill from there. So I decided to delete the box ( it is a VMware virtual machine) and
just start over. After getting it to the point of actually deploying MPS it still gave errors. Different ones than before.
My question is, is there a way to totally remove what MPS deployment has done?
Apparently there are remnances of it still in AD. I noticed that when installing MPS deplyment tool for the first time it still remembered the name of the old server that I deleted, so Im assuming it is recoreded in AD some where. I did go through and
fix the SPN for the old name to match the new name of the server, but it still does not work. So I would like to start over, but dont want to wipe the whole thing, just the MPS deplyment related parts.
Thanks so much!
Oct 29, 2008 02:41 PM|DmitriG|LINK
Oct 31, 2008 09:21 AM|penguinview|LINK
Sorry for the delay in responding.
Thanks so much for the info, I will try it out later today and see what happens and report back.
Oct 31, 2008 09:55 AM|penguinview|LINK
I followed the directions above. When I open the MPS deployment tool it gives this error. I also lookded and noted that there is not a database called "MPFConfig". Or am I just totally misunderstanding the error? At what point do the databases for MPS
Thanks in advance.
Message: Could not read config data from server MPSSQL001
Inner Exception (1): System.Data.SqlClient.SqlException
Message: Cannot open database "MPFConfig" requested by the login. The login failed.
Login failed for user 'HOSTEDEXCHANGE\administrator'.
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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at Microsoft.Provisioning.DeploymentTool.Engine.SQL.GetConfigData(String server)
at Microsoft.Provisioning.DeploymentTool.Engine.MpfCore.DetectExistingDeployment(String configServer)
Oct 31, 2008 11:34 AM|DmitriG|LINK
At what point do the databases for MPS get created?
After procedure DWSPV.31 execution.
I'm not sure how you get into it, but you MPS server has MPS client installed. I would suggest to completely remove MPS server, MPS SQL server and mentioned object in AD. Then deploy new servers and start provisioning deployment from scratch.
Oct 31, 2008 02:29 PM|penguinview|LINK
WOW, not the most welcome news, but I guess I dont have a choice.
Thanks for the info.
Nov 13, 2008 04:49 PM|penguinview|LINK
Thanks so much for all the help. I was able to get past the errors.