Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS SQL server loosing conectivity

Posted on 2013-07-01
7
318 Views
Last Modified: 2013-08-07
Hi,

I have a strange problem at one of my clients.
This client has one Hell of the SBS 2008, pimped-up to the nonsense. At first, they bought SBS 2008 from me, explicitelly said they do not need anything else, just a plain File server + domain controller. They requested me to set it up, then refused to pay for monthly SLA.

Ok, it has been 3 years since, and they called me to take a look at their SBS 2008, saying they have problems with SQL.
What SQL?

Woooohooo...I have never seen such a pimped up SBS :)
It has, beside SBS functionality:
- 1 MySQL database
- 1 Firebird SQL
- 1 MS SQL 2000 instance
- 2 MS SQL 2005 instances
- 5 MS SQL 2008 instances
- 1 Oracle VirtualBox virtual PC inside
- all volumes and shares have "Everyone" with Full Permissions granted
lol :))

Now, let's skip debate whether we should laugh or cry, and also must avoid any EXPENSIVE tasks. They do not have money, so 500 EUR is top they can pay for repair. Othervise they'll just switch back to work on each workstation separately.

Now, THE PROBLEM
All SQL databases were working fine for 3 years, until 2 weeks ago. Then SBSMonitoring DB got filled up to 4GB, which is top, and it begun drawing red circles in Event Logs.
At that moment most probably SOMEBODY did something nasty to SQL server, but there are 5 admins from 5 different applications, and it is impossible to know who did what.
The fact is, that from there on SQL instances begun refusing connections. Some applications worked for up to 5 minutes, then threw SQL Connection Error and froze.

Now, they called me.
First I sanitized blown up SBSMonitoring database, which I simply copied over from healthy source, put it into proper folder and started up SQL instance. All went fine (ok, SBS Console is unaware of server status, but doesn't matter).
But this did not solve SQL Connectivity Error.

I did some more insight excursion into SQL Management and found out, that most of SQL Admin roles simply vanished from SQL --> Security --> Logins!!!??? Simpy they were not there.
I called tech guy from one of application, and we re-created Admin role for their app in SQL...and Voila...this application raised up from dead. Working fine.

I thought kewl, we've got it...and recreated all other missing Admin roles...
...but this only repaired 3 out of 5 applications, which are using some SQL instance.

Now, the situation is:
- if run FROM SERVER directly, the application works fine
- but if run FROM CLIENT computer, some SQL error pops-up. Meaningless SQL error, different for each application.

Any idea what was going on with that server?
0
Comment
Question by:Andrej Pirman
  • 4
  • 2
7 Comments
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39291958
I would need to see the connection strings and the error (MEANINGLESS OR NOT :))
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39292064
pleased somebody said it:

Meaningless SQL error, different for each application.
suggest you supply these - they may not be so meaningless

that said: that client needs quite a deal of education, I sympathize.
0
 
LVL 18

Author Comment

by:Andrej Pirman
ID: 39292366
Hi,

I know that "meaningless error" might also be of some help, but it all depends upon where the client is at the moment inside the application, what he/she is doing, but the culpit of all of them is that all errors are somehow SQL connection related.

I'll get back with some of those errors later today, when I will be back on site.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39292391
My apologies - I must have accidently hit the caps lock - I didn't intend for "meaningless error" to be in upper case. But yes please - post errors with details of where they are occurring and we'll see what we can work out...
0
 
LVL 18

Author Comment

by:Andrej Pirman
ID: 39343208
Hi,
sorry for not getting back - vacation.

Well, 3 weeks it was all fine after some general sanitazing work in server (replaces SBSMonitirng db, scandisk, cleaned temp files, defrag, installed updates etc.), but now again, the same problem. SQL application works for 1-15 minutes, enables entering some dozen SQL queries...then refuses to connect. Quite random.

Error:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

I've already tried the following:
- PING is constant, no errors, no lost packages, under 1ms
- absolutelly NO errors on server-side SQL log. Only on client-side.
- no errors on server-side event logs
- the same application works if run on SERVER, meaning there is nothing wrong with SQL database itself
- on server I added SynAttackProtect parameter for this network card, following this guide: http://support.microsoft.com/default.aspx?scid=kb;en-us;899599

Any other idea?
0
 
LVL 18

Accepted Solution

by:
Andrej Pirman earned 0 total points
ID: 39378484
So far no problems!
Seems like the last modification solved the problem:
- on server I added SynAttackProtect parameter for this network card, following this guide: http://support.microsoft.com/default.aspx?scid=kb;en-us;899599
0
 
LVL 18

Author Closing Comment

by:Andrej Pirman
ID: 39388623
No other relevant suggestions were provided.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question