Microsoft odbc sql server driver ошибка связи - Ремонт и установка крупной бытовой техники

Remove From My Forums

Question
About one month ago we did a fresh install on our SQL Server, formatted everything and started with a clean OS. Ever since then we have this random communication link failure problem. It seems to happen completely randomly.
```
[Microsoft][ODBC SQL Server Driver]Communication link failure
```
Anyone have any suggestions on what causes this? The server is completely patched with all drivers up to date.

Specs: Server 2003, SQL 2005 SP3 9.00.4035 Standard Edition

Answers

Hi homeguards,

«Communication link failure” means that an existing ODBC connection was closed, and we tried to use that connection. Usually an existing connection being dropped is either a failure of a client to sent packets to keep the connection open, or intermediate network hardware dropping a connection, or SQL Server having a problem.

To determine who is dropping the connection, we needed simultaneous network captures on both the client and SQL Server, for the few moment before the issue, and during the issue.

Generally, we can try these things to solve the issue:
1.Disable TCP Chimney and other Scalable Network Features per http://support.microsoft.com/kb/951037/en-us
2.Enable the SQL Server port in Firewall.
3.Update the Network Interface Care driver.

If there is anything unclear, pleaes feel free to ask.

Thanks,
Jin Chen

Jin Chen — MSFT
- Marked as answer by
  
  Monday, March 8, 2010 2:30 AM

I’m trying to create an ODBC connection to SQL Server, but when i do, i get error:

Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC_SQL Server Driver][TCP/IP Sockets] COnnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC_SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.

Here’s what I’ve tried:

not a firewall issue: tried with firewall on SQL Server turned off, and client turned off. Also able to telnet 1433 from client and that works fine.
not an access issue: I can login from many different computers, including the SQL Server itself using the account i’m using on client (using SQL Server authentication)
i can ping the hostname and IP address. (i’ve tried both)

The only thing i can think of is that the client computer is windows server 2003, and has various roles setup:

File Server
Application Server
Terminal Server
Domain Controller
DNS Server

I don’t know why these services are setup, but for the time being i can’t shut them off. Would it be any of these, and if so, is there a way to disable any of the aspects of them, that might be blocking SQL.

Any advise truly appreciated!

asked Nov 15, 2012 at 20:00

Found the issue. For some reason, even though SQL was not in use on the client, it was installed, and by going to All Programs -> Microsoft SQL Server -> Client Network Utility, i found that the protocal TCP/IP was using port 4717. I have no idea why that port was in use, and even further, i’m not sure why it would even matter — I was just setting up an odbc connection, and not using sql server (on the client) at all. Either way, I changed this to the typical port (1433), and like boom, ODBC connection works like charm!

answered Nov 15, 2012 at 20:44

russdsrussds

8355 gold badges25 silver badges48 bronze badges

Is it possible that the server in question has not been configured to use named pipes?

CAUSE
The most common reason that this connection attempt failed is
that this DSN or ODBC data source attempted to make a connection using
the TCP/IP sockets Net-Library, which is Dbmssocn.dll. Because the SQL
Server is not listening for incoming connections for TCP/IP sockets
clients, the connection fails. From ISQL/w, the second error message
stated above would be returned. The OS Error is 10061, and the
function call that failed was ConnectionOpen(connect()).

WORKAROUND
By default, SQL Server will listen for incoming connections
made by Named Pipes clients. Named Pipes is the default IPC mechanism
for clients to connect to a SQL Server version 4.2, 6.0, and 6.5
server. The Named Pipes DLL is Dbnmpntw.dll, and it should be located
in the WindowsSystem or WinntSystem32 directory. The TCP/IP sockets
netlib DLL is Dbmssocn.dll, and also should be in the WindowsSystem
or WinntSystem32 directory.The most common resolution to this problem
is to configure the client computer to connect using Named Pipes.
Configuring Named Pipes If the Microsoft Data Access Components (MDAC)
ODBC drivers have been installed on the computer, you can make this
change in the second step of the Create New Data Source wizard.

NOTE: You can download MDAC drivers from:

http://msdn2.microsoft.com/en-us/data/aa937730.aspx To configure the
client, start the Create New Data Source wizard, click the Client
Configuration button, and perform the following steps, based on the
version of the SQL Server ODBC driver you are using:

