Sathiya's Blog

Add computer to domain using CMD without restart

From your windows client machine open command prompt and run the following cmd to add computer to domain.

wmic.exe /interactive:off ComputerSystem Where name=”%computername%” call JoinDomainOrWorkgroup FJoinOptions=3 Name=”myDom.local” UserName=”myDom\UsrName” Password=”@passwrd!@”

1	wmic.exe /interactive:off ComputerSystem Where name=“%computername%” call JoinDomainOrWorkgroup FJoinOptions=3 Name=“myDom.local” UserName=“myDom\UsrName” Password=“@passwrd!@”

March 13, 2015

Error configuring Management Reporter 2012

While configuring MR 2012 RU5 for Dynamics GP 2012 with Microsoft SQL 2014, this is the error we have faced;

Error:
2/16/2015 3:15:09 PM - System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://dynamics/CompanyService.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 10.0.0.5:4712


at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)

--- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context) at System.Net.HttpWebRequest.GetRequestStream() at System.ServiceModel.Channels.HttpOutput.WebRequestHttpOutput.GetOutputStream() --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Security.IssuanceTokenProviderBase 1.DoNegotiation(TimeSpan timeout) at System.ServiceModel.Security.SspiNegotiationTokenProvider.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Security.SymmetricSecurityProtocol.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.SecurityChannelFactory 1.ClientSecurityChannel 1.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.DoOperation(SecuritySessionOperation operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.GetTokenCore(TimeSpan timeout) at System.IdentityModel.Selectors.SecurityTokenProvider.GetToken(TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionClientSettings 1.ClientSecuritySessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade) at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyService.ICompanyService.FillAllConfiguredIntegrations() at Microsoft.Dynamics.Performance.Deployment.Common.WcfUtility.ExecuteOnClient[TCommunicationObject,TReturn](Func 2 invokeMe, Func 1 clientFactory) at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyServiceHelper.ExecuteOnClient[T](Func 2 invokeMe, Func 2 exceptionHandler, Uri applicationServiceUri) 2/16/2015 3:16:09 PM - Starting deployment of Management Reporter 2012 Application Service 2/16/2015 3:16:09 PM - Creating PrincipalContext for domain <domain> 2/16/2015 3:16:09 PM - Finding Principal for user entadmin in context for domain <domain> 2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ManagementReporter.dacpac 2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\SchedulerStore.dacpac 2/16/2015 3:16:09 PM - Found database package: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Packages\ConnectorStore.dacpac 2/16/2015 3:16:09 PM - Deployment parameters: DatabaseCollation: SQL_Latin1_General_CP1_CI_AS WindowsLoginToCreate: <domain>\mrsvc FirstAdminUserName: <domain>\entadmin FirstAdminSid: S-1-5-21-1583657088-1483352188-1218694631-500 FirstAdminDisplayName: Ent Admin 2/16/2015 3:16:09 PM - Extracting supporting files for database deployment... 2/16/2015 3:16:09 PM - Beginning database deployment... 2/16/2015 3:16:11 PM - The database deployment failed. Additional information: Could not deploy package. 2/16/2015 3:17:21 PM - Microsoft.Dynamics.Performance.Deployment.Console.Core.DeploymentFailedException: An error occurred during database deployment. View the deployment log for more information. at Microsoft.Dynamics.Performance.Deployment.Reporting.ReportingDatabase.DeployDatabasePackages(String connectionString, String databaseName, Dictionary2 parameters)
at Microsoft.Dynamics.Performance.Deployment.Reporting.ApplicationServiceDeploymentPart.DeployWithSettings(IDictionary2 settingsToDeployWith) at Microsoft.Dynamics.Performance.Deployment.Console.ConfigurationConsole.Wizard.Screens.DeploymentViewModel.TryRemoveFromView(Boolean isProgressing)
See

Solution:
Before starting the MR, you have to check SQL server version. Hence the root cause of the above error is version compatibility. Ref version summary here

So, you have to download CU9 from your customer source which is support to SQL server 2014. Ref here still the error persist.

Cheers!

February 18, 2015

Travel to my hometown!

February 6, 2015

Script to disable list, libraries from SharePoint crawler

This script will disable all list and libraries from search result in the site collection.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
$site = Get-SPSite http://spapplication 
$site | Get-SPWeb -Limit ALL | ForEach-Object {   
    foreach ($list in $_.lists) 
    {                  
                $list.NoCrawl = $true
                $list.Update()
    }
}
$site.Dispose()

1

2

3

4

5

6

7

8

9

10

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$site = Get-SPSite http://spapplication

$site | Get-SPWeb -Limit ALL | ForEach-Object {

foreach ($list in $_.lists)

{

$list.NoCrawl = $true

$list.Update()

}

$site.Dispose()

You can disable it from list/library’s advanced settings. If numerous lists then the script will make it easier.

January 8, 2015

PowerShell script to delete files from list and output list of deleted file

Delete files listed in CSV the PowerShell script will read and clean it up from physical location.

$Termed_Users = “C:\Data\Termed_Users.csv” 
$Home_Folders = “X:”
$UserList = Import-Csv $Termed_Users

$UserList | ForEach-Object {    
   $ID = $_.ID  
   $User_Home = $Home_Folders + “\” + $_.ID
   Remove-Item -recurse -force $User_Home -erroraction silentlycontinue 
}

1

2

3

4

5

6

7

8

9

$Termed_Users = “C:\Data\Termed_Users.csv”

$Home_Folders = “X:”

$UserList = Import-Csv $Termed_Users