Profile cover photo
Profile photo
Lane Duncan
58 followers
58 followers
About
Lane's posts

Post has attachment
Using SSRS ReportServer database in SQL Multi-Subnet Availability Group
Using SSRS report data sources on a SQL Availability Group that is behind a multi-subnet listener is supported, and it mostly works.  Having the SSRS ReportServer database on a multi-subnet AG, however, isn't supported, as detailed here .  To wit: The use o...

Post has attachment
Using powershell to call arguments with no spaces
Sometimes you have an application (like 7 Zip) that uses command line switches without a space between the switch and the value.  If you're using a variable for the value, sometimes PowerShell won't parse the values out right, so the thing will fail. In thi...

Post has attachment
PowerShell exit codes, or "Why does SQL Server think my PowerShell script succeeded?"
If you search for PowerShell logging, or PowerShell output, you'll find lots of folks who are frustrated by PowerShell's error handling and logging capabilities. It turns out, they're pretty robust, but because PowerShell has separate error and standard out...

Post has attachment
Powershell Invoke-Webrequest error "Internet Explorer engine is not available"
We encountered the following error in an SSIS job that launched a PowerShell script, and the job was executing (we thought) successfully.  There was, though, zero output.  A couple of things going on here, then. First, the error: The response content cannot...

Post has attachment
Fighting sp_send_dbmail error: "Failed to initialize sqlcmd library with error number -2147467259."
We recently encountered a bunch of problems with sp_send_dbmail, and they all returned this: Failed to initialize sqlcmd library with error number -2147467259. Super irritating, that error, because it seems to suggest that you're doing something you're not....

Post has attachment
Paste SQL (and other) text into OneNote with syntax highlighting (really)
I've been searching for a way to get SQL scripts into OneNote while retaining syntax highlighting from SSMS for a long time now. It's seems unnecessarily hard: OneNote doesn't support RTF-formatted text from the clipboard, which shouldn't be a problem, si...

Post has attachment

Post has attachment
I'm sure going to try to get back to posting more frequently. Here's the latest on using extended events to check for user database activity.

Post has attachment
SQL Server Reporting Services Service Start Timeout
SSRS will often timeout when starting under Windows Server: The error is:  Windows could not start the SQL Server Reporting Services (MSSQLSERVER) service on local computer.  Error 1053:  The service did not respond to the start or control request in a time...

Post has attachment
Creating a Self-Signed SSL Certificate in Windows without IIS (for SSRS, for instance)
Sometimes you have need for a SSL certificate on a Windows server when you don't have IIS installed.  Like when you want to install SQL Server Reporting Services (SSRS). You could use OpenSSL, or download the 1+GB Windows SDK to get the makecert utility .  ...
Wait while more posts are being loaded