Hi All,

Sometimes, in BizTalk server environments, we need to check the DLL based on length. Below is the sample script for that.

At the end, it will generate CSV file that contains the mismatched DLLs.

$Filepath = Split-Path -parent $MyInvocation.MyCommand.Definition

$output = $Filepath + "\output.csv"

$Sourceserver = ‘SourceServer’ # Source Server

$DestServers = "DesinationServer1","DesinationServer2","DesinationServer3" # Desination servers that needs to GAC DLL comparison

$GACFolders = "C:\Windows\Microsoft.NET\assembly\GAC_MSIL","C:\Windows\assembly\GAC_MSIL" # these are the GAC folders that needs to be used for comparison.

$AssembliesList = @()

$DiffAssemblies = @()

$ServerAssemblies = @()

foreach ($Server in $Sourceserver)

{

foreach ($gacfolder in $GACFolders)

{

$ScriptBlockContent = {

param ($Folder)

get-childitem -Path $Folder -filter ‘*.dll’ -Recurse |select name,length,fullname }

$AssembliesList += Invoke-Command -ComputerName $Server -ScriptBlock $ScriptBlockContent -ArgumentList $gacfolder

}

}

function getsizeDiff

{

foreach ($Dserver in $DestServers)

{

$ServerAssemblies = @()

foreach ($gacfolder in $GACFolders)

{

$ScriptBlockContent = {

param ($Folder)

get-childitem -Path $Folder -filter ‘*.dll’ -Recurse |select name,length,fullname }

$ServerAssemblies += Invoke-Command -ComputerName $Dserver -ScriptBlock $ScriptBlockContent -ArgumentList $gacfolder

}

foreach ($sAssebly in $ServerAssemblies)

{

$AssembliesList | Where-Object { $_.fullname -eq $sAssebly.fullname } |ForEach-Object {

if ( $_.length -ne $sAssebly.length)

{

$DiffAssemblies += [pscustomobject] @{

ServerName=$Dserver

AssemblyName=$sAssebly.name

AssemblyFullName=$sAssebly.fullname

Size=$sAssebly.length

}

$DiffAssemblies | Select-Object -Property ServerName,AssemblyName,AssemblyFullName,Size -Unique | Export-Csv -Path $output -NoTypeInformation

}

}

}

}

}

getsizeDiff

Regards,

Chaitanya

You can download Sql server management studio component. This was the new feature that was separated from Sql product which has the functionalities that supports azure features.

https://msdn.microsoft.com/en-us/library/mt238290.aspx?f=255&MSPPError=-2147217396

Regards,

Chaitanya

IIS web server installation

installing iis role: –

go to Server manager, It can connect to remote computers.

After opening the server manager

Go to roles-> add roles

Check the iis web server windows feature

after that check the sub features what you want

After installation completed, check the futures in the server manager and iis web server and right click on the iis webserver and select add role services

her you got the list of sub features for the iis

under the web server

web server (Installed)

-> Common http features

->static content– non executable code like ads

->default document–when u go to microsoft.com u will go to microsoft.com/default.aspx i.e. called default document

-> Directory browsing: directory structure: most web sites not installed this. if you don’t need this one… then don’t install it

->Http errors: we can place the custom errors page instead of 401 errors

->http redirection: redirect the url

->Web DAV (distributed authoring and versioning) publishing: used to send the files to web server using the http protocol… it is not recommended.

-> Application development– here executable code is placed

->asp.net– for this u need to have .net framework installed on server, for deploying the .net application

->.net extendibility: write the .net extensions

->asp- for ASP apps, we need to install, else no need

->CGI: use for web server extensibility. it is interface between IIS and programming languages, they used the CGI script. it is having performance issues

->ISAPI Extensions:

->ISAPI filters: ISAPI is faster than CGi and it is MS one

-> server side includes: dynamically inserting html pages to website pages before it sends to client, but asp,asp.net have this functionality default

And it is used when static content is used

Server side includes: is having some performance issues

-> Health and diagnostics– for troubleshooting the web site

->Http logging–it logs the web site activity in text file. most of sites are using this one only.

->custom logging: it will logs based on programming done. no need.

->odbc logging: it will log in the DB.

->logging tools: it will manage the web server logs and automate logging tasks

->Request monitor: it monitors websites health and performance. it has the details of http request inside the worker process

we can use the this monitor which http request is process is slow

->tracing: it is used for the diagnostic and trouble shoot the web apps.. with failed request tracing u can troubleshoot events like poor performance, authentication failures.

-> Security– most of them are for authentication

->basic authentication: it is used for internal networks, not for the public networks, main disadv is the credentials (clear text) transferred over this is very easy to decrypt

if you website is not using the https…it is like getting the dialogue box and asking the credentials

->windows authentication: used for internal websites. for windows domain. don’t use it for users that are accessing the website beyond the firewalls or using the proxy servers

-> digest authentication: works by sending the password in hash format over windows controller domain, it will give more security that basic authentication for users that are accessing the website beyond the firewalls or using the proxy server

->client certificate mapping: uses client certificates to authenticate users. client certificate is digital id from the trusted source

IIS offers 2 types of mapping: this type offers one to one certificate mapping across multiple web servers

-> IIS client certificate mapping: this one is more performance and IIS offers here one to one and many to one certificate mapping. If your website is not having authentication, no need of installing all the above authentications

-> URL authorizing: preventing the users from accessing the web content by binding the rules to the users, groups, http verbs

