错误消息我显示 [英] Error message I am shown

问题描述

错误消息：

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

public class commonfunction
    {
        #region Variable Declaration

        SqlConnection _connection;
        SqlCommand _command;
        SqlDataAdapter _Adapter;
        DataSet _DS;
        int _count;

        #endregion

        #region Get DataSet

        public DataSet GetDataSet(string _query)
        {

            try
            {
                _DS = new DataSet();
                _connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString);
                _command = new SqlCommand(_query, _connection);
                _Adapter = new SqlDataAdapter(_command);
                _Adapter.Fill(_DS);
                return _DS;

            }
            catch (Exception)
            {

                throw;

            }
            finally
            {
                _DS.Dispose();
            }

        }
        #endregion

        #region Execute Query

        public int ExecuteQuery(string _query)
        {
            try
            {
                _connection =  new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString);
                _connection.Open();
                _command = new SqlCommand(_query, _connection);
                _count = _command.ExecuteNonQuery();
                _connection.Close();
                return _count;
            }
            catch (Exception)
            {

                throw;
            }
            finally
            {
                _connection.Close();
            }

        }

        #endregion
    }

推荐答案

可能是以下之一：



- 错误的服务器名称

- 错误的凭证

- 禁用远程连接

- 防火墙阻止



查看一个一个验证那些是按顺序



干杯，

Edo

Could be one of the following:

- Wrong server name
- Wrong credentials
- Disabled remote connection
- Firewall blocking

Check one by one to validate those are in order

Cheers,
Edo

这篇关于错误消息我显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！