Developer OneNote

Tag: 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