Search results

If you check your MSSQL Server Error Log and encounter an error "Cannot use Large Page Extentions. Lock memory priviledges was not granted", it means you are running SQL Server 64 bit, but did not grant the account running it the privilege to lock pages in memory. Please see our article: 'How...

We all have to make changes to our tables every now and then. Columns might have to be added or removed, moved around within the table definition, made NULLABLE or not to accept NULLS, or perhaps the column definition originally built proves to be too conservative, and thus column lengths will...

In case you are running SQL Server on a 32 bit Operating System, you will by default only be able to have to allocate a maximum of 4GB of RAM, 2 GB of which will be reserved for the OS. In most cases, especially once the server gets busier, 2 GB might just not be enough to cut it, resulting in...

Today, while working on setting up a master/target server configuration which should enable me to define jobs on a single master server and then rolling them out to all other servers defined as targets, I kept running into a specific issue. I could easily execute the job created on the master...

When you want to connect to a SQL instance on your local machine (and let's assume it has been installed as the default instance), there's a few ways you can do so. The machine-name of the server (i.e. TESTSQL) localhost 127.0.0.1 (the IP address that defaults to "localhost") The actual IP...

Registered servers come in use when you find yourself regularly connecting to different servers on the network (for instance when, like yours truly, you are in a DBA position), and thus provide easy access to the servers. There are several ways to setup a registered server: Prior to...

Hi Shaikhu, and welcome to the forum. I would think that unless your supplier had malicious intent, and added some kind of backdoor into the system, you should be alright. However, that is of course not a definite answer, and unless you might find out more, it's fairly impossible to make an...

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...

Attempting to change the setting as described above might not be possible on your system off the bat if you did not turn on the ability to show advanced options.If this is the case, you will see the following error: Luckily, this, too, is easily done by issuing the command below...

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...