SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server connection rejections and client application management


SQL Server connection rejections and client application management

Author
Message
chajeeva
chajeeva
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 19
Scenario:

1. Connect to a remote SQL server from a client SQLWB window and run SP_WHO2
2. Consider, the SQL Server's network port is being unplugged
(or SQL server is no longer available due to being shutdown or a network problem/Disconnect the SQL server machine’s Ethernet port)
3. Wait for 5 min
4. Reconnect the SQL Server's network port
(SQL server is restarted or a network problem has been resolved/Connect the Ethernet port back)
5. Run the same sql statement SP_WHO2(in the same window created in step 1) without doing any changes to the connection or to the window itself
6. It will get you the connection as closed or with some error

Will this be a case of,

Fatal error ?
The client closed the connection?
The server itself killed it?

Our requirement is to develop a program:

To keep track of the rejections occurred by the fatal error
To monitor connections which were rejected by SQL Server and the cause behind it
The best way to detect when SQL server is no longer available due to being shutdown or a network problem.

Also need the following:

What are the scenarios for fatal error?
What are the instances were a connection is killed by a Server without the knowledge of the client?(It’s irrespective of the type of error responsible for this)
In case of network downtime or no network, who is taking care of connection status? (Client or Server ?)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search