Operating System Error 1229 to Operating System Error 1248 for SQL Server
As a SQL Server DBA, there are various occasions where SQL Server returns Operating System errors as it causes some failure performing certain SQL Server operations. Below are Operating System Errors from Error 1229 to Operating System Error 1248
The Operating System Error 1229(An operation was attempted on a nonexistent network connection.)ERROR_CONNECTION_INVALID
The Operating System Error 1230(An invalid operation was attempted on an active network connection.)ERROR_CONNECTION_ACTIVE
The Operating System Error 1231(The remote network is not reachable by the transport.)ERROR_NETWORK_UNREACHABLE
The Operating System Error 1232(The remote system is not reachable by the transport.)ERROR_HOST_UNREACHABLE
The Operating System Error 1233(The remote system does not support the transport protocol.)ERROR_PROTOCOL_UNREACHABLE
The Operating System Error 1234(No service is operating at the destination network endpoint on theremote system.)ERROR_PORT_UNREACHABLE
The Operating System Error 1235(The request was aborted.)ERROR_REQUEST_ABORTED
The Operating System Error 1236(The network connection was aborted by the local system.)ERROR_CONNECTION_ABORTED
The Operating System Error 1237(The operation could not be completed. A retry should be performed.)ERROR_RETRY
The Operating System Error 1238(A connection to the server could not be made because the limit on thenumber of concurrent connections for this account has been reached.)ERROR_CONNECTION_COUNT_LIMIT
The Operating System Error 1239(Attempting to log in during an unauthorized time of day for thisaccount.)ERROR_LOGIN_TIME_RESTRICTION
The Operating System Error 1240(The account is not authorized to log in from this station.)ERROR_LOGIN_WKSTA_RESTRICTION
The Operating System Error 1241(The network address could not be used for the operation requested.)ERROR_INCORRECT_ADDRESS
The Operating System Error 1242(The service is already registered.)ERROR_ALREADY_REGISTERED
The Operating System Error 1243(The specified service does not exist.)ERROR_SERVICE_NOT_FOUND
The Operating System Error 1244(The operation being requested was not performed because the user hasnot been authenticated.)ERROR_NOT_AUTHENTICATED
The Operating System Error 1245(The operation being requested was not performed because the user hasnot logged on to the network. The specified service does not exist.)ERROR_NOT_LOGGED_ON
The Operating System Error 1246(Caller to continue with work in progress.)ERROR_CONTINUE
The Operating System Error 1247(An attempt was made to perform an initialization operation wheninitialization has already been completed.)ERROR_ALREADY_INITIALIZED
The Operating System Error 1248(No more local devices.)ERROR_NO_MORE_DEVICES
This is applicable for below versions of Operating Systems
Windows Server 2003
Windows Server 2008 R2
Windows Server 2012
Hope this was helpful.
Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.