If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist below to quickly find, and fix ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Errors are sent to another table, rather than disrupting the whole process. (Click image to view larger version.) As you can see in Fig 4., the errors have been redirected.