Windows blue screen fix

I was looking for a free hosted service of Microsoft Team Foundation Server to have version control for my Visual Studio software projects.

I found out, that Microsoft itself offers a free plan for up to 5 users under: http://tfs.visualstudio.com/

I recently updated to Visual Studio 2012 Ultimate.
When i tried to open an existing SQL Server SQLCLR Project (*.sqlproj), it says that the sqlproj is incompatible with the version I am running.

How-i-fixed-it:
I installed the SQL Server Data Tools from http://msdn.microsoft.com/en-us/data/tools.aspx.

I found the solution here:

http://stackoverflow.com/questions/11906691/visual-studio-2012-csproj-and-sqlproj

and here:
http://www.comoke.com/index.php/2012/10/visual-studio-2012-database-project-sqlproj-project-type-not-supported/

and here:
http://blog.tentaclesoftware.com/archive/2013/02/11/visual-studio-2010-and-2012-sqlproj-interoperability.aspx

One of my C# SQLCLR table valued function started to throw an exception with some recently added data to the database:

SQL Server Message 6260
system.overflowexception Arithmetic Overflow

How-i-fixed-it:
It turned out to be caused by a divison by 0 happening at runtime because of bad records in the data. I added some code to check for this which fixed the problem of the arithemtic overlow.

I wanted to connect my Windows 8 calendar, mail and contacts app to my companys OpenXChange-Server.
How i fixed it:
Like described in: http://software.open-xchange.com/OX6/doc/BusinessMobilityOXtender/OX6-OXtender-for-Business-Mobility-English.pdfi found out, that it works like this for Windows 8 as well!
Windows Phone 7 includes a pre-installed Exchange ActiveSync client, with which you can synchronize your emails, contacts and appointments between your mobile phone and the Groupware Server.
Note: This guide refers to a non-modified version of Windows Phone 7. The icons and names on your mobile phone may be different from this guide. In this case, refer to your mobile phone documentation or ask your cell phone provider.
How to configure your Windows Phone 7 mobile phone:
1. In the main menu, select the right arrow icon or scroll to the left to access the application list.
2. Select Settings. Choose email & accounts.
3. Select add an account. Select the Outlook account type.
4. Enter the E-Mail address you use for the Groupware Server. Enter the password you use for the Groupware Server. Note: The entries are case-sensitive. Select sign in. 5. Enter your access data (username and domain) for the Groupware Server. If your username contains the @ character, enter the characters preceding @ in the Username field, the characters following @ in the Domain field. Example: For the username mike@ox.io enter mike as user and ox.io as domain. If your username does not contain the @ character, enter the username in the Username field and defaultcontext in the Domain field. Select Sign in.
6. A notification message is shown. Select Advanced. On the next page select show all settings.
7. Enter the server name (hostname, FQDN) of the Groupware Server in the Server field. If your server uses encryption, enable Server requires an encrypted (SSL) connection.
8. Check the settings. Select sign in. Result: Your mobile phone is configured to use the Grouwpare Server. The initial synchronization automatically starts immediately. Depending on the data volume and the network connection, the first synchronization might take a while.

Recently I changed the password of my WebDav-Account. After that, Outlook stopped to publish my calendar to the Server. I tried to re-publish the calendar, but Outlook did not prompt me for the username / Password and still told me "Login failed".

How-I-fixed-it:
I went to system control -> user accounts -> credential manager -> windows logon credentials
There i found the setting "MSOutlookGeneric - MyWebDavServer". Open the tab and use "edit" to Change the credentials or delete the entry to let Outook prompt you for the login credentials again.

In German / Deutsch:
In der Systemsteuerung findet sich unter Benutzerkonten -> Anmeldeinformationsverwaltung -> Windows-Anmeldeinformationen "MSOutlookGeneric - MeinWebDavServer". Den Tab ausklappen unter unter "Bearbeiten" das Passwort eingeben.

I was looking for a way / description how to upgrade an existing SQL Server 2000 database to SQL Server 2012.

How i fixed it:
SQL Server 2000 database has to be upgraded to 2005/2008 first.

If found the right hints how to do it in the SQL Server Forum here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ab5617e-0644-4434-96af-ebc04ba89f75/upgrading-from-sql-2000-to-2012-how

The procedure is described well in this document:
http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf

It says (page 241), that i have to first upgrade the database from 2000 to 2005/2008 and then to 2012.



 

I had a really nasty crash on my Exchange 2007 server the other day.
Here is the Technet "Disaster Recovery Procedures" to help you fix a crash:
http://technet.microsoft.com/en-us/library/aa998890(EXCHG.80).aspx

I was able to use the recovery tools to fix the databases, but OWA and IIS were toast.
You can recover your database with Eseutil /R (Recovery Mode).
See help here:
http://technet.microsoft.com/en-us/library/bb123479(EXCHG.80).aspx

One of my first issues was to repair WMI. That worked fine, but then IIS was still damaged.
Here is a batch script that i found that fixes that:

net stop winmgmt
c:
cd %windir%system32wbem
rd /S /Q
repository
regsvr32 /s %systemroot%system32scecli.dll
regsvr32 /s
%systemroot%system32userenv.dll
mofcomp cimwin32.mof
mofcomp
cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in (’dir /b
/s *.dll’) do regsvr32 /s %%s
for /f %%s in (’dir /b *.mof’) do mofcomp
%%s
for /f %%s in (’dir /b *.mfl’) do mofcomp %%s
mofcomp
-n:rootcimv2applicationsexchange wbemcons.mof
mofcomp
-n:rootcimv2applicationsexchange smtpcons.mof
mofcomp
exmgmt.mof
mofcomp exwmi.mof
net start winmgmt

Then I had to fix the transport database. See help here:
http://technet.microsoft.com/en-us/library/bb217853(EXCHG.80).aspx

The next step was to remove and re-install IIS and then reinstall the CAS role and use the Exchange shell to re-install OWA and ActiveSync.
Technet help on that here:
http://support.microsoft.com/kb/320202

None of this worked, and my OWA and ActiveSync are still down.

Im using the Test-OwaConnectivity cmdlet to test the OWA that I have now:
http://technet.microsoft.com/en-us/library/aa997682(EXCHG.80).aspx
It tells me this:
The test was unable to establish a connection to Outlook Web Access.
Not very helpful.

OAB (Address book) seems to work, so I dont think its IIS.

I did find two technet MVPs that say that if you screw up IIS on Exchange 2007 that you may as well just format the box and start over. Great....

Ill post more as I go along.