CREATE DATABASE permission denied in database "master". An attempt to attach an auto-named database for file XXX failed.

i was having issue on asp.net 4.0 website on windows 2008 R2 server ,CREATE DATABASE permission denied in database ‘master’. An attempt to attach an auto-named database for file XXX failed.

i did some search on internet and then came to know that we need to give site access to netwrok user  as application was running under network service user (in default application pool) , i did tried to do so but error was not removed , then i just changed the user from network to local system in application pool and it started work without any issue.

Biztalk : Error Threshold on Receive Locations and receive location disabled automaticaly

we have one receive location of type SQL in our Biztalk Application on productin server and it got disabled after some days and logged an error in event log  like that "Threshol on Receive Location"

it was very annoying for us to enable it manually and we were not be able to find the root cause of this problem, then after some R&D i have come to know that

Biztalk keeps polling sql server after  every x milliseconds. In some cases its configurable. For some adapters its not.

we have error threshold value set to 5 , mean after 5 continous error from sql server the receive location would be disable as Microsoft says about Error Trhreshold :

The Error Threshold is used to specify the maximum number of continuous errors received before disabling the receive handler.

so when for some maintaine work or with due ot any other reason if sql server is down and Biztalk got 5 continous error from sql server then it disabled the receive location and put some error in log related to threshold.

so what we did just change the value of ErrorThreshold from 5 to 500 and restart the host instance then we did not face this issue again.

Biztalk Error X2044 : symbol Object is already defined; the first definition is in assembly c:\###.dll

Yesterday I was hacing an error  in Biztalk 2010  ,

symbol '###' is already defined; the first definition is in assembly c:\###.dll , in my case it was saing that a porttype is alrdeay defined, so what how to fix these kind of issues in biztalk. error x2044

1. Open the orchestration in Notepad (In my case SchoolOrchestration.odx)


2. find (Ctrl+F) for “#endif // __DESIGNER_DATA”


3. Delete all the code below that line


4. Save your file in Notepad


5. Say yes when Visual Studio asks if you want to update your file


6. Recompile

that's it .

Source : http://biztalkia.blogspot.com/2005/12/solving-biztalk-error-x2044.html

iIS 7.5 error: HTTP Error 500.21 - Internal Server Error Handler PageHandlerFactory-Integrated has a bad module ManagedPipelineHandler in its module list

if you found the following error on IIS 7.5 while opening asp.net 4.0 application

iIS 7.5 error: HTTP Error 500.21 - Internal Server Error Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list

then run these commands to install asp.net 4.0 to fix the issue

%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i

%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i

Biztalk 2010 service not started after windows restart in windows 2008 server R2

To resolve this issue, configure the Enterprise Single Sign-on service and each BizTalk Service service to use the Automatic (Delayed Start) startup type. To do this, follow these steps:

1. Click Start, type services in the Start Search box, and then select Services in the Programs list. If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.


2. Under Name, right-click Enterprise Single Sign-on Service, and then click Properties.


3. In the Startup type box, click Automatic (Delayed Start), and then click OK.


4. Under Name, right-click a BizTalk Service service, and then click Properties.


5. In the Startup type box, click Automatic (Delayed Start), and then click OK.


6. Repeat steps 4 and 5 for any remaining BizTalk Service services.

Source : http://support.microsoft.com/kb/942284

Round /Turncate numeric values in xslt

To round a numeric value to some specific decimal places in xslt , we need to code like this.

<xsl:value-of select="format-number(price,'#.####')"/>

if price value is 11.5246956 then it would round to 4 decimal places and result would be 11.5247

if price value is 11.25 then it would round to 4 decimal places and result would be 11.25 not 11.2500

what if we want to round to 4 decimal places and also want to show 11.25 to 11.2500 then need to use the following code.

<xsl:value-of select="format-number(price,'#.0000')"/>

it would round to 4 decimal places and every value that has less then 4 decimal palces will be shown by appending 0 to left. e.g if price value is 11.25 it will show to 11.2500

and some cases we don't need to round value to specific values we just need to truncate it by 4 decimal places , for exapmle  if price value is 11.5246956 and want to show it 11.5246 just up to 4 decimal places but no round then following code can be used.

<xsl:value-of select="format-number(concat(substring-before(price,'.'),'.', substring(substring-after(price,'.'),1,5)),'#.00000')"/>

How to change a column name in sql server using t-sql.

here is the way to change a column name in t sql
EXEC sp_rename @objname = 'tablename.oldcolumnName', @newname = 'newcolumnName',@objtype = 'COLUMN'

reference : http://msdn2.microsoft.com/en-us/library/ms188351.aspx