Symptoms:
- Error message pops up in SixBit stating the database is not populated.
- Cannot select the database in the Open Database dialog box using SQL Authentication
- You can log into SQL Server Management Studio with Windows Authentication but not using SQL Authentication.
- A database exists on the SQL Server with only system tables in it.
Possible causes:
The Windows ODBC Driver is not installed for the version of SQL Server you are working with. Chances are that one of the following has happened:
- The 64-bit ODBC driver was installed, but not the 32-bit driver for whichever version of SQL Server you are working with.
- The ODBC driver was not installed at all during the upgrade.
Troubleshooting:
64-bit and 32-bit systems:
- Open Control Panel | Administrative Tasks | Data Sources. Click on the driver's tab.
- Check to see which SQL Server Native Client is installed. If your version's driver is missing, see the Solutions section of this document.
32-bit troubleshooting ends here, 64-bit continues on:
- Close the already open control panel if you have not already done so. (important! The next step will fail if you do not close the control panel)
- Start | Run | %systemdrive%\Windows\System32\odbcad32.exe (This opens the 32-bit ODBC control panel)
- Check that the 32-bit SQL Server Native Client for your SQL version is installed. If it is missing, see the Solutions section of this document.
Solution:
- Download the ODBC driver for your version of SQL Server and install it.
- SQL Server 2012: http://www.microsoft.com/en-us/download/details.aspx?id=36434
- SQL Server 2008 R2 32-bit: http://go.microsoft.com/fwlink/?LinkID=188400&clcid=0x409
- SQL Server 2008 R2 64-bit: http://go.microsoft.com/fwlink/?LinkID=188401&clcid=0x409
- Older versions: http://www.connectionstrings.com/download-sql-server-native-client/
Additional Information:
Common SQL Server version numbers include:
- 10.0 (SQL Server 2008)
- 10.5 (SQL Server 2008 R2)
- 11.0 (SQL Server 2012)
- See http://support.microsoft.com/kb/321185 for a full list if needed.
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.