Tag Archives: SQL Server

SQL Server 2005 The full-text search service cannot start

After you install SQL Server 2005 RTM on windows server 2008, the full-text search service cannot start. This is because the full-text search service depends on the NTLMSSP (NTLM Security Support Provider) service but the NTLMSSP service does not exist on Windows Server 2008.

To resolve this problem, simple install SQL Server 2005 SP3

SQL Server 2005 SP3 can be downloaded from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4

SQL Server Version History

By default you can’t restore a sql backup that was taken from a higher version sql server. Otherwise you might get following error when doing restore.

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2714. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server

SQL Server version can be checked by running following sql query

SELECT @@Version

SQL Server Version History Tracking Table

Version SQL Server Release
12.00.2000.8 SQL Server 2014 RTM
11.00.3000 SQL Server 2012 SP1
11.00.2100.6 SQL Server 2012 RTM
10.50.4000 SQL Server 2008 R2 SP2
10.50.2500 SQL Server 2008 R2 SP1
10.5.1660.1 SQL Server 2008 R2 RTM
10.00.5500 SQL Server 2008 SP3
10.00.4000 SQL Server 2008 SP2
10.00.2531 SQL Server 2008 SP1
10.00.1600.22 SQL Server 2008 RTM
9.00.5000 SQL Server 2005 SP4
9.00.4035 SQL Server 2005 SP3
9.00.3042 SQL Server 2005 SP2
9.00.2047 SQL Server 2005 SP1
9.00.1399.06 SQL Server 2005 RTM
8.00.2039 SQL Server 2000 SP4
8.00.0760 SQL Server 2000 SP3
8.00.0534 SQL Server 2000 SP2
8.00.0384 SQL Server 2000 SP1
8.00.0194 SQL Server 2000 RTM

[ODBC Driver Manager] Data source name not found and no default driver specified

If you run osql.exe utility on server that does not have SQL server installed, you might get following error: [ODBC Driver Manager] Data source name not found and no default driver specified.

This is because osql utility uses ODBC API to communicate to SQL server and SQL ODBC driver is not installed. To fix this, simple download and install SQL Native Client. For example, if you are using the osql.exe from the SQL 2008 (10.0), you should install the SQL Native Client 10.0 from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C