Skip to content

SQL Server DBA - Dedicated Blog for all DBA and Developers

SQL DBA blog is dedicated in providing the highest quality and most in-depth SQL Server material to boost your career or to make one more productive.
  • Home
  • SQL Admin
    • SQL Development
    • SQL Server Basics
      • SQL Server Architecture
      • SQL Server Management Studio
      • SQL Server Configuration Manager
    • Using Query Analyser
    • Adding SQL Agent Job
    • Backing up SQL Server Database
    • Restoring Database in SQL Server
    • SQL Server Activity Monitor
    • Using SQL Server Database Tuning Advisor
    • Using SQL Server Profiler
    • SQL Server RPO and RTO
    • SQL Server 2008 HA and DR Solutions
    • SQL Server Encryption
  • High Availability
    • Failover Clustering
    • Database Mirroring
    • Replication
      • Transactional Replication
      • Snapshot Replication
      • Merge Replication
    • Disaster Recovery
      • Backup and Restore
      • Log Shipping
      • Database Mirroring
  • Performance Tuning
    • Operating System Memory Counters
      • OS Memory and Paging Performance Counters
      • OS CPU and Processor Counters
      • OS Disk and Miscellaneous Counters
    • SQL Server Memory
      • Buffer Manager & Memory Performance Counters
      • SQL Server: Memory Manager Counters
      • My Memory Usage– Performance Counters
    • Other Important Performance Counters
      • Data Access Performance Counters
      • User Database Performance Counters
      • SQL Server SQL Statistics Counters
      • Workload Performance Counters
      • Important Perfmon Counters %Processor and Disk monitoring counters
      • SQL Server : Plan Cache Counters
    • Users & Locks Performance Counters
    • Getting Perfmon data from inside of SSMS
  • BI Tools
    • Administration of Reporting Services
    • Administration of Analysis Services
    • Scheduling Integration Services Package
  • Contact Us

SQL Server DBA - Dedicated Blog for all DBA and Developers

SQL DBA blog is dedicated in providing the highest quality and most in-depth SQL Server material to boost your career or to make one more productive.
  • Home
  • SQL Admin
    • SQL Development
    • SQL Server Basics
      • SQL Server Architecture
      • SQL Server Management Studio
      • SQL Server Configuration Manager
    • Using Query Analyser
    • Adding SQL Agent Job
    • Backing up SQL Server Database
    • Restoring Database in SQL Server
    • SQL Server Activity Monitor
    • Using SQL Server Database Tuning Advisor
    • Using SQL Server Profiler
    • SQL Server RPO and RTO
    • SQL Server 2008 HA and DR Solutions
    • SQL Server Encryption
  • High Availability
    • Failover Clustering
    • Database Mirroring
    • Replication
      • Transactional Replication
      • Snapshot Replication
      • Merge Replication
    • Disaster Recovery
      • Backup and Restore
      • Log Shipping
      • Database Mirroring
  • Performance Tuning
    • Operating System Memory Counters
      • OS Memory and Paging Performance Counters
      • OS CPU and Processor Counters
      • OS Disk and Miscellaneous Counters
    • SQL Server Memory
      • Buffer Manager & Memory Performance Counters
      • SQL Server: Memory Manager Counters
      • My Memory Usage– Performance Counters
    • Other Important Performance Counters
      • Data Access Performance Counters
      • User Database Performance Counters
      • SQL Server SQL Statistics Counters
      • Workload Performance Counters
      • Important Perfmon Counters %Processor and Disk monitoring counters
      • SQL Server : Plan Cache Counters
    • Users & Locks Performance Counters
    • Getting Perfmon data from inside of SSMS
  • BI Tools
    • Administration of Reporting Services
    • Administration of Analysis Services
    • Scheduling Integration Services Package
  • Contact Us
Home » SQL Server Error : 11001, Severity: 16. Non-NULL value successfully returned.

SQL Server Error : 11001, Severity: 16. Non-NULL value successfully returned.

  • Vamshi B Vamshi B
  • November 13, 2021
  • SQL Server

Table of Contents

  • SQL Server Error : 11001 Details
  • What causes SQL server error 11001?
  • Solution:
  • Alternate Solutions if above does not work:
  • SQL Server Error Code and solution summary

SQL Server Error : 11001 Details


SQL Server Error: 11001
Severity: 16
Event Logged or not: No
Description:
Non-NULL value successfully returned.
Severity 16 Description:
Indicates general errors that can be corrected by the user.

When the SQL Server cannot be discovered on the network, error 11001 occurs.

This occurs when the IP address is not reachable, or when the TCP port number is either not open or incorrect, or is blocked by a firewall.

What causes SQL server error 11001?

Let’s have a look at what’s causing this problem.

1. When the SQL Server client is unable to connect to the server, this error occurs. This can happen if the client is unable to resolve the server’s name or if the server’s name is wrong.

2. If we want to connect to a SQL server from outside of our local area network, we must need one or more routers and at least one proxy/firewall. The Firewall and/or Proxy may prevent SQL Server from being accessed from a remote location.

 

Solution:

