Operating System Error 1209 to Operating System Error 1228 for SQL Server

SQLServerF1

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 1209 to Operating System Error 1228

The Operating System Error 1209(The format of the specified group name is invalid.)
ERROR_INVALID_GROUPNAME

The Operating System Error 1210(The format of the specified computer name is invalid.)
ERROR_INVALID_COMPUTERNAME

The Operating System Error 1211(The format of the specified event name is invalid.)
ERROR_INVALID_EVENTNAME

The Operating System Error 1212(The format of the specified domain name is invalid.)
ERROR_INVALID_DOMAINNAME

The Operating System Error 1213(The format of the specified service name is invalid.)
ERROR_INVALID_SERVICENAME

The Operating System Error 1214(The format of the specified network name is invalid.)
ERROR_INVALID_NETNAME

The Operating System Error 1215(The format of the specified share name is invalid.)
ERROR_INVALID_SHARENAME

The Operating System Error 1216(The format of the specified password is invalid.)
ERROR_INVALID_PASSWORDNAME

The Operating System Error 1217(The format of the specified message name is invalid.)
ERROR_INVALID_MESSAGENAME

The Operating System Error 1218(The format of the specified message destination is invalid.)
ERROR_INVALID_MESSAGEDEST

The Operating System Error 1219(The credentials supplied conflict with an existing set ofcredentials.)
ERROR_SESSION_CREDENTIAL_CONFLICT

The Operating System Error 1220(An attempt was made to establish a session to a network server, butthere are already too many sessions established to that server.)
ERROR_REMOTE_SESSION_LIMIT_EXCEEDED

The Operating System Error 1221(The workgroup or domain name is already in use by another computer onthe network.)
ERROR_DUP_DOMAINNAME

The Operating System Error 1222(The network is not present or not started.)
ERROR_NO_NETWORK

The Operating System Error 1223(The operation was canceled by the user.)
ERROR_CANCELLED

The Operating System Error 1224(The requested operation cannot be performed on a file with auser-mapped section open.)
ERROR_USER_MAPPED_FILE

The Operating System Error 1225(The remote system refused the network connection.)
ERROR_CONNECTION_REFUSED

The Operating System Error 1226(The network connection was gracefully closed.)
ERROR_GRACEFUL_DISCONNECT

The Operating System Error 1227(The network transport endpoint already has an address associated withit.)
ERROR_ADDRESS_ALREADY_ASSOCIATED

The Operating System Error 1228(An address has not yet been associated with the network endpoint.)
ERROR_ADDRESS_NOT_ASSOCIATED

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.

 

Operating System Error 1140 to Operating System Error 1208 for SQL Server

SQLServerF1

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 1140 to Operating System Error 1208

The Operating System Error 1140(An attempt to change the system power state was vetoed by anotherapplication or driver.)
ERROR_SET_POWER_STATE_VETOED

The Operating System Error 1141(The system BIOS failed an attempt to change the system power state.)
ERROR_SET_POWER_STATE_FAILED

The Operating System Error 1142(An attempt was made to create more links on a file than the filesystem supports.)
ERROR_TOO_MANY_LINKS

The Operating System Error 1150(The specified program requires a newer version of Windows.)
ERROR_OLD_WIN_VERSION

The Operating System Error 1151(The specified program is not a Windows or MS-DOS program.)
ERROR_APP_WRONG_OS

The Operating System Error 1152(Cannot start more than one instance of the specified program.)
ERROR_SINGLE_INSTANCE_APP

The Operating System Error 1153(The specified program was written for an earlier version of Windows.)
ERROR_RMODE_APP

The Operating System Error 1154(One of the library files needed to run this application is damaged.)
ERROR_INVALID_DLL

The Operating System Error 1155(No application is associated with the specified file for thisoperation.)
ERROR_NO_ASSOCIATION

The Operating System Error 1156(An error occurred in sending the command to the application.)
ERROR_DDE_FAIL

The Operating System Error 1157(One of the library files needed to run this application cannot befound.)
ERROR_DLL_NOT_FOUND

The Operating System Error 1200(The specified device name is invalid.)
ERROR_BAD_DEVICE

The Operating System Error 1201(The device is not currently connected but it is a rememberedconnection.)
ERROR_CONNECTION_UNAVAIL

The Operating System Error 1202(An attempt was made to remember a device that had previously beenremembered.)
ERROR_DEVICE_ALREADY_REMEMBERED

