Posted on 2014-08-19
We are using a program that links to a SQL database on our SBS 2008 server. users are constantly being kicked out of the program with connection errors to the database on the workstation end such as
"07/21/2014 13:14:17 Error detected by CheckConnection; Error = TCP Provider: The specified network name is no longer available.
Communication link failure
; StateNativeOrigin = State:08S01,Native:64,Origin:[Microsoft][SQL Server Native Client 10.0]
State:08S01,Native:64,Origin:[Microsoft][SQL Server Native Client 10.0]
; RetCode = -1
On the server end, in the event log, i see under application log Event ID 1105 SOURCE:MSSQLSBSMONITORING
"could not allocate space for object 'dbo.eventlog' in database sbsmonitoring because the PRIMARY filegroup is full.
I checked and I have plenty of disk space on all my drives so not sure what is full and how to make more room or if that is even connected to the constant kicking off the programs at the workstation.