April 24, 2014 at 1:47 pm
This is the error I am getting:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
Checked TCP/IP: good to go
Firewall Issues: all OK
Running 3 different instances on the same server but no problem.
Any help from the community will be highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 24, 2014 at 2:33 pm
This issue has been solved
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 24, 2014 at 2:46 pm
New Born DBA (4/24/2014)
This issue has been solved
Out of curiosity, what was the issue?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2014 at 3:02 pm
My bad. I thought it was resolved but no.
I was able to restart the service but everytime I try to run a simple query. it gives me an error:
insufficient system memory in resource pool 'internal' to run this query:
Any help?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 24, 2014 at 3:05 pm
Is resource governor enabled?
It could also be a bug, do you have all the service packs applied?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 24, 2014 at 3:06 pm
Koen Verbeeck (4/24/2014)
Is resource governor enabled?It could also be a bug, do you have all the service packs applied?
Resource Governor is not enabled.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 24, 2014 at 3:19 pm
I just bumped up the MAX memory and enabled Resource Governor and its working fine now.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 28, 2014 at 7:56 am
I don't know if its too late for me to ask for some help since this post is 3 days old.
I bumped up the memory and I also enabled Resource Governor but it just started giving me errors again:
"Msg 701, Level 17, State 130, Line 1
There is insufficient system memory in resource pool 'default' to run this query."
Any help from the community will be highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 29, 2014 at 2:57 am
need a biot more info on the server spec and the resources assigned (such as max mem setting) to the other instances.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 1:07 pm
Perry Whittle (4/29/2014)
need a biot more info on the server spec and the resources assigned (such as max mem setting) to the other instances.
We have 6 instances running on VM. 1 DB for 5 instances but 2 DB just for this problematic instance. We have about 32 GB of memory. 5 Instances are set to 4GB of max mem and this 1 is set to 6gb since we have 2 DB.
I created another instance and put one of the DB on that and now all 7 instances are running fine. My question is that why would that instance act like this. I have seen people having multiple DBs on 1 instance but for me, it became a problem.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply