我有两台机器都是windows 2000, 在一台上安装sql2000 开发版,一台机器上安装VB6,现在在VB6里添加ADO控件,然后使用ADO控件来连接另外一台机器的sql server 2000,但是怎么也连接不上,ADO产生的字符串为"Provider=SQLOLEDB.1;Password=0;Persist Security Info=True;User ID=sa;Data Source=ServerIP"但是当我从安装VB机器先访问一下安装sql2000的机器,并且输入windows登陆的名称和密码,ADO就可以连接上了。怎么样才可以不先访问安装sql2000的机器,直接用ADO就可以连接上了?? sql server 身份验证模式采用的:SQL server和WINDOWS模式.
这个 难道不是混合认证模式??
C:\WINNT\system32\drivers\etc文件夹下有个Hosts的文件 用记事本打开
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host127.0.0.1 localhost
--自己添加的噢!
ServerIP 连接的机器的名称
看看可以吗?
使用sql server身份验证 登陆名sa,密码在安全性--登陆里设置
?? 你的意思是设置sa的密码?