The Operating System Error 1203(No network provider accepted the given network path.)
ERROR_NO_NET_OR_BAD_PATH

The Operating System Error 1204(The specified network provider name is invalid.)
ERROR_BAD_PROVIDER

The Operating System Error 1205(Unable to open the network connection profile.)
ERROR_CANNOT_OPEN_PROFILE

The Operating System Error 1206(The network connection profile is corrupt.)
ERROR_BAD_PROFILE

The Operating System Error 1207(Cannot enumerate a noncontainer.)
ERROR_NOT_CONTAINER

The Operating System Error 1208(An extended error has occurred.)
ERROR_EXTENDED_ERROR

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.

 

Operating System Error 1113 to Operating System Error 1132 for SQL Server

SQLServerF1

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 1113 to Operating System Error 1132

The Operating System Error 1113(No mapping for the Unicode character exists in the target multibytecode page.)
ERROR_NO_UNICODE_TRANSLATION

The Operating System Error 1114(A dynamic link library (DLL) initialization routine failed.)
ERROR_DLL_INIT_FAILED

The Operating System Error 1115(A system shutdown is in progress.)
ERROR_SHUTDOWN_IN_PROGRESS

The Operating System Error 1116(Unable to abort the system shutdown because no shutdown was inprogress.)
ERROR_NO_SHUTDOWN_IN_PROGRESS

The Operating System Error 1117(The request could not be performed because of an I/O device error.)
ERROR_IO_DEVICE

The Operating System Error 1118(No serial device was successfully initialized. The serial driver willunload.)
ERROR_SERIAL_NO_DEVICE

The Operating System Error 1119(Unable to open a device that was sharing an interrupt request (IRQ)with other devices. At least one other device that uses that IRQ was already opened.)
ERROR_IRQ_BUSY

The Operating System Error 1120(A serial I/O operation was completed by another write to the serialport. The IOCTL_SERIAL_XOFF_COUNTER reached zero.))
ERROR_MORE_WRITES

The Operating System Error 1121(A serial I/O operation completed because the time-out period expired.(The IOCTL_SERIAL_XOFF_COUNTER did not reach zero.))
ERROR_COUNTER_TIMEOUT

The Operating System Error 1122(No ID address mark was found on the floppy disk.)
ERROR_FLOPPY_ID_MARK_NOT_FOUND

The Operating System Error 1123(Mismatch between the floppy disk sector ID field and the floppy diskcontroller track address.)
ERROR_FLOPPY_WRONG_CYLINDER

The Operating System Error 1124(The floppy disk controller reported an error that is not recognizedby the floppy disk driver.)
ERROR_FLOPPY_UNKNOWN_ERROR

The Operating System Error 1125(The floppy disk controller returned inconsistent results in itsregisters.)
ERROR_FLOPPY_BAD_REGISTERS

The Operating System Error 1126(While accessing the hard disk, a recalibrate operation failed, evenafter retries.)
ERROR_DISK_RECALIBRATE_FAILED

The Operating System Error 1127(While accessing the hard disk, a disk operation failed even afterretries.)
ERROR_DISK_OPERATION_FAILED

The Operating System Error 1128(While accessing the hard disk, a disk controller reset was needed,but even that failed.)
ERROR_DISK_RESET_FAILED

The Operating System Error 1129(Physical end of tape encountered.)
ERROR_EOM_OVERFLOW

The Operating System Error 1130(Not enough server storage is available to process this command.)
ERROR_NOT_ENOUGH_SERVER_MEMORY

The Operating System Error 1131(A potential deadlock condition has been detected.)
ERROR_POSSIBLE_DEADLOCK

The Operating System Error 1132(The base address or the file offset specified does not have theproper alignment.)
ERROR_MAPPED_ALIGNMENT

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.

 

Operating System Error 1005 to Operating System Error 1052 for SQL Server

SQLServerF1

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 1005 to Operating System Error 1052

The Operating System Error 1005(The volume does not contain a recognized file system. Please makesure that all required file system drivers are loaded and that the volume is notcorrupted.)
ERROR_UNRECOGNIZED_VOLUME

The Operating System Error 1006(The volume for a file has been externally altered so that the openedfile is no longer valid.)
ERROR_FILE_INVALID

The Operating System Error 1007(The requested operation cannot be performed in full-screen mode.)
ERROR_FULLSCREEN_MODE

