Tag Archives: 2008

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

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

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

Which DMV should I use?

Ever wondered which dynamic management view gives you information about xxxxx? e.g. you know that you want to find out which processes are currently blocking other processes (which was handled by the “blocked” column of “sysprocesses” in older SQL versions) … Continue reading

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

SQL Server 2008 Auditing – Database Audit

To create an audit you need to do the following Audit: Define where the audit data goes Audit Specification: Define what goes in to the audit Analyse: Find out what has been audited and view this in a meaningful way … Continue reading

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