July 27, 2013 at 12:54 pm
Dear all,
Please can you help me? I have a big problem with SQL server 2012 installed on the windows server 2012 :
I have three Databases on a named instance 192.168.1.1\BIOUGNACH2012SP1 and some time the end users try to connect to one of the three databases (for example to the first company: Biougnach équipement) but the connection failed, for the two other databases it's work correctly.
So I change just the IP address of the machine(end user) to a new one and when I try again the connection work correctly.
for more information :
- when the machine is blocked I ping on the server address and the ping work correctly.
- I have disable firewall on the windows server 2012.
- The application connected to 3 databases (3 company) in the same server and named instance.
- I use the same connection string in the application, I change just the database Name, I use the same user/password for the three databases.
Please Help me.
July 27, 2013 at 3:05 pm
What exactly is the error message that users get when they try to connect?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 27, 2013 at 4:37 pm
Une erreur de niveau transport s'est produite lors de la réception des résultats du serveur. (provider: Fournisseur TCP, error: 0 - Le nom réseau spécifié n’est plus disponible.) à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
à System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
à System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
à System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
à System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
à System.Data.SqlClient.TdsParserStateObject.ReadByte()
à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
à System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
July 27, 2013 at 5:01 pm
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
July 27, 2013 at 5:06 pm
I think this is a transport error, because I have use SQL profiler to see is that the server has received the request and also he answer or not, and I found the request and response as
"Audit Login" & "RPC: Completed exec stored procedure name" & "Audit Logout"
Many thanks for your understanding
July 28, 2013 at 1:02 am
Yes, this is a problem in your network somewhere. You should be able to produce this problem by sending a query that produces a result set of some size, and in the middle of it, pull the network cable.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply