注册或者新建账套时,系统提示“不能创建SSPI上下文”?
这个是由于SQLServer使用Windows认证方式,并且数据库服务器使用IP地址,不能通过IP地址解析机器名引起的,解决方法如下:
1)使用机器名而不是IP地址
2)在中间层的Hosts文件中加入数据库服务器的IP地址和机器名
Hosts文件的路径: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 host
127.0.0.1 localhost192.168.3.2 diy192.168.3.2 diy.diydomain.com192.168.10.254 diy192.168.10.254 diy.diydomain.com