Category Archives: Developer stuff

C#, asp.net and other things to do with development

How to create empty guid in SQL Server – c# Guid.Empty() equivalent

In dotnet you can create a new Guid by using the static Guid class like this (c# syntax) Guid g = Guid.NewGuid(); And you can create an empty guid like this Guid g = Guid.Empty; In SQL Server you can … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 1 Comment

SSRS report print button missing in IE11

If you use reporting services though a report viewer control then you might be missing the print button when viewing in IE11. To fix this, install the latest reportwiewer.exe. This will return the print button but annoyingly it also changes … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | Leave a comment

SSRS report hangs in IE11

If your SSRS report viewer’s “Loading” popup message never goes away (the report never renders) then chances are you have a reference to an image that does not exist in your report. I got this because I have a report … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | 1 Comment

SSAS / Excel 2010 – An error was encountered in the transport layer

Connecting to SQL Server Analysis Services from a remote domain / login When connecting to SSAS from a different remote domain / login using Excel 2010 where you have set up a windows user at the SSAS server, provided adequate … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | 7 Comments

The SQL Server instance specified in SSIS service configuration is not present or is not available

If you get this error when you are trying to expand the MSDB section in SSIS and your target SQL Server is clustered then this is probably because the default reference to an instance of SQL Server in the SSIS … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | 3 Comments

Attaching the Script debugger to process ‘[5836] iexplore.exe’ on machine ” failed. A debugger is already attached.

If you get this error message when running a c# application in Visual Studio 2010 by pressing F5 (Start Debugging) then the chances are you have multiple browsers installed and this has caused problems with the debugger. ————————— Microsoft Visual … Continue reading

Posted in Developer stuff | Leave a comment

SharePoint startup time very slow

I created a SharePoint Server installation to look after project documentation. All was well and I uploaded all of the specifications, design documents, project plans etc. The following day, when I wanted to show the site to someone important, it … Continue reading

Posted in Developer stuff, Operating Systems, Other stuff | Tagged , , , | 3 Comments