Check your network documentation. (SQL-08S01)(DBD: st_execute/SQLExecute err=-1)Could you please help to find where the cause of this error can be?I'm struggling on this! So if you have more than 10 computers connection at the same time there could be a problem for the Desktop version of 2000 as the extra computers will not gain You cannot delete your own events. There may just be a limitation of the ODBC driver that is causing the issue if there are a lot of users connecting at the same time. http://dssoundware.com/sql-server/error-01000-microsoft.php
Could that mean that another application from the same system is using the same port for sqlservr.exe that might be causing the issue? Please let me know if you have additional questions that might help troubleshoot this issue. If they still have all of the correct settings I would guess there is a network hardware issue and crappy switching. Byrd, BSSE MCDBA MCADBusiness Intelligence AdministratorMSBI Administration Blog Post #159445 Erico Galdino AlmeidaErico Galdino Almeida Posted Thursday, February 10, 2005 11:57 AM Forum Newbie Group: General Forum Members Last Login: Thursday,
You cannot delete your own posts. http://support.microsoft.com/kb/2775511Network Hardware we use: Dell PowerConnect 5324 Switch (Main Switch), Cisco sf200-24p Switch ( multiple all around the company), Netgear WNDAP660 AP (Main AP), SonicWall TZ 210 (Main Firewall) DHCP That is what you are going to have to look at to find a solution here as you have the full version of SQL and I'm taking it that you have I love tuning queries for optimal performance, and automating tasks.
Post #1240188 « Prev Topic | Next Topic » Permissions You cannot post new topics. 08s01 Communication Link Failure There were a few items in the newsgroups when I searched via Google for "SQL-08S01" but most of them were either a post of the problem with no replies or not To reiterate Col's statement of that this could be just about anything: SAN attached cluster, W2K3x64 SP2. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7bcc671a-595b-43f0-af7d-6d501c18a85c/error-08s01-microsoftsql-native-clientcommunication-link-failure?forum=sqldatabaseengine The problem sounds a little fishy as I have used TCP/IP for ages without any problems like that.Thanks for keeping me posted!
Any suggestions to where to check, would be much helpful! Odbc Error 08s01 Some of the POE ports are used to power the APs and others to power some surveillance cameras that come with POE options. How should I manually configure set up a DSN entry on each computer for the SQL Server? When I installed a new Server application I installed SQL 2005 and the medical program didn't work as it's only been written for SQL 2003.
What are the make and models of your client switches? 0 Poblano OP pkapas1991 Aug 21, 2013 at 4:56 UTC Rockn, What exactly am I looking for in https://support.microsoft.com/en-us/kb/891062 We're running Microsoft SQL Server 2008 with SP1 installed and all the other updates installed as well. [microsoft][odbc Sql Server Driver]communication Link Failure Is that of any concern? Microsoft Sql Server Native Client 10.0 Communication Link Failure Could it be that the accounting software we use could be interfering with Visual Shop?
The companies solution is to wait a few months till the next rewrite of their program becomes available which will be SQL 2005 Compliant. this page You cannot post new polls. I would look at your: ImisWebServerUrl variable on your iMIS App server/SQL server. http://support.microsoft.com/kb/2775511Client PCs: Windows 7 64-bit SP1 with all Updates, including the 2775511 enterprise hotfix rollup updated. Error [08s01] [microsoft][sql Native Client]communication Link Failure
As far as I can tell all the 1433 port connections are only the sqlservr.exe, but there are multiple of them becuase it seems that it also lists all the computers You cannot post HTML code. You should only lose connection to the SQL server 0 1 2 Next ► This discussion has been inactive for over a year. http://dssoundware.com/sql-server/error-01s00-microsoft-odbc.php You cannot delete your own topics.
Not a member? Microsoft Odbc Sql Server Driver Dbnetlib General Network Error Check Your Network Documentation Thanks! 0 Tabasco OP MargieT Aug 21, 2013 at 3:09 UTC I'll provide troubleshooting instructions for your review. If you set up a DSN entry on each computer are they all having the same issue? 0 Poblano OP pkapas1991 Aug 21, 2013 at 2:51 UTC Thank
Join Now So we've been having issues with network connection loss at our company with the SQLSTATE = 08S01, or SQLSTATE =08001 error message. Additionally, they may only occur during times of high network load on the server. Rgs, K28.5 0Votes Share Flag Collapse - sqlstate = 08S01 [microsoft][odbc sqlserver]communication link failure by burtonnirmal · 8 years ago In reply to sqlstate = 08S01 [microso ... useful reference could it be from the application or from the mssqlserver itself or from network.
http://itsolutions.intuit.com/support/articles.asp?how=&mode=detail&kcriteria=&sVersion=&ID=254This is the Microsoft article about the problem:http://support.microsoft.com/kb/164167/EN-US/Well, I changed the configuration of my ODBC connection, as told in the first link (change from TCP/IP protocol to Multiprotocol).But every time I In this case, you will either have to configure the server for Standard or Mixed Security, or change the default network library to Named Pipes or Multi- Protocol, using the SQL Since 1998, I’ve been working with SQL Server, since version 6.5. Career-wise, it would be the journey to earning my MCM.
I checked within Data Sources (ODBC), under System DSN, and it says SQL Server. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended. What version of SQL server and Windows Server are you running on. What exactly do you mean by set up a DNS entry on each computer?