For SQL Server ODBC Driver version 3.50
Click the Net Library tab and use the drop down list box to set the 
default network (Net Library) to Named Pipes.
On the Advanced tab, remove any advanced entries that reference the 
server you are connecting to.
Click Done.
For SQL Server ODBC Driver version 3.70
In the Network Libraries section of the Edit Network Library Configuration 
dialog box, select Named Pipes.
Click OK.
If you do not have the MDAC ODBC drivers installed, you can use the
SQL Server Client Configuration Utility tool to set the default
Net-Library to Named Pipes. You can install the client utilities from
the SQL Server CD from the i386 directory.

Source: http://support.microsoft.com/kb/195566

answered Nov 15, 2012 at 20:19

SchmitzITSchmitzIT

9,1549 gold badges65 silver badges92 bronze badges

By default SQL Native Client seems to look for MSSQLSERVER instance. However, if you use SQLEXPRESS all connections through that will fail.

Very strange, but try installing your SQL Server with MSSQLSERVER instance name — it should work!

answered Feb 18, 2015 at 17:23

tonysepiatonysepia

3,3203 gold badges27 silver badges45 bronze badges

To create a new Data source to SQL Server, do the following steps:

In host computer/server go to Sql server management studio —> open Security Section on left hand —> right click on Login, select New Login and then create a new account for your database which you want to connect to.
Check the TCP/IP Protocol is Enable. go to All programs —> Microsoft SQL server 2008 —> Configuration Tools —> open Sql server configuration manager. On the left hand select client protocols (based on your operating system 32/64 bit). On the right hand, check TCP/IP Protocol be Enabled.
In Remote computer/server, open Data source administrator. Control panel —> Administrative tools —> Data sources (ODBC).
In User DSN or System DSN , click Add button and select Sql Server driver and then press Finish.
Enter Name.
Enter Server, note that: if you want to enter host computer address, you should enter that`s IP address without «\». eg. 192.168.1.5 and press Next.
Select With SQL Server authentication using a login ID and password entered by the user.
At the bellow enter your login ID and password which you created on first step. and then click Next.
If shown Database is your database, click Next and then Finish.

answered May 25, 2016 at 7:31

VahidVahid

912 silver badges3 bronze badges

Adding another check point to all the above answers. Valid if you are using a named instance of Sql Server ( ServerNameInstanceName)

Make Sure UDP Port is enabled in Windows Firewall with SQL Server Default UDP Port
Number 1434. If not present create a new incoming rule in Firewall for UDP 1434 Port and restart SQL Server Browser Services in SQL configuration Manager.

answered Jul 9, 2021 at 13:38

Источник

Lex1C

30.08.06 — 17:25

Есть компьютер на котором периодически возникает такая ошибка (1с 7.7, под скулем):

SQL State 01000, Native 64, Message:[Microsoft][ODBC SQL Server Driver][Named Pipes] ConnectionTransact (GetOverLappedResult())

SQL State: 08S01

Native: 64

Message: [Microsoft][ODBC SQL Driver] Сбой связи.

В чем тут проблема?

ТелепатБот

1 — 30.08.06 — 17:25

Lex1C

2 — 30.08.06 — 17:29

UP!

Ekaterina

3 — 30.08.06 — 17:41

(0) Убери протокол Named Pipes. Оставь только TCP/IP

Любитель XML

4 — 30.08.06 — 17:42

(3) какая вы умная. Наверное ещё и красивая. Фотку покажите?

avmlvm

5 — 30.08.06 — 17:42

(3) Не соглашусь имхо тут проблема, что «рвётся» коннект данной машины с сервером… Как вариант — нужно отключить режим спячки у сетевухи

Lex1C

6 — 30.08.06 — 17:43

(3) вопрос почему это проявляется только на одной машине из ста в таком случае?

avmlvm

7 — 30.08.06 — 17:43

(4) Ты бы не флеймил бы в тематических ветках.. Уважай Правила форума

avmlvm

8 — 30.08.06 — 17:43

(6) Чистай (5)

igork1966

9 — 30.08.06 — 17:45

(3) Наверное осталось выяснить как поставить протокол «Named Pipes»

Lex1C

10 — 30.08.06 — 17:45

(8) режим спячки у сетевухи не включен.

igork1966

11 — 30.08.06 — 17:46

(10) Небось сетевуха на Realtekе. Попробуй ее для начала поменять.

igork1966

12 — 30.08.06 — 17:46

(11) + пережать провод

Lex1C

13 — 30.08.06 — 17:47

+(10) хотя сори — посмотрел — действительно системе разрешено было отключать сетевуху.

avmlvm

14 — 30.08.06 — 17:51

(13) хм-м-м.. кто бы «сумливался бы» :-)))

Типичная фича :-)))

Ekaterina

15 — 30.08.06 — 17:56

(10) Не соглласна. Скорее всего версия драйвера ODBC старая.
Можно попытаться установить свежую версию MDAC

Lex1C

16 — 30.08.06 — 17:57

(14) странно что система отрубала сетевуху при работе в 1С…

avmlvm

17 — 30.08.06 — 18:10

(16) Да нет.. Она её всегда «рубила».. Но для других «случаев» это было не критично… Связь устанавливалась заново.. И для «обычных» ситуаций это было безразлично… Но вот для 1Ски — это было фатально.. Т.к. новое соединение «конфликтовало» с «незакрытым старым»…

Lex1C

18 — 31.08.06 — 18:54

(17) проблема осталась теперь просто «невосстановимая ошибка базы данных» уже не знаю на что и грешить..

avmlvm

19 — 31.08.06 — 18:57

(18) тогда как вариант или карточка глючит или порт хаба… короче.. попробуй поставить другую сетевуху и воткнутся в сетку «по иному»

А «невостановимая ошибка БД» это вроде другая опера.. Ты прогонял тестирование БД средствами 1С?

Lex1C

20 — 31.08.06 — 19:01

да не… база нормальная у других не вылетает в том то и дело

Lex1C

21 — 31.08.06 — 19:02

+(20) работает в этой базе куча народу с других компов. а Вылетает только у этой. Есть у меня подозрение на встроенную сисовскую сетевую карту…

avmlvm

22 — 31.08.06 — 19:04

(22) во-во.. или на гнилом шнурке сидит.. либо порт хаба глючит.. короче.. пропробуй их «поменять»…

Источник

Ответы с готовыми решениями:

[Microsoft][ODBC SQL Server Driver]Timeout expired
Установил SQL Server 2000, пытаюсь выполнить запрос, через 30 сек. выдаёт такое вот сообщение…

Microsoft SQL Server, ошибка: 18461
Здравствуйте! Столкнулся с проблемой… возможно распространенной, но решения, которые нашел в…

Ошибка импортирования из ERwin в Microsoft SQL Server
Скриншот во вложениии

Ошибка при установке Microsoft SQL Server 2012
При попытке установить Microsoft SQL Server 2012 вылетает ошибка, при том что нужный Framework…

Источник

Errors like SQL server connection failed SQLState 08001 can be really annoying.

The SQL server connection failed 08001 occurs when creating an ODBC connection on the Microsoft SQL.

At Bobcares, we often get requests from our customers regarding the SQL sever connection error as part of our Server Management Services.

Today, we’ll see the reasons for this SQL sever connection instance and how our Support Engineers fix it.

When the SQL Server Connection failed: SQLState 08001 Occurs?

Mostly the error SQLStateServer Connection failed 08001 occurs when creating an ODBC connection on Microsoft SQL.

We click Next on the SQL login screen. Then using the login information provided, the ODBC manager will try to connect to the SQL Server. But after some waiting time, it displays the below error message.

SQL Server Connection failed : SQLState 08001

The main three reasons for the error SQL Server Connection failure are

If we provide a wrong server name.
If the SQL Server not configured to a network connection.
The other possibility of this instance if we provide an incorrect login name or password.

How to fix SQLState 08001 Error?

Recently, one of our customers approached us with an error message ‘SQL Server Connection failed: SQLState 08001′.

Our Support Engineers log in to SQL Server Management Studio and make sure that the database name and other details are correct. In case, if the database server name is wrong then this error can occur.

Sometimes the message appears when we use ‘localhost’ as the Database Server name on the Database Settings screen in Confirm. But we can log in to the database in SQL Server Management Studio as a user, using the Server name ‘localhost’. Then our Support Engineers make any of the below two changes to fix the error.

In the Database Settings screen, we change the Database Server name to the server name or
In the SQL Server Configuration Manager, we enable the Named Pipes values in the Client Protocols.

Our Support Engineers follow any of the above two methods to fixes the error while creating an ODBC connection on Microsoft SQL.

[Need assistance in fixing the Error while creating an ODBC connection? – We can help you.]

Conclusion

In short, we’ve discussed that the SQL server connection failed SQLState 08001 occurs when creating an ODBC connection on the Microsoft SQL. Also, we saw how our Support Engineers fix the error for the customers.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = «owonCMyG5nEQ0aD71QM»;

Источник

Question

Answers

When the SQL Server Connection failed: SQLState 08001 Occurs?

How to fix SQLState 08001 Error?

Conclusion

PREVENT YOUR SERVER FROM CRASHING!