SQL ODBC连接问题 [英] SQL ODBC Connection Issue

问题描述

亲爱的朋友们，



在以下问题中需要你的帮助。



当我输入SERVERNAME时ODBC连接（SQL Server Native客户端10.0）它没有连接（Gave 08001错误，HYT00），当我键入servername \sql实例名称它将工作。



我尝试重新启动SQL Server浏览器服务，但这没有帮助。



我需要使用servername而不是servername \instancename进行odbc连接。 br />


感谢您对此的帮助和评论。



提前谢谢



PS，使用Windows 2008 R2，它只是一个工作组服务器。

Dear Friends,

Need your help in below issue.

when i type SERVERNAME in ODBC connection (SQL Server Native client 10.0) its does not connect( Gave 08001 Error, HYT00) and when i typed servername\sql instance name it will work.

I tried restarting "SQL Server browser" Service, but that didn't help.

I need to make odbc connection just with servername not with servername\instancename.

Appreciate your help and comments on this.

Thank you in advance

P.S, Using Windows 2008 R2, its just a workgroup server.

推荐答案

连接查询是对的。



在SQL Server的ALL IP中将端口更改为1433配置，它完美地工作。



谢谢。

Connection query was right.

Changed the port to 1433 in 'ALL IP' in SQL Server Configuration, and it worked perfectly.

Thank you.

这篇关于SQL ODBC连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！