-> Request filtering: take all request and filer it based on rules set by administrator and send it to server

-> IP address and domain restrictions: used to set certain IP address only hit or certain IP address will not hit the server.

-> Performance:

->Static content compression: compressing the static web pages, so that CPU have more band width and iis will keep it in cache

->Dynamic content compression: not recommended

->Management tools:

->IIS management console

->IIS Management scripts and tools

->Management service: it should be installed so that other that server can be IIS web connected remotely and managed

-> IIS 6 Management compatibility:

-> IIS mat abase compatibility

->IIS 6 WMI compatibility

->IIS scripting tools

->IIS 6 management console

don’t login into server and manage the iis and manage it remotely

-> FTP server:

for windows server 2008 RTM, iis 7 has the ftp 6.0 version, after that they release ftp7.o version for iis 7.0

-> FTP service

-> FTP extensibility:

> IIS Hostable web core: it is the dll file used by application developers in their application

Installing IIS through script

http://technet.microsoft.com/en-us/library/cc771209.aspx

Regards,

Chaitanya

Hi All,

When we tried to update the https url in send port with wcf-webhttp adapter in BizTalk, I got the below error.

After troubleshooting, we found that security mode in security setting is set to none.

It should be set to transport. Then we can able to configure the https url in the send port with BizTalk wcf-webhttp adapter.

Regards,

Chaitanya

Hi All,

Please find latest BizTalk Server 2013 Performance Optimization Guide. BizTalk Administrators must have this document for troubleshooting the performance issues.

https://msdn.microsoft.com/library/dn775063(v=bts.10).aspx

Regards,

Chaitanya

Hi All,

Please check for download instructions of CU8 for- BizTalk Server 2010 in below link.

https://support.microsoft.com/en-us/kb/3081737

Regards,

Chaitanya

Hi All,

Below is one of the procedure in PowerShell to populate GAC information from servers to Database.

First create one database and one table for storing the servers GAC assemblies

CREATE DATABASE testdb

go

USE [testDB]

GO

/****** Object: Table [dbo].[gacassemblies_test] Script Date: 9/9/2015 5:54:45 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[gacassemblies_test](

[servername] [varchar](50) NULL,

[AssemblyName] [varchar](max) NULL,

[AssemblyVersion] [varchar](max) NULL,

[AssemblyUpdatetime] [varchar](50) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

Once you have created Database and table in which you want to store the assemblies from your group of servers. Below is the powershell script for getting GAC assemblies from given location.

Create a text file that contains server information like below. Don’t make any spaces in the file.

# Power Shell Script

$Output = @();

function truncatetable

{

$conn.open()

$cmd.commandtext = "Truncate table gacassemblies_test"

$cmd.executenonquery()

$conn.close()

}

truncatetable

function Get-AssemblyVersionNumber($assembly)

{

$Assemblydetails = [System.Reflection.Assembly]::Loadfile($assembly)

$AssemblyName = $Assemblydetails.GetName()

$Assemblyversion = $AssemblyName.version

return $AssemblyName

}

$location="C:GAC_Server"

$server=gc "$locationserver.txt" # to give servers information

$path = ‘c$WindowsMicrosoft.NETassemblyGAC_MSIL’ # to get .Net 4 Assemblies

foreach ($sr in $server)

{

$Output=$null

$Output = @();

$Dll= Get-ChildItem "\$sr$path" -Recurse | where {$_.extension -eq ".dll"}

Foreach ($f in $Dll)

{

$assembly=$f.FullName

$gacassembly= Get-AssemblyVersionNumber $assembly

$Output += $gacassembly

}

#$Output | Export-csv $OutputFilePath -NoTypeInformation

$conn = New-Object System.Data.SqlClient.SqlConnection

$conn.ConnectionString = "Data Source=localhost;Initial Catalog=testdb;Integrated Security=SSPI;"

$cmd = New-Object System.Data.SqlClient.SqlCommand

$cmd.connection = $conn

Foreach ($outputrecord in $Output)

{

$conn.open()

$cmd.commandtext = "INSERT INTO gacassemblies_test (servername,AssemblyName,AssemblyVersion) VALUES(‘{0}’,'{1}’,'{2}’)" -f $sr,$outputrecord.Name,$outputrecord.Version

$cmd.executenonquery()

$conn.close()

}

}

Copy PowerShell script into notepad and save it with ps1 extension. And also servers information in server.txt file.

Run the PowerShell script using PowerShell ISE or PowerShell command prompt.

You will get all the assemblies from servers to database.

Regards,

Chaitanya

Hi All,

We need the event ids to be generated to event viewer for troubleshooting purpose. SCOM agent recognizes the event id in event viewer and raise the alert. It generally happens in distributed systems.

We can accomplish this task in Sql server using 2 ways.

1. Raise error with log

EX: RAISERROR (‘Test Severity 16’, 16, 1) WITH LOG

2. xp_logevent event method

Ex : EXEC master.dbo.xp_logevent 60000, ‘Test message’, informational

Issue with above methods are they only raise the error numbers in the event viewer and they can’t do custom event ID in event viewer.

Whatever the event ids that you were seen in above screen shots are related to generic Sql server events.

In order to raise the custom events , as of now use the power shell to raise. Below is the PowerShell snippet for that.

write-eventlog System -source Server -eventid 12345 -message "I am a custom event log message"

Regards,

Chaitanya