The Operating System Error 1008(An attempt was made to reference a token that does not exist.)
ERROR_NO_TOKEN

The Operating System Error 1009(The configuration registry database is corrupt.)
ERROR_BADDB

The Operating System Error 1010(The configuration registry key is invalid.)
ERROR_BADKEY

The Operating System Error 1011(The configuration registry key could not be opened.)
ERROR_CANTOPEN

The Operating System Error 1012(The configuration registry key could not be read.)
ERROR_CANTREAD

The Operating System Error 1013(The configuration registry key could not be written.)
ERROR_CANTWRITE

The Operating System Error 1014(One of the files in the registry database had to be recovered by useof a log or alternate copy. The recovery was successful.)
ERROR_REGISTRY_RECOVERED

The Operating System Error 1015(The registry is corrupted. The structure of one of the files thatcontains registry data is corrupted, or the system’s image of the file in memory iscorrupted, or the file could not be recovered because the alternate copy or log was absentor corrupted.)
ERROR_REGISTRY_CORRUPT

The Operating System Error 1016(An I/O operation initiated by the registry failed unrecoverably. Theregistry could not read in, or write out, or flush, one of the files that contain thesystem’s image of the registry.)
ERROR_REGISTRY_IO_FAILED

The Operating System Error 1017(The system has attempted to load or restore a file into the registry,but the specified file is not in a registry file format.)
ERROR_NOT_REGISTRY_FILE

The Operating System Error 1018(Illegal operation attempted on a registry key that has been markedfor deletion.)
ERROR_KEY_DELETED

The Operating System Error 1019(System could not allocate the required space in a registry log.)
ERROR_NO_LOG_SPACE

The Operating System Error 1020(Cannot create a symbolic link in a registry key that already hassubkeys or values.)
ERROR_KEY_HAS_CHILDREN

The Operating System Error 1021(Cannot create a stable subkey under a volatile parent key.)
ERROR_CHILD_MUST_BE_VOLATILE

The Operating System Error 1022(A notify change request is being completed and the information is notbeing returned in the caller’s buffer. The caller now needs to enumerate the files to findthe changes.)
ERROR_NOTIFY_ENUM_DIR

The Operating System Error 1051(A stop control has been sent to a service that other running servicesare dependent on.)
ERROR_DEPENDENT_SERVICES_RUNNING

The Operating System Error 1052(The requested control is not valid for this service.)
ERROR_INVALID_SERVICE_CONTROL

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.

 

Lot of Events in EventLog related to The database engine detached a database

SQLServerF1

On Windows Server 2012, you may see many messages as below logged into the Windows Eventlogs every few seconds. If you are seeing this message on a database server, then you may assume this is related to SQL Server, however this message has nothing to do with the SQL Server or any components installed along with SQL Server.

Event Id 327
svchost (1600) The database engine detached a database (2, C:\Windows\system32\LogFiles\Sum\SystemIdentity.mdb). (Time=0 seconds)
Event Id 326
svchost (1600) The database engine attached a database (2, C:\Windows\system32\LogFiles\Sum\SystemIdentity.mdb). (Time=0 seconds)

These message appear because of the “User Access Logging” service which comes with Windows Server 2012. This is enabled by default on servers running Windows Server 2012. This application aggregates client usage data by role and products on a local server which later can be used by IT administrators to find quantities and instances by server role or software product, by user, by device, by the local server, and by date using Windows Management Instrumentation (WMI) or Windows PowerShell cmdlets.

These messages can be sometime logged too frequently causing the eventlog file to become full or even can cause hang or crash of the server.

If you are not using this application “User Access Logging”, then you may consider disabling this service. Follow the below steps to Stop or Disable “User Access Logging”.

– RDP in to the server with an account that has local administrator privileges.
– From the Server Manager, Point to Tools, and then click on Services.
– Scroll down and select “User Access Logging” Service and then click on Stop this service.
– Right-click the “User Access Logging” service name and choose Properties, in the General tab, change the Startup type to Disabled, and then click OK.

You should not see any more of these errors. You may save the old Application and System Eventlogs and clear the eventlogs.

If you are using this service, then you may have to troubleshoot the same. One of the article for troubleshooting steps can be found from http://support2.microsoft.com/kb/2900773/ja
This is in Japanese language, but you can translate this easily to your language.

This is applicable on below versions of Windows Server
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.

 
1 2 3 4