Fast Guide

Fast Guide: Solving SQL Server errors

Stumped by a SQL Server error? Get help troubleshooting the problem right away. We've compiled a list of expert responses and best practices to help you solve errors that occur during various SQL Server processes, from backup and restore to installations and upgrades. If the error you're dealing with is not listed, or if your specific dilemma is not addressed, just

    Requires Free Membership to View

ask one of our experts for help and we'll add the response to this ever-growing guide of common SQL Server errors.

   Backup and restore errors
   Connection errors
   Conversion errors
   Copy and clone errors
   Installation and upgrade errors
   Log file errors
   Login and access errors
   Replication errors
   SQL errors
   Table errors

  Backup and restore errors Return to Table of Contents

  • Error restoring a database from production to a disaster recovery server
  • Database restore error in code
  • Getting failed Windows server back after boot device error
  • Backup error when dropping, inserting into or truncating a table
  • Error caused by corrupt block on disk
  •   Connection errors Return to Table of Contents

  • Sqldriverconnect error
  • Error with pull subscription connection from a remote server
  • Error connecting to Web-based application
  • Max connections-reached error
  • Error with SQL Server driver: Shared memory; connection open
  • Error when trying to connect IIS and SQL Server
  • Errors when submitting data from Web
  •   Conversion errors Return to Table of Contents

  • Getting type mismatch error converting string to date
  • Error converting varchar to numeric
  • Error converting Sybase data to SQL Server
  • Error converting char to datetime
  •   Copy and clone errors Return to Table of Contents

  • Error trying to copy new DLL over old one
  • Error 21002 cloning SQL Server 7 database solution
  •   Installation and upgrade errors Return to Table of Contents

  • Installing SQL Server 2000 on Windows XP
  • Problems trying to install SQL Server on a two-node cluster on SAN
  •   Log file errors Return to Table of Contents

  • Error about full tempdb log file
  • Handling a transaction log full error in T-SQL
  • Attaching a database that has missing log file
  •   Login and access errors Return to Table of Contents

  • Login fails for user 'myservernameaspnet'
  • Mismatched permissions errors after moving SQL Server
  • Operating system error when creating or opening a physical device
  • Problem trying to connect with the sa account
  • Login errors caused by memory problems
  • Can't log in with 'sa' and 'password'
  • Error running a stored procedure that references a remote server
  • Query works fine in Query Analyzer, but error via ASP
  •   Replication errors Return to Table of Contents

  • Error setting up replication across network domains
  • Error replicating data from Internet server to dial-up SQL server
  • Replication error between two standalone servers with same local and sa accounts
  • Error in "Not for replication" database
  • Error trying to drop linked servers
  •   SQL errors Return to Table of Contents

  • Maximum group value creating SQL syntax error
  • SQL statement error when trying to retrieve a DB2 date in Julian format
  • SQL syntax error when making a selection on boolean
  • Subquery error for select statement in DB2
  •   Table errors Return to Table of Contents

  • Missing keyword error when using ON DELETE and ON UPDATE on same table
  • Problem creating trigger to update reservations table
  • Foreign key must reference a unique key

  • More error-related resources rom

  • Ask the Experts: Don't see your error on this list? Ask our experts for help.
  • Tip: Using 'error handling' in stored procedures
  • Tip: Renaming foreign keys

  • This was first published in August 2005

    There are Comments. Add yours.

    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: