企业管理器-〉左边数据库列表上右键-〉register server ,然后会有分步提示,填数据库服务器的名称,然后是数据库的名称,用户名、密码就可以了
register 提示如下!不知道是什么原因?----------------------------------------------------------------- SQL Server registration faited because of the connection failure displayed below. Do you wish to Register anyway?拒绝访问 ConnectionOpen (CreateFile()) -----------------------------------------------------------------
还是到 SQL Server 安装时带的 Online-books 中去查查吧, 其实那里都有详细说明的.
企业管理器-〉左边数据库列表上右键-〉register server ,然后会有分步提示,填数据库服务器的名称,然后是数据库的名称,用户名、密码就可以了
试试我的方法: 1.update one pc OS to WINNT4.0 OR WINDOWS 2000 SERVER AS COMPUTER NAME SQLSERVER01 2.INSTALL SQL SERVER ENTERPRISE VERSION IN SQLSERVEWR01 3. AFTER REBOOT SQLSERVER ,CHECK SERVICE IN CONTROLPANE,CHECK THE MSSQLSERVR SERVICE HAD STARTUP. 4.RUN SQL SERVER ENTERPRISE MANAGER,REGISTER SQL SERVER. USE THE WEY AS xjbs(大鱼). 5.YOU CAN TEST SAME SQL IN ANALYZER,SUCH AS:SELECT * FROM PUBS 6.IN THE OTHER PS(WIN98),INSTALL SQL SERVER CLIENT UTILITY.THEN RUN SQL ANALYZER.
经过查资料,发现应该就是命名管道的问题,可是我在 SQL server 下就是找不到命名管道在哪里,是不是 98+sql7 没有命名管道!有谁用过 98+sql7 环境,给说说!再次谢谢大家的帮忙!
SQL Server registration faited because of the connection failure displayed below. Do you wish to Register anyway?拒绝访问
ConnectionOpen (CreateFile())
-----------------------------------------------------------------
ConnectionOpen (CreateFile())
先在资源管理器中连接一下目的数据库所在的机器试试
有可能是你的网络部分有问题
1.update one pc OS to WINNT4.0 OR WINDOWS 2000 SERVER AS COMPUTER NAME SQLSERVER01
2.INSTALL SQL SERVER ENTERPRISE VERSION IN SQLSERVEWR01
3. AFTER REBOOT SQLSERVER ,CHECK SERVICE IN CONTROLPANE,CHECK THE MSSQLSERVR SERVICE HAD STARTUP.
4.RUN SQL SERVER ENTERPRISE MANAGER,REGISTER SQL SERVER. USE THE WEY AS xjbs(大鱼).
5.YOU CAN TEST SAME SQL IN ANALYZER,SUCH AS:SELECT * FROM PUBS
6.IN THE OTHER PS(WIN98),INSTALL SQL SERVER CLIENT UTILITY.THEN RUN SQL ANALYZER.