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"
2. 
   
   
   
   
   
   
   
   

DONE .... Refresh Databases and start working

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

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.

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.

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.

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/