Search results

I'm still in the middle or adding servers to a multi-configuration setup, and other than the error I ran into earlier, requiring EXECUTE permissions on sp_ssis_getfolder, I enocuntered another error today: To enable this option, on the target server, the 'Agent XPs' option has to be turned...

Here's a fun little thing if you are into fonts, and customizing your tools. It is possible to change the default font used in SQL Server Management Studio (SSMS). Not only can you change the font used, or the size of the font, but if you would feel inclined to do so, you could even change the...

After installing SSRS, some additional configuration is necessary to get things working. Once that is done, it is time to assign proper permissions for the ReportServer folder on the SSRS. If you do not do this, you will just be greeted with an "Access denied" error. When you are logged onto...

In SQL Server Reporting Services (SSRS), there are several default types available that can be used as a data source. In this article I want to show a list and a little explanation of the individual options. Data Source TypeDescriptionMicrosoft SQL AzureSQL Azure is a cloud-based service...

Database mail can be a very useful tool in case you administrate one or more SQL Servers, as you could configure the server to automatically send out mails upon completion (either succesful or failure) of jobs, to notify you of alerts you configure, etc. To configure Database mail, log onto...

While attempting to edit a job in SQL Server Management Studio (SSMS) on a SQL Server 2008 R2 installation (Version 10.50.1600 - Gold release, without any service packs), I started seeing the following error: The only workaround was closing down SSMS altogether, restarting it and then editing...

While configuring a new server for a multi-server administration setup, my SQL Server Agent refused to start, and it threw an error 0x800706be: One way to try and tackle this is running SQL Server Configuration Manager as an administrator (right-click it, and select "Run as...

When you attempt to enlist a new Job Server in a multi-server administration, the SQL Server Agent from the Master server by default needs to be able to encrypt its communications with the Target server. This can be accomplished by installing an SSL certificate, but another option would be...

In order to enlist a new SQL Server into a multi-server administration scenario, it needs a few things done first. SQL Server Agent needs to be running. If this is not the case, you will see the following error: SQL Server Agent needs to be running using a qualified network account. So...

Last week, I wrote a brief article on how to configure SQL Server 2008 R2 Database Mail. This brief article will use that configuration and use it to alert us of errors when a SQL Server Agent job fails, by means of an automated E-mail. To do so, right-click SQL Server Agent (The MSX suffix in...

Policy Management allows you to define conditions on servers , and then select how you want to enforce them. I'll write a quick article on how to configure and install policy management soon, but for now figured I would start a thread to document the different facets, fields and descriptions...

The Map control is by far one of the coolest controls in SSRS. Unfortunately, it only ships with the default US maps, and the rest of the world will have to add their own maps. Luckily, this is pretty easy to do. The biggest thing will probably be locating maps that contain spatial data that...

Today, I needed to rename a policy in SQL Server Management Studio (SSMS). However, it is not possible to do so using the GUI for some reason. The usual tricks to rename objects (highlighting the object and pressing F2, or right-clicking the object and selecting "Rename" from the drop-down...

I figured it would be nice to have a list of tools, guides and white papers that might come in handy when one starts playing around with SQL Azure. I'll try and keep this thread up-to-date. Tools The SQL Azure Migration Wizard allows you to migrate data from your existing SQL Server 2005 and...