Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database. This article is a follow-up to one I wrote in August 2017, "How To Set Up a SQL Express ...

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Fix SQL Server connection problems 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 ...

Connecting to a remote SQL Server Express instance using SSL and regular username/password fails. Multiple SSL configurations (self-signed certificate, "Trust Server Certificate" toggles) were tried, ...