Tag Archives: sql server

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

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

SSIS 2008 and SSIS 2008 R2 are the same (or are they?)

SSIS 2008 and SSIS 2008 R2 are the same Well pretty much. One big difference is that the ADO.NET Destination has been upgraded. Trouble is that the upgrade is tiny and SQL Server 2008 is not forwardly compatible. If you … Continue reading

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

Viewing cubes when upgrading to SQL Server 2012

This taken from “Behaviour Changes to Analysis Services Features in SQL Server 2012” Cube browser in Management Studio and Cube Designer has been removed The cube browser control that let you drag and drop fields onto a PivotTable structure in … Continue reading

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

Extraction from INFORMIX database using SSIS (Data warehouse ETL)

I have a customer for whom I am building a data warehouse solution using SQL server 2008. Source data comes in many forms including SQL Server 2000, SQL Server 2005, flat files (csv), Excel and Informix. SSIS handles connections to … Continue reading

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

Cannot connect to SQL Server from remote machine?

Check each of these… Make sure SQL Server is running on the target machine (SQL Server Configuration) Ensure TCP/IP is enabled (SQL Server Configuration) Ensure “Allow remote connections to this server” is enabled (SSMS server properties) Note default setting:  2005=disabled, … Continue reading

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