On the client, enter the correct server name so that you may resolve the server name from the client. We also recommend using the ping programme in the Windows operating system to examine TCP/IP name resolution.

Also, double-check that you’re using the right instance name. When connecting to a default instance, server-name is the most accurate representation of the instance name; however, when connecting to a named instance, such as sqlexpress, we recommend using the instance name as server or domain-name/instance-name.

In the instance-name field, type the name of the SQL Server instance.

Also, make sure the SQL Server is connected to the network. To get a list of SQL Servers installed on your computer, type SQLCMD -L.

On the ‘Server’ executing the MSDE Database, we recommend running netsvrcn.exe as an Administrator from the command prompt.

TCP/IP and Named Pipes protocols must be enabled.

Examine the protocols and ports for TCP/IP and Named Pipes. To begin, go to SQL Server Configuration Manager and look at the SQL Server Network Configuration protocols. The TCP/IP protocol and named pipes must both be enabled.

Right-click and select properties for the TCP/IP protocol, then check the TCP/IP communication port. 1433 is the default port. If necessary, this can be altered for security reasons.

Lastly try Restart the instance of SQL Server.

Alternate Solutions if above does not work:

Check if not Excluded the ports SQL Server normally listens on from the firewall using ‘Windows Firewall Advanced Security’ for both inbound and outbound rules:

UDP port 1434 for sql browser

TCP port 1433 for sql service

The SQL Server Browser service has to be active and running. You may verify the status of the browser service using SQL Server Configuration Manager or the services

 

SQL Server Error Code and solution summary


SQL Server Error: 11001
Severity: 16
Event Logged or not: No
Description:
Non-NULL value successfully returned.

Solutions would be

  • Enable TCP and NAMED PIPES protocol
  • Restart SQL Server instance
  • Exclude the ports SQL Server normally listens on, from the firewall using ‘Windows Firewall Advanced Security’ for both in-bound and out-bound rules:
    • 1433 TCP port
    • 1434 UDP port

Test the ODBC connection from a client machine.

Tags:11001 error in sql servererror 11001 in sql servererror de sql server 11001microsoft sql error 11001microsoft sql server error 11001 no such host is knownMicrosoft SQL Server Error: 11001microsoft sql server login error 11001ms sql server error 11001sql error 11001sql server connection error 11001sql server error 11001sql server error 11001 azuresql server error 11001 connection failedsql server error 11001 no such host is knownsql server error code 11001

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Backup and Restore
  • Concurrency Control
  • Connectivity Issues
  • CTE
  • Database Mail
  • Database Maintenance
  • Database Mirrroring
  • Dealocks
  • Disaster Recovery
  • Disk I/O
  • Error Log
  • Extended Events
  • FTP
  • High Availability
  • In-Memory OLTP
  • Indexes
  • Log Shipping
  • MDW
  • Memory Configurations
  • New Features
  • Performance issues
  • Performance Tuning
  • Plan Cache
  • Policy Based Management
  • PRINCE2
  • Project Management
  • Replication
  • Reporting Services
  • Resource Database
  • Resource Governor
  • Revolution Analytics
  • rto rpo
  • SQL Server
  • SQL Server Admin
  • SQL Server Administration
  • SQL Server Alerts and Notifications
  • SQL Server Architecture
  • SQL Server Errors
  • SQL Server Extended Events
  • SQL Server Indexes
  • SQL Server Locks
  • SQL Server on Linux
  • SQL Server Security
  • SSRS
  • Storage Internals
  • Stored Procedures
  • System Databases
  • Table Variable
  • TDE
  • Temporary Database
  • Temporary Tables
  • Temporary Variables
  • Transaction Log
  • Transaction Log Shipping
  • Transactional Replication
  • TSQL
  • Uncategorized
  • Wait Stats

Please follow & like us :)

RSS
Follow by Email
Facebook
fb-share-icon

My Cool Posts…

  • SQL Server Error : 10035, Severity: 16. No value was given for one or more of th
  • SQL Server Error : 10034, Severity: 16. The specified table or view does not exi
  • SQL Server Error : 16943, Severity: 16. Could not complete cursor operation beca
  • SQL Server Error : 16915, Severity: 16. A cursor with the name ‘%.*ls’ already e
  • SQL Server Error : 1639 The eror occurs during installation of SQL Server
  • SQL Server Error : 15404, Severity: 16. Could not obtain information about Windo
  • SQL Server Error : 15401, Severity: 11. Windows NT user or group ‘%s’ not found.
  • SQL Server Error : 15063, Severity: 16. The login already has an account under a
  • SQL Server Error : 10028, Severity: 16. Authentication failed.
  • SQL Server Error : 10027, Severity: 16. Command was not prepared.

DBA

SQL Server DBA

Google site link is https://sites.google.com/view/sqlserver-dba

For list of all URL's https://docs.google.com/spreadsheets/d/1Pmt8rt4TOvvf8IXjudtqz_c-sLQQilRALQStYyVMK3I/edit?usp=sharing

Twitter Account is https://twitter.com/VamshidharBokka

Facebook page is www.facebook.com/SQLServerDBABlog

SQLServerDBA | Copyright by SQLServerDBA

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT