Thursday, December 2, 2010

The server principal "xyz" is not able to access the database "CMS" under the current security context. (Microsoft SQL Server, Error: 916)


Error:- 





TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "nwisuser" is not able to access the database "CMS" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

------------------------------

BUTTONS:

OK

------------------------------


 

Solution:-

  1. Display "Object Explorer Details" (F7) or "View –> Object Explorer Details




































    CLICK on Databases in left Pane.Right click the column headers and deselect "collation"








DONE .... Refresh Databases and start working

Wednesday, November 17, 2010

Cannot start Microsoft Office Outlook. Cannot Open the Outlook Window


Hi friends,
I ran into this weird problem this morning... after restart of my computer my Outlook express [Office 2007 on Windows 7 - 64 bit] won't start ...
Cannot start Microsoft Office Outlook. Cannot Open the Outlook Window

Following command helped me to solve it.... 
C:\Program Files (x86)\Microsoft Office\Office12>Outlook.exe /resetnavpane


Thursday, October 21, 2010

Visual Studio Error - The imported project file could not be loaded. Root element is missing.

I faced this problem... while I restarted my solution. (Not sure what I did wrong... may be my VPN was not connected and I was not able to connect to TFS) then it took my solution offline and then all this problem started.


Unable  to read the project file. The imported project file could not be loaded. Root element is missing.


Don't reinstall Visual Studio or even .NET framework.
What you have to do is delete the .user file for that project and it will work.

Friday, July 30, 2010

SSO Problem :- Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXX'. (SSO)

Problem: - Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXXX'. (SSO)

Reason / Cause: - This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server (SSOSQL.dll) does not specify the correct version of the .NET Framework.  When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load.

Solution: -
1.      Download ESSOv4-KB2252691-x64-ENU.exe from http://support.microsoft.com/kb/2252691 (Make sure that you download 64 bit or 32 bit depending upon your system)

2.      Install it on the BizTalk Server.

3.      Start Visual Studio Command Prompt

4.      Run C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe  "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"
(Make sure that you are referring to latest .NET framework RegAsm.exe)

5.      Now try Configuring BizTalk Server and Bingo you are done.


Wednesday, June 16, 2010

BizTalk 2004 - Failed to deploy Biztalk system assembly

I know... world is flat? I think it's round... I am back to BizTalk 2004 for one of my client.
Was installing and Configuring BizTalk Server 2004 on Windows 2003 Server.
Nearly everything was working good and at the last minute of configuration ... BTS gave this weird error.

 Failed to deploy Biztalk system assembly "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.DefaultPipelines.dll". Unspecified exception: Unable to generate a temporary class (result=1). 
error CS2001: Source file 'C:\WINDOWS\TEMP\7ff8w2-0.cs' could not be found.
error CS2008: No inputs specified.



Solution:- 
Give "Network Services" read and write access on this" C:\Windows\Temp" directory.


Problem solved.

Friday, March 5, 2010

Planning to write "Controlled BizTalk Admin"

Hi BizTalkers,
I am planning to start work on a Controlled BizTalk Admin tool.


This tool will be useful for the organizations which have "Shared infrastructure".
Suppose there two applications running on BizTalk Server "App1" and "App2". 
If you are business support person to "App1" then technically you need access for "App1" project and you don't need to see any message / orchestrations / ports from App2.
This Controlled BizTalk Admin will provide such ability.


If you are willing to contribute in any way... you are most welcome to send me email
hemant.bhadane@gmail.com


Keep up the good work friends...
http://biztalkca.codeplex.com/

FEEDJIT Live Traffic Map