SQL 2000 (2)

配置sql server 2000以允许远程访问

配置sql server 2000以允许远程访问适合故障:1. 用sql企业管理器能访问sql server 2000(因为它是采用命名管道(named pipes)方式进行方式),但用ado.net 方式(udp)不能访问.2. 采用ado.net方式不能远程访问.故障的可能原因有:1.sql server 2000没有安装sql server 2000 sp3a及以上升级包,还未启用并开放1433端口(udp);2.系统防火墙未开放1433端口. 解决办法:一.检查sql server 2000是否已启用并开放1433端口.(在sql2000服务器上)   方法:   开始-->运行-->打开-->执行 "cmd" 命令 -->执行 "netstat -na" 命令.   看是否有无   TCP         127.0.0.1:1433               0.0.0.0:0                             LISTENING      TCP         192.168.123.98:1433          0.0.0.0:0                             LISTENING如果没有刚表明sql2000端口监听服务未启动. 转第三步.如果有则转第二步 二.检查sql server 2000服务器所在机器防火墙设置,sql server 2000服务器端是否启动Sql Server服务.   主要检查防火墙是否设置允许1433端口通信. 简单的方法是关闭防火墙后再试.   方法:    在客户端或本机"命令提示符"窗口运行下面命令 : telnet <sql2000服务器IP地址> 1433    如果命令执行成功,说明 SQL Server 服务器工作正常,并且正在监听1433端口的 TCP/IP 连接    如果命令返回"无法打开连接"的错误信息,则说明服务器端没有启动 SQL Server 服务,    也可能服务器端没启用 TCP/IP 协议,或者服务器端没有在 SQL Server 默认的端口1433上监听.    是否启动 SQL Server 服务或监听端口通过sql2000网络配置工具来检查. 三.检查sql server 2000是否已升级到8.00.760或以上版本.   方法:   在sql查询分析器中执行:   SELECT SERVERPROPERTY('ProductLevel')   SELECT @@VERSION    SELECT SERVERPROPERTY('ProductVersion')    如果为8.00.760以下则需安装sql2000 sp3a或sql2000 sp4   sp4下载地址 :   http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=zh-cn     注意安装前需要备份当前数据库文件,以备重装早期版本的sql2000时恢复用.    点击 开始-->控制面板-->管理工具-->本地安全策略-->本地策略-->安全选项    将"设备:未签名驱动程序的安装操作" 设置为"默认继续".    注意下载后,执行解压目录中的setup.bat.    更为详细的介绍请参见sql2000 sp4 readme   http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=zh-cn ============================================================================================================================================SQL Server连接中的四个最常见错误(转载)============================================================================================================================================一."SQL Server 不存在或访问被拒绝" 这个是最复杂的,错误发生的原因比较多,需要检查的方面也比较多. 一般说来,有以下几种可能性:  1,SQL Server名称或IP地址拼写有误2,服务器端网络配置有误3,客户端网络配置有误 要解决这个问题,我们一般要遵循以下的步骤来一步步找出导致错误的原因.  =============…
Read more...

( ! ) Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/category.php on line 191
Call Stack
#TimeMemoryFunctionLocation
10.0003398168{main}( ).../index.php:0
20.03141348560Joomla\CMS\Application\SiteApplication->execute( ).../index.php:49
30.03141348560Joomla\CMS\Application\SiteApplication->doExecute( ).../CMSApplication.php:196
40.10472875560Joomla\CMS\Application\SiteApplication->dispatch( $component = ??? ).../SiteApplication.php:233
50.10502899976Joomla\CMS\Component\ComponentHelper::renderComponent( $option = 'com_k2', $params = ??? ).../SiteApplication.php:194
60.10552955328Joomla\CMS\Component\ComponentHelper::executeComponent( $path = '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ).../ComponentHelper.php:377
70.10552972384require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php ).../ComponentHelper.php:402
80.10913104624K2ControllerItemlist->execute( $task = 'category' ).../k2.php:64
90.10913104624K2ControllerItemlist->display( $cachable = ???, $urlparams = ??? ).../BaseController.php:710
100.11143128248K2ControllerItemlist->display( $cachable = TRUE, $urlparams = ['limit' => 'UINT', 'limitstart' => 'UINT', 'id' => 'INT', 'tag' => 'STRING', 'searchword' => 'STRING', 'day' => 'INT', 'year' => 'INT', 'month' => 'INT', 'print' => 'INT', 'lang' => 'CMD', 'Itemid' => 'INT', 'ordering' => 'CMD', 'm' => 'INT', 'amp' => 'INT', 'tmpl' => 'CMD', 'template' => 'CMD'] ).../itemlist.php:49
110.11143128248K2ControllerItemlist->display( $cachable = TRUE, $urlparams = ['limit' => 'UINT', 'limitstart' => 'UINT', 'id' => 'INT', 'tag' => 'STRING', 'searchword' => 'STRING', 'day' => 'INT', 'year' => 'INT', 'month' => 'INT', 'print' => 'INT', 'lang' => 'CMD', 'Itemid' => 'INT', 'ordering' => 'CMD', 'm' => 'INT', 'amp' => 'INT', 'tmpl' => 'CMD', 'template' => 'CMD'] ).../controller.php:19
120.11203135760Joomla\CMS\Cache\Controller\ViewController->get( $view = class K2ViewItemlist { public $document = class Joomla\CMS\Document\HtmlDocument { public $_links = [...]; public $_custom = [...]; public $template = NULL; public $baseurl = NULL; public $params = NULL; public $_file = NULL; protected $_template = ''; protected $_template_tags = [...]; protected $_caching = NULL; private $_html5 = NULL; public $title = 'SQL 2000'; public $description = ''; public $link = ''; public $base = 'https://www.shan.info/itemlist/category/69-sql-2000.html'; public $language = 'en-gb'; public $direction = 'ltr'; public $_generator = 'Joomla! - Open Source Content Management'; public $_mdate = ''; public $_tab = '\t'; public $_lineEnd = '\n'; public $_charset = 'utf-8'; public $_mime = 'text/html'; public $_namespace = ''; public $_profile = ''; public $_scripts = [...]; public $_script = [...]; protected $scriptOptions = [...]; public $_styleSheets = [...]; public $_style = [...]; public $_metaTags = [...]; public $_engine = NULL; public $_type = 'html'; protected $mediaVersion = '15dbf078d61dbbf76811992dd0143dd9' }; protected $_name = 'itemlist'; protected $_models = ['item' => class K2ModelItem { ... }, 'itemlist' => class K2ModelItemlist { ... }]; protected $_basePath = '/var/www/vhosts/shan.info/httpdocs/components/com_k2'; protected $_defaultModel = 'itemlist'; protected $_layout = 'category'; protected $_layoutExt = 'php'; protected $_layoutTemplate = '_'; protected $_path = ['template' => [...], 'helper' => [...]]; protected $_template = '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/category_item.php'; protected $_output = '\n<article class="itemView groupPrimary"> \t\n\t\t<time datetime="2012-06-26T11:05:17+02:00">\n\t\t26 Jun\t</time>\n\t\t\t\n\t<section>\t\t\n\t\t<header>\n\t\t\t\t\n\t\t\t\t\t\t<h2>\n\t\t\t\t\t\t\t\t\t\t<a href="/item/288-安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码.html">安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码</a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t</h2>\n\t\t\t\t\t\t\n\t\t\t<ul>\n\t\t\t\t\t\t\t\t<li class="itemCategory"> <span>Published'; protected $_escape = 'htmlspecialchars'; protected $_charset = 'UTF-8'; protected $_errors = []; public $baseurl = ''; public $now = '2021-09-25 20:54:12'; public $nullDate = '0000-00-00 00:00:00'; public $category = class TableK2Category { public $id = '69'; public $name = 'SQL 2000'; public $alias = 'sql-2000'; public $description = ''; public $parent = '0'; public $extraFieldsGroup = '0'; public $published = '1'; public $image = '/components/com_k2/images/placeholder/category.png'; public $access = '1'; public $ordering = '30'; public $params = '{"inheritFrom":"0","theme":"","num_leading_items":"0","num_leading_columns":"1","leadingImgSize":"Large","num_primary_items":"10","num_primary_columns":"1","primaryImgSize":"Medium","num_secondary_items":"0","num_secondary_columns":"1","secondaryImgSize":"Small","num_links":"0","num_links_columns":"1","linksImgSize":"XSmall","catCatalogMode":"0","catFeaturedItems":"1","catOrdering":"","catPagination":"2","catPaginationResults":"1","catTitle":"1","catTitleItemCounter":"1","catDescription":"0","catImage":"0",'; public $trash = '0'; public $plugins = ''; public $language = '*'; protected $_tbl = '#__k2_categories'; protected $_tbl_key = 'id'; protected $_tbl_keys = [...]; protected $_db = class JDatabaseDriverMysqli { ... }; protected $_trackAssets = FALSE; protected $_rules = NULL; protected $_locked = FALSE; protected $_autoincrement = TRUE; protected $_observers = class JObserverUpdater { ... }; protected $_columnAlias = [...]; protected $_jsonEncode = [...]; protected $_errors = [...]; public $metaDescription = NULL; public $metaKeywords = NULL; public $metaRobots = NULL; public $metaAuthor = NULL; public $link = '/itemlist/category/69-sql-2000.html'; public $text = ''; public $jcfields = [...]; public $event = class stdClass { ... } }; public $user = class Joomla\CMS\User\User { protected $isRoot = FALSE; public $id = 0; public $name = NULL; public $username = NULL; public $email = NULL; public $password = NULL; public $password_clear = ''; public $block = NULL; public $sendEmail = 0; public $registerDate = NULL; public $lastvisitDate = NULL; public $activation = NULL; public $params = NULL; public $groups = [...]; public $guest = 1; public $lastResetTime = NULL; public $resetCount = NULL; public $requireReset = NULL; protected $_params = class Joomla\Registry\Registry { ... }; protected $_authGroups = NULL; protected $_authLevels = [...]; protected $_authActions = NULL; protected $_errorMsg = NULL; protected $userHelper = class Joomla\CMS\User\UserWrapper { ... }; protected $_errors = [...]; public $aid = 0; public $gid = 1 }; public $feed = 'https://www.shan.info/itemlist/category/69-sql-2000.html&format=feed&Itemid=53'; public $leading = []; public $primary = [0 => class stdClass { ... }, 1 => class stdClass { ... }]; public $secondary = []; public $links = []; public $params = class Joomla\Registry\Registry { protected $data = class stdClass { ... }; protected $initialized = TRUE; public $separator = '.' }; public $pagination = class Joomla\CMS\Pagination\Pagination { public $limitstart = 0; public $limit = 10; public $total = 2; public $prefix = ''; public $pagesStart = 1; public $pagesStop = 1; public $pagesCurrent = 1; public $pagesTotal = 1; public $hideEmptyLimitstart = FALSE; protected $viewall = FALSE; protected $additionalUrlParams = [...]; protected $app = class Joomla\CMS\Application\SiteApplication { ... }; protected $data = NULL }; public $item = class stdClass { public $id = '288'; public $title = '安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码'; public $alias = '安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码'; public $catid = '69'; public $published = '1'; public $introtext = '企业管理器-》数据库服务器-》安全性-》登陆-》sa右键属性-》修改密码-》确定'; public $fulltext = ''; public $video = NULL; public $gallery = NULL; public $extra_fields = NULL; public $extra_fields_search = ''; public $created = '2012-06-26 09:05:17'; public $created_by = '63'; public $created_by_alias = ''; public $checked_out = '0'; public $checked_out_time = '0000-00-00 00:00:00'; public $modified = '2012-10-14 02:07:15'; public $modified_by = '0'; public $publish_up = '2012-06-26 09:05:17'; public $publish_down = '0000-00-00 00:00:00'; public $trash = '0'; public $access = '1'; public $ordering = '2'; public $featured = '0'; public $featured_ordering = '0'; public $image_caption = ''; public $image_credits = ''; public $video_caption = ''; public $video_credits = ''; public $hits = '2825'; public $params = class Joomla\Registry\Registry { ... }; public $metadesc = ''; public $metadata = ''; public $metakey = ''; public $plugins = ''; public $language = '*'; public $categoryname = 'SQL 2000'; public $categoryid = '69'; public $categoryalias = 'sql-2000'; public $categoryparams = '{"inheritFrom":"0","theme":"","num_leading_items":"0","num_leading_columns":"1","leadingImgSize":"Large","num_primary_items":"10","num_primary_columns":"1","primaryImgSize":"Medium","num_secondary_items":"0","num_secondary_columns":"1","secondaryImgSize":"Small","num_links":"0","num_links_columns":"1","linksImgSize":"XSmall","catCatalogMode":"0","catFeaturedItems":"1","catOrdering":"","catPagination":"2","catPaginationResults":"1","catTitle":"1","catTitleItemCounter":"1","catDescription":"0","catImage":"0",'; public $itemGroup = 'primary'; public $category = class TableK2Category { ... }; public $link = '/item/288-安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码.html'; public $printLink = '/item/288-安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码.html?tmpl=component&amp;print=1'; public $tags = [...]; public $imageXSmall = ''; public $imageSmall = ''; public $imageMedium = ''; public $imageLarge = ''; public $imageXLarge = ''; public $rawTitle = '安装sql2000时没有设置sa密码,安装完成了之后再设置sa的密码'; public $author = class Joomla\CMS\User\User { ... }; public $text = '企业管理器-》数据库服务器-》安全性-》登陆-》sa右键属性-》修改密码-》确定'; public $event = class stdClass { ... }; public $jcfields = [...]; public $image = ''; public $imageWidth = '400' } }, $method = 'display', $id = ???, $wrkarounds = ??? ).../BaseController.php:663
130.11413156448K2ViewItemlist->display( $tpl = ??? ).../ViewController.php:102
140.15415944768K2ViewItemlist->display( $tpl = NULL ).../view.html.php:1407
150.15415944768K2ViewItemlist->loadTemplate( $tpl = NULL ).../HtmlView.php:230
160.15476021592include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/category.php ).../HtmlView.php:701