This is a learning track entry.
The author is Mark Long, and you can learn more about the product
here
- Welcome/Introduction: 2008-01-29
- Installing SQL Server 2005: 2008-01-29
- SQL Server 2005 and Express can coexist well on my machine. Both running in named instance. SQL2005 and SQLEXPRESS
- Administrative Tools: 2008-01-30
- sqlcmd -A don't work on my computer, here's the error message:
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
- SQL Server Security
- System Databases
- Databases
- Transaction Logs
- Data Storage
- SQL Profiler
- Automating SQL Server
- Database Backups
- Restoring Data
- High Availability
- Database Maintenance
- Course Wrap-Up
