sql-server Questions - FogBugz Knowledge Exchange

Move Database To New SQL Server Instance

2010-11-03T20:19:40Z

What has to change where in the Fogbugz 8 configuration when a database is moved from one SQL Server instance to another? Anything special needed to be done when the old DB is SQL 2005 and the new is SQL 2008?

(see this post for moving the FogBugz site)

Access: Converting your Access Database to Another Format

2009-10-13T20:12:54Z

Official Fog Creek Notice: MS Access support is being deprecated in FogBugz 8.0.

How do you convert an MS Access database to another format?

ERROR [IM002] Data source name not found and no default driver specified

2010-03-29T20:51:25Z

Hi all,

since this morning I am getting the above error. We set up the server just about a week ago and used it successfully until Friday. When I got in this morning it failed.

I checked the ConnectionString (as recommended)
ensured that SQL runs
verified user account and permissions
verified that logging in with that account and DB works
used database server's IP address instead of computer name

Then I thought upgrading to 7.1.18 might fix it. The upgrade included database upgrades that ran without trouble. Still, it wouldn't connect to our database afterwards.

Any ideas what could be wrong? Thanks

Case FC1869023

OLE DB Error: "Incorrect Syntax near the keyword DEFAULT"

2009-10-15T01:59:31Z

I'm getting the following error message:

Error Message:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'DEFAULT'.
/fogbugz/CBug.asp, line 127

What's the deal?

SQL Server: Importing data from FogBugz On Demand or trial into SQL Server

2009-10-13T21:24:26Z

How do I import data from my Fogbugz On Demand trial to SQL Server 2005 and 2008?

NB: FogBugz 7 does run on SQL Server 2000, but with limited functionality. We recommend 2005 or above.

How do I switch from Integrated Security to SQL Server authentication or back?

2009-11-12T02:34:15Z

The connection to the SQL server database is in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Fog Creek Software\FogBugz\[your FogBugz install directory]\sConnectionString

How do I alter this to switch between Integrated Security, which uses the FogBugz Windows user account to connect to the database, to SQL Server authentication, in which FogBugz has its own user account in SQL Server?

Error: "Not associated with a trusted SQL Server connection"

2009-10-15T01:50:27Z

I'm having trouble connectiong to my SQL Server database and get the following error:

Error Message

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'gbadmin'. Reason: Not associated with a trusted SQL Server connection

Error: Cannot Insert the value NULL into column '', table '';

2009-10-15T00:20:31Z

I'm getting the following error message:

Any help here?

Need some clarification

2011-06-07T14:15:08Z

Guys, I went to update to a newer version of FG & K 8 the other day but it told me I needed to install an SQL Server Component before I could continue.

Stupidly I never made a note of what that component was and I now need to start deploying it to our test / dev systems.

Can someone point me in the direction of the requirements for FB & K with MS SQL please?

The release notes don't really give any technical information...

MySQL: Moving database from SQL Server to MySQL

2009-10-13T22:02:41Z

How can I migrate my FogBugz database from SQL Server to MySQL?

Migrating from Access to MS SQL 2008

2011-03-08T23:54:45Z

I am attempting to update our Server running FogBugz 8 from using an Access database to using a MS SQL 2008 Database. Using the migration tool provided by Microsoft I have successfully imported all the data from the Access to the SQL database. When I attempted to login which the new database I get the login screen fine, enter the user name and password. When I click login however I get the Following error:

The INSERT statement conflicted with the CHECK constraint "SSMA_CC$FragmentCache$sValue$disallow_zero_length". The conflict occurred in database "fogbugz", table "dbo.FragmentCache", column 'sValue'.

The statement has been terminated.

The rest of the details are in this screen shot below:

Does anyone have any suggestions to fix this error?

How do I move from running FogBugz on MySQL to SQL Server?

2009-10-08T20:35:28Z

I'm running on MySQL now, but would like to run FogBugz on SQL Server 2008. How do I convert?

Trouble upgrading from SQL Server 2000 to 2005/2008.

2011-01-21T21:23:33Z

Whenever trying to attach our MSSQL 2000 database in MSSQL 2005 or 2008 I get errors. I tried this over 3 years ago and was unsuccessful, and looking to replace hardware, so this is going to have to work.

I have attempted this many ways: - Restore .bak into new 'blank' database. - Attempt to attach database from .mdf/.ldf - Using SQL integration services to import data from old server.

The data seems to be brought into the database, but it is unable to start the database. Sits there as (suspect).

I understand databases quite well, and am a Microsoft SQL Server DBA for many clients. This one is above me for some reason.

Restore failed for Server 'DB1-2003'. (Microsoft.SqlServer.SmoExtended)

System.Data.SqlClient.SqlError: RESTORE could not start database 'FB'. (Microsoft.SqlServer.Smo)

Migrating from SQL Server 2000 to 2008

2009-12-28T18:18:21Z

Are there any special instructions to migrate a FogBugz database from SQL Server 2000 to 2008. Any pitfalls to watch for?

What we thought we would do is create the 2008 instance on the same box as 2000 (this is a Server 2003 machine). Detach the database in 2000 and move it to the 2008 instance. Someone mentioned problems with the 2000 compatibility mode for databases in general though. Should we create a new database in SQL Server 2008 and import the data?

