I have just installed this New SQL Server 2008 Ent on Windows 2008 and Applied SP1.
I get this strange error in the SQL Error log and event Viewer and was unable to connect:
Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process.
I checked that all the network protocols are enabled
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…