Error: A connection was successfully established with the server, but then an error occurred during the login process.

Question

Hi There,

I have MsSql running in clustering environment and recently am facing the problem where there is a security agent installed in MsSql server, whereby the agent does nothing but to only capture local database activity. The error prompted is as below:

Step ID             1

Server               NIBKSQLCLUST

Job Name                      LSBackup_DRIB

Step Name                    Log shipping backup log job step.

Duration                        00:00:02

Sql Severity                   0

Sql Message ID             0

Operator Emailed                      

Operator Net sent                     

Operator Paged            

Retries Attempted                      0

 

Message

2011-03-21 08:00:02.62  *** Error: Could not retrieve backup settings for primary ID '26f46141-a676-41b2-8653-11f1b13de43a'.(Microsoft.SqlServer.Management.LogShipping) ***

2011-03-21 08:00:02.63  *** Error: Failed to connect to server NIBKSQLCLUST.(Microsoft.SqlServer.ConnectionInfo) ***

2011-03-21 08:00:02.63  *** Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)(.Net SqlClient Data Provider) ***

2011-03-21 08:00:02.63  ----- END OF TRANSACTION LOG BACKUP   -----

 

The process run successfully when I have turned the security agent off. Kindly advice the cause for this issue and is there any configurations need to be set/changed in MsSql server.

 

Thanks,

Boonlep Chua

Answer 1

Please check what the "Security Agent" is actually doing. Most likely it is running a server side trace. You may need to modify the events that it captures.

From the Job error log, SQL Server Agent was unable to connect to the instance at that moment.

---

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @PradeepAdiga

Answer 2

Hi boonlep,

What kind of Security Agent you have used? For some Security Agent, it may cause some problems.

Security Agent may block sqlmaint.exe. For more information, you could refer to
http://www.cisco.com/en/US/products/sw/voicesw/ps2237/products_tech_note09186a0080916f86.shtml

Here are links about multiple vulnerabilities in Cisco Security Agent:
http://www.cisco.com/en/US/products/products_security_advisory09186a0080b1910d.shtml
https://www.cert.be/pro/advisories/cisco-security-agent-multiple-vulnerabilities

So you could turn the Security Agent off to make your process run successfully.

 

Hope this helps,

Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.