Questions tagged as ['sql-server-2014']

Microsoft SQL Server 2014 is a version of the relational database management system designed by Microsoft, released on April 1, 2014.
Score: 0
James avatar
SQL Server 2014 enterprise edition suddenly stop accepting the connections
us flag

We are seeing that our server will suddenly stop accepting new connection from SQL Server. The server itself is still accessible via RDP, but sharepoint portal/SSMS and any other remote SQL connection will timeout. Configuration manager shows that SQL Services are running, but if you attempt to stop/ restart the services manually, it will hang. Restarting the server will sometimes let the services go ba ...

Score: 0
James avatar
error 17054 severity 16 state 1 sql server 2014 enterprise edition
us flag

Our new database is just inaccessible. I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL Agent, and SQL Server services were stopped, and then tried to restart it just hung and because of that, I have to do a reboot. It is a production server and this is a recurring issue. It happened a month a ...

Score: 0
How to determine the common name (CN) for a microsoft sql certificate?
kz flag

I'm in the process of trying to set up a self signed certificate for connecting a jetty server to a development sql database. I'm following the instructions here: but I've run into a bit of a roadblock. When I try to install the certificate in sql server manager, no certificates are showing up in the dr ...

Score: 0
haemse avatar
MS SQL-Server 2014 - Is it possible to trigger an Event/Script, when a certain Query comes along?
bd flag

I'd like to have the possibility to accomplish a certain routine (fi. trigger a external node script or any kind of script/method whatever), when certain queries come along in MS SQL Server 2014.

Is there a way to accomplish that? (worst case - monitoring log events?)

Im used to SQL but a beginner on MS SQL Server

Score: 0
Ernst avatar
SQL Server Load Balancing Splitting Read/Write Operations
jp flag

Hello We have 3 nodes of SQL Server 2014 Standard Edition one of them as primary and the other one as Replication of the Primary using Transactional Replication database

We want to use the other 2 nodes to read operations and reduce the load of the primary node.

How could we configure in a load balancer like HA Proxy to split read operation from writes and send to node 2 and 3 only read operations?  ...