Figure 3. Your SQL Database Servers. Next, you'll need to create the rule to allow one or a block of IP addresses. If you'd like just to let the public IP address you are coming from (if the computer ...

If you're able to telnet to port 1433, try opening the Microsoft Query Analyzer. Use the login combination you tried above to verify that a user name and password combination exists for your SQL ...

"After installing this update, apps that use ODBC connections through Microsoft ODBC SQL Server Driver (sqlsrv32.dll) to access databases might not connect," Microsoft explains.

This is when you need to focus on automation tools like Windows PowerShell. To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages.