"SQL Server Driver: Optional Feature Not Implemented"

Error Message:

[Microsoft][ODBC SQL Server Driver] Optional Feature Not Implemented.

Solution:

Use a DSN-less connection via OLE DB. 

  1. Log into FogBugz as an admin.
  2. Click on Site, top right.
  3. Half way down, where it says "Database:", click on "ODBC data source or connection string.
  4. Enter one of the following connection strings, using your own database server name, database name (a.k.a "Initial Catalog"), etc.

Example Connection Strings:

Trusted connection (Windows authentication):

Provider=sqloledb;Data Source=YOURSERVER;Initial Catalog=FogBugz;Integrated Security=SSPI;"

SQL Server Authentication:

Provider=sqloledb;Data Source=YOURSERVER;Initial Catalog=FogBugz;User Id=FogBugz;Password=asdasd;