Category Archives: SQL Server 2008

SQL Server Management Studio Not Allowing Table Changes That Require A Table To Be Dropped

Posted on 11th April 2012 by Ian Grieve

I was doing some work with a custom table yesterday and at one point needed to make a change to the table layout via SQL Server Management Studio. However, when I tried, I got the below error message;

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can

Continue reading →

Posted in Microsoft, SQL Server, SQL Server 2008 | Tagged , , , | 1 Comment

How To Deploy SSRS Reports In Microsoft Dynamics GP 2010 R2

Posted on 10th February 2012 by Ian Grieve

Earlier this week I did a post on how to configure SQL Server Reporting Services for use with Microsoft Dynamics GP. This is the follow up post where I’m going to explain how to deploy the SSRS reports for GP.

To deploy the reports you need to open the Reporting Tools Setup window (Tools >> Setup >> System >> Reporting Tools Setup) Continue reading →

Posted in Dynamics, GP, Microsoft, Reporting Services Reports, SQL Server, SQL Server 2008, SSRS | Tagged , , , , , , , , | 1 Comment

How To Configure SQL Server Reporting Services In Order To Deploy Reporting Services Reports In GP

Posted on 8th February 2012 by Ian Grieve

The post following this will cover deploying SSRS reports within Microsoft Dynamics GP but I thought I’d cover configuring SSRS as a spearate post rather than assuming everyone has it already configured. A number of the clients I deal with have had GP for a while and never installed the SSRS reports but are now doing so.

When you install SQL Server Reporting Services at the same time as SQL Server you have the option to automatically configure SSRS with the default settings. In the case of someone who has SQL already installed but didn’t install SSRS at the same time, this is not an option.

This How To starts after SSRS has been added to the installation on the client machine at the point where you would start to configure it; if you’d like a walk through adding SSRS to an existing installation of SQL Server, let me know and I’ll sort one out.

To do the initial configuration of SSRS, or to change the configuration of an existing installation, you need to start the Reporting Services Configuration Manager (Start menu >> Programs >> Microsoft SQL Server 2008 R2 ?? Configuration Tools >> Reporting Services Configuration Manager) Continue reading →

Posted in Dynamics, GP, Microsoft, Reporting Services Reports, SSRS | Tagged , , , , , , , , | 1 Comment

Restoring A Database Without Encountering A Locking Issue

Posted on 6th February 2012 by Ian Grieve

I periodically have problems when trying to restore a GP company database over the Test database as SQL reports that the database is currently in use.

One way of resolving is to restart the SQL Server but this is only possible on a stand alone test system which is not being used by other people but this approach is overkill.

The better solution is to change the database to single user, restore the database and change the database back to multiple user. This can be done manually through SQL Server Management Studio but is far easier done via a SQL script.

Continue reading →

Posted in Microsoft, SQL Server, SQL Server 2008 | Tagged , , , | 1 Comment

Error Code 2337 When Installing Microsoft SQL Server Into A Virtual Machine

Posted on 21st December 2011 by Ian Grieve

I have installed SQL Server into Virtual Machines many times in the past but I’ve recently seen an error when trying to do it again;

The following error has occurred: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337.

I had a think about the error and realised that I usually installed SQL from the VM HDD and not, as I was in this case, by attaching the iso image to the VM as external media. I uncompressed the iso onto the VM HDD and ran the installer again from this source and it installed without problem.

Posted in Microsoft, SQL Server, SQL Server 2008, Windows Virtual PC | Tagged , , , , , | 2 Comments

How To Change The SQL Server Backup Folder

Posted on 19th December 2011 by Ian Grieve

When you install Microsoft SQL Server you select the Data, Logs and Backup folder during the installation process. If you subsequently need to change these folders you can only change two of them through the SQL Server Management Studio UI. On the Server Properties dialog there are boxes for the Data and Logs default locations;

Server Properties

Continue reading →

Posted in Microsoft, SQL Server, SQL Server 2008 | Tagged , , , | 2 Comments

How To Rename A SQL Server

Posted on 16th November 2011 by Ian Grieve

Like some other posts recently, this one is the result of a conversation with a colleague at my new company, where I found they were unaware of something I took for granted; the ability to easily rename a comuter which has a stand alone instance of SQL Server installed.

I do this fairly often as I use quite a lot of Virtual Machines for testing different configurations, but I don’t want to have to build a new one every time, so I make copies of a base VM and rename it each time I want a new one (there is often more than one running at any one time and I want to avoid conflicts).

As well as renaming the machine inside the VM, I also rename the SQL Server to make sure it matches the name of the machine; I’ve had problems before with Microsoft Dynamics GP when I’ve not done so.

Doing this is actually very simple. Continue reading →

Posted in Dynamics, GP, Microsoft, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 | Tagged , , , , , | 2 Comments

Copy Microsoft Dynamics GP Live Company To Test Automatically

Posted on 11th November 2011 by Ian Grieve

Backing up the a Microsoft Dynamics GP company to test is, unfortunately, not as simple as backing up one database and restoring it to the Test one. There are two scripts which need to be run after doing so; the first changed the INTERID and Company Name and the second changes the database owner to dynsa.

At my last company, we decided to make this process as easy as possible for clients, so we started creating a SQL Agent Job which would do the backup, restore and run the scripts with minimal effort or could even run on a scheduled basis. The basic purpose was to give the client a test or training system which was always, or could very quickly be, up to date. Continue reading →

Posted in Dynamics, GP, Microsoft, SQL Server, SQL Server 2008 | Tagged , , , , , | 3 Comments

Selecting The Correct Microsoft SQL Server 2000 Collation For Microsoft Dynamics GP

Posted on 31st October 2011 by Ian Grieve

After initial acclimatisation pains with Microsoft SQL Server 2008 R2 (I largely skipped 2005 and 2008 RTM) I have become used to Management Studio and do now prefer it to Enterprise Manager and Query Analyser.

One of the things I really like about SQL 2008 R2 is the installation process where you pick the collation. Dealing with Microsoft Dynamics GP so much means I need to be careful with server and database collations as GP, once installed, cannot have it’s database collation changed.

We typically install SQL Server for Microsoft Dynamics GP using the SQL_Latin1_CP1_CI_AS (case insensitive, accent sensitive), which is very easy in SQL 2008 R2 Continue reading →

Posted in Dynamics, GP, Microsoft, SQL Server, SQL Server 2000, SQL Server 2008 | Tagged , , , , , | 2 Comments

Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview

Posted on 16th September 2011 by Ian Grieve

Microsoft Dynamics GP
Microsoft Windows 8Well, I’ve just finished installing SQL Server 2008 R2 and Microsoft Dynamics 2010 R2 on the Windows 8 Developer Preview and GP is exactly like it is on Windows 7. Continue reading →

Posted in Dynamics, GP, Microsoft, SQL Server, SQL Server 2008, Windows, Windows 8 | Tagged , , , , , , | 2 Comments