SQL Server
How to back up a SQL Database
Overview Backing up a SQL database is useful when migrating SQL server, needing to send a copy of the database to someone, or simply backing up the database to restoration purposes. Requirements SQL Server Managment Studio SQL Credentials or Windows ...
Firewall Exceptions for SQL Server
Overview SQL Server uses both TCP and UDP ports for communication. It is necessary to allow these ports through the firewall. TCP Incoming Ports 1433 4022 135 1434 UDP Incoming Ports 1434
Troubleshooting a SQL Server Connection
Overview If you are unable to connect to a SQL database, you can perform what's called a UDL test which uses a built-in SQL Server OLE DB provider to test SQL connections. This is done independent of any software application and is a great ...