Once the data is moved, what do we have to do for FogBugz to find the new database server and database?

Looking for recommendations to make this transition go as smooth as possible.

Rick Schummer

Error: Directory name is invalid

2009-10-15T02:39:57Z

I'm getting the folling error message, what gives?

Error Message

"The directory name is invalid. SQL: exec sp_fulltext_catalog 'FogBUGZCatalog', 'create' Params:"

How do I shrink large SQL Server transaction logs?

2010-01-21T16:52:01Z

It's possible with some configurations of SQL server for the transaction logs to grow very large. This has even at times threatened disk space on some of our customers' servers! How do I use DBCC SHRINKFILE to shrink these logs down?

Access Upsizing Wizard: Beware

2009-10-13T22:22:33Z

Are there any issues with the Access Upsizing Wizard (moving a FogBugz database from Access to SQL server).

Moving server. Can't set DB owner

2010-11-09T09:13:08Z

Hi,

I just moved my FB (software + website + SqlServer 2008 R2 express DB) to a new server.

I followed the steps explained in this question except that I used SSMS and did a backup/restore rather than detach/attach. The problem is that when I restore the DB, SSMS doesn't allow me to specify the owner of the DB. Therefore the DB is created with sa as owner and the FogBugz Windows user can't connect to it. I temporarily solved it by specifying sa in the connection string (registry) but I'd like to fix that ownership (or permissions) issue.

Can anyone help (please assume I'm a newbie regarding SqlServer administration and security)

TIA,

SQL Server requirements

2010-10-28T19:30:08Z

Is there a SQL Server version requirement change in FogBugz 8? We went to install the upgrade today and it looks like this is the case. Is there a way to keep SQL Server 2000 and install FB8?

How can I extract numbers like "open tickets per project" or "new tickets per day"?

2010-10-16T14:27:31Z

In our MIS and Intranet I would like to display the following information:

Currently unsolved Tickets in Project X
Number of tickets newly created today in Project Y
Number of tickets solved today in Project Z

How can I get this information programmatically?

A HTTP request (against the fogbugz server) or an SQL query run on fogbugz MS SQL server would be preferred.

Is it possible to merge two existing FogBugz databases

2010-08-09T00:33:02Z

Is it possible to merge two existing FogBugz databases ? The first one is in MSAccess format and the one that we want to merge into is SQL Server. My first thoughts were that there would likely be conflicts in the keys between one db and the other if I tried to do it manually once I had upgraded the first instance to SQL. I don't suppose there is some sort of wizard that will merge two instances ??

Import project list

2010-06-24T15:43:27Z

I have a list of Projects and Areas from another application that I'd ideally like to just import into the FogBugz SQL db rather than having someone rekey. As an initial step, I just created a new record in Project on the SQL side - it does show up in the list for new cases, but doesn't show up in the project list in admin so obviously I am missing something. To what other tables beyond Project and Area would I need to add stuff for FogBugz to recognize an imported record as a valid Project?

Can I run SQL Server 2000 Standard and SQL Server 2008 R2 Express side-by-side?

2010-06-04T20:17:09Z

I'm running Microsoft Windows Server 2003 SP2 for Small Business Sever Premium Edition, which includes Microsoft SQL Server 2000 (Standard Edition, I believe). Since current versions of FogBugz require SQL Server 2005 or above, I'm considering moving to the free SQL Server 2008 R2 Express Edition.

Some other questions have partially addressed this but I'm wondering about some details.

Assuming my FogBugz database is smaller than the maximum size supported SQL Server 2008 R2 Express Edition, what steps should I follow to both install 2008 and migrate my data to it?

In particular, can I install 2008 R2 Express side-by-side with my existing 2000 installation? Do I need to worry about the 2008 installer trying to upgrade the 2000 installation since according to Microsoft, there is no supported upgrade path from Standard (paid) to Express (free)?

Assuming I can install 2000 and 2008 Express side-by-side, I assume I can migrate by following these steps. After I verify that the migration worked, can/should I remove the 2000 installation (I was only using it to run FogBugz)?

Which version of SQL Server 2008?

2010-05-18T22:45:35Z

Which version of SQL Server 2008 should we upgrade to?

We are upgrading from SQL Server 2000 on Windows Server 2003. Our database is currently around 4gb with 16 users. We also run Vault on this same server in the same SQL Server instance with 10 users.

My understanding is Express Edition has a size limitation, so I'm wondering whether FogBugz cares about any functional differences between Workgroup / Web / Developer / Standard / Enterprise editions, or does it even matter for our size and volume?

Installing SQL Server Express

2009-10-13T21:52:07Z

How do I install and configure SQL Server Express for use with FogBugz?

Error: Unable to Grant Login Permission (using sp_grantlogin)

2009-10-15T01:23:46Z

Error Message:

FogBugz Setup was unable to grant login permission to use the Windows account SERVERNAME\Fogbugz (using sp_grantlogin). Message: Windows NT user or group 'SERVERNAME\Fogbugz' not found. Check the name again.