Developer OneNote

Tag: SQL Server

  • SQL Server 2005 The full-text search service cannot start

    —

    by

    devonenote
    in

    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…

  • SQL Server Version History

    —

    by

    devonenote
    in

    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…

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

    —

    by

    devonenote
    in

    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,…