测试freetds是否能连mssql
来源:互联网 发布:淘宝售后流程表 编辑:程序博客网 时间:2024/04/27 19:38
freetds连接失败可能原因:
1. mssql服务器是否开放远程连接2.防火墙是否限制了连接
3. 端口号是否正确,默认是1433
4.配置文件中servername中是否指定tdsrve verstion
Start with ping
First ping the host to make sure you can talk to the machine the server resides on.
Example 8-1. Finding the server's host
$ ping -c1 myhostPING myhost (127.0.0.1) from 127.0.0.1 : 56(84) bytes of data.64 bytes from myhost (127.0.0.1): icmp_seq=0 ttl=255 time=250 usec
Test with telnet
Attempt to telnet to the port, to verify that the dataserver is listening.
Example 8-2. Finding the server
$ telnet myhost 1433Trying 127.0.0.1...Connected to myhost.Escape character is '^]'.
Test with tsql
tsql can be run in two ways, one which uses freetds.conf and one which connects directly using the host and port. First attempt a connection using host and port.
Example 8-3. Connecting to the server, bypassing freetds.conf
$ cd src/apps$ TDSVER=7.0 ./tsql -H myhost -p 1433 -U user
If you receive a message like
Msg. No.: 18450 Severity: 14 State: 1 Login failed- User: loginid Reason: Not defined as a valid user of a trusted SQL Server connectionSQL Server is accepting only "domain" logins. This applies only to Microsoft SQL Server and you'll need to have your DBA verify that "server logins" are allowed, or use a domain login.
Finally, if you received a prompt, then try tsql using the dataserver name.
Example 8-4. Connecting to the server using freetds.conf
$ ./tsql -S myserver -U user
Notes
[1]To exit telnet: When connected, telnet's command mode may be entered by typing the telnetescape character (initially Ctrl-], as above). Once in command mode,telnet may be exited with the command quit.
- 测试freetds是否能连mssql
- 使用curl测试websocket服务是否能正常连入
- 测试是否能发表博客
- Linux下通过freetds连接MSSQL数据库
- Linux下通过freetds连接MSSQL数据库
- Linux下通过freetds连接MSSQL数据库
- Linux下通过freetds连接MSSQL数据库
- Linux下通过freetds连接MSSQL数据库
- FreeTDS安装 for linux ‘s mssql
- linux 用freetds 连接mssql 2008
- Linux下连接MSSQL之安装FreeTDS
- Unix下测试端口是否能通
- C# 测试PDF是否能打开 .
- 【ping】测试ip地址是否能访问
- 测试下kafka是否能成功运行
- linux 测试是否能访问端口
- Linux下FreeTDS访问MSSQL Server的配置
- Linux下FreeTDS访问MSSQL Server的配置
- sap netweaver security guide
- huffman编码实现(详细实现)
- OpenCV学习笔记-霍夫圆变换
- Ext Js 3.x中表格Grid的学习和实例
- web压力测试工具
- 测试freetds是否能连mssql
- WinFlip 实现Win7 Win+Tab 功能
- Android开发出现 invalid command-line parameter: Files. 解决办法
- 编译mahout源码并导到eclipse中
- ajax验证用户是否存在
- 都一把年纪啦,还写代码 ^_^
- Cppunit基础(2) --基于VC
- PROC系列
- arcmap加载.net开发的dll的问题