March 11, 2010 at 10:50 am
Hi:
I have a massive problem that seems to stem back to Sql, but I don’t know the first thing about the product (sorry! very lax of me).
I will be as brief as I can be...
We have just installed Sophos Puremessage onto a Microsoft Small Business Server 2003 SP2 Machine.
It insisted on updating it’s Sophos Control Centre from Version 2, to Version 4.
Having installed it, a number of OTHER systems on the server have failed. The Monitoring and reporting tool, the Backups (using the Volume Shadow Copy Service), and the Sharepoint site, Companyweb.
These all seem to tie back to SQL Server.
So, onto the bit that you guys like....
I've been sniffing around for info you may find useful, and have come up with this little lot.
Under the Microsoft SQL Server Folder, there are the following folders...
80 (no idea what this is)
90 (same as above).
MSSQL$ACT7 (Guess this is Act!, which is also on the server, and is working).
MSSQL$SBSMONITORING (this is failing).
MSSQL$SHAREPOINT (This is the companyweb I think, which is failing)
MSSQLSOPHOS (This is working)
MSSQL.1 (looks like it relates to ACT, which as I have said, is working)
MSSQL.2 (No idea!).
Now it also has a Microsoft SQL Server SP4 Folder, which looks like it relates to the MSDE, which to my understanding is a cut down version of SQL Server.
I’ve also noticed a MySQL folder on there (no idea why this is there – looks like some old legacy thing).
Now, I’m getting a lot (around one every 15 seconds) of these messages in the Application Log....
Event Type:Error
Event Source:Windows SharePoint Services 2.0
Event Category:None
Event ID:1000
Date:11/03/2010
Time:17:22:24
User:N/A
Computer:SERVER
Description:
#50070: Unable to connect to the database STS_Config on SERVER\SharePoint. Check the database connection information and make sure that the database server is running.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.%5B/i%5D
The Backup fails with this....
“Volume shadow copy creation: Attempt 1.
Timeout before function completed
Error returned while creating the volume shadow copy:0xffffffff.
Error returned while creating the volume shadow copy:ffffffff
Aborting Backup.”
And the companyweb web site, based on sharepoint gives me this....
“Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com.”[/i%5D
To my ‘layman’ brain I’d see that the Sharepoint database and the monitoring databases are no longer accessible (sorry for using all the wrong techie terms here!). This means to me that when the Volume Shadow Copy service tells the sql writer to back up the databases, it tries... can’t and then the whole backup fails.
So what I need is to be able to make these accessible again, but I have no idea how. I don’t believe there is any data corruption, but I don’t really know, nor do I know how to find out.
So your task (if you choose to accept it)..... is to tell me how to get these databases back online, so that the backup works again.
Finally, for info, we’re running
SQL Server 2005 (can't work out where it tells me the exact version - help anyone!!)
SQL Server Desktop Engine (SBSMonitoring) Version 8.00.2039
SQL Server Desktop Engine (Sharepoint) Version 8.00.2055
I’ve installed Microsoft SQL Server Management Studio Express Version 9.00.4035.00
SQL Server Native Client Version 9.00.4035.00
SQL Server Setup Support files Version 9.00.4035.00
SQL Server VSS Writer 9.00.4035.00
ALL windows updates are up to date.
Thanks SO Much if you've read this far..... thanks SO MUCH MORE if you can help!
4Data
March 11, 2010 at 12:32 pm
Are you able to launch SQL Server Management studio and connect to each of the instances you listed?
To find server version, run the following from SSMS
select @@version
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 12:38 pm
Check whether SQL services is running or not?
Try these steps it should fix.
http://support.microsoft.com/kb/823287
March 11, 2010 at 1:15 pm
Thanks for your help....
the SQL version is
"Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)"
And the Sql services do seenm to be running.
As I've said, I'm a complete numpty when it comes to Sql, so I think it's probably something so simple that you guys would see it in an instant. The only thing I've run into that to me seems odd is that if I try to connect to either the sharepoint or sbsmonitoring databases, using the management studio thingy, I get the following errors:
If I set the server type to "Database Engine" it tells me
"cannot connect to Server\sharepoint.
Additional information:
A network-related or instance specific error occurred while establishing a connection to the SQL Server.
The Server was not found, or was not accessible.
Verify that the instance name is correct and that the SQL Server is configured to allow remote connections (Provider: SQL Network Interfaces, error:26 - Error locating Server / Instance Specified) (Microsoft SQL Server)"
And if I set the Server Type to "SQL Server Compact Edition"
It comes back with:
"Cannot connect to Server\Sharepoint.
Additional Information:
The Path is not valid. Check the directory for the database. [Path=server\sharepoint]
(SQL Server Compact Edition ADO.NET Data Provider).
Now, I read that I need to go into some thing called the Surface Area Config utility to make sure that local and remote connections were set. I've gone into there, but I can only now see the Act7 and Sophos instances - I can't see the Sharepoint or Servermonitoring....? Is this right (I am assuming so, as they seem to be using msde rather than the full blown SQL package, but I really don't know, so want to point out anythign I see that may be wierd!!!).
Any further thoughts on what I can do. If I need to restore something from a backup, then I can, but I want to make sure that it'll resolve it before doing so (as I can't make any backups before hand, because of this issue).
Oh yes, one other thing I've found.....
If I go into the logs for the databases in question, I get the follwoing:
For the SBSMONITORING Agent, it tells me
" 2010-03-11 13:51:11 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2010-03-11 13:51:11 - ! [298] SQLServer Error: 53, ConnectionOpen (Connect()). [SQLSTATE 01000]
2010-03-11 13:51:11 - ! [000] Unable to connect to server SERVER\SBSMONITORING'; SQLServerAgent cannot start
2010-03-11 13:51:12 - ? [098] SQLServerAgent terminated (normally)"
And for the Sharepoint Agent, it tells me:
"2010-03-11 13:43:08 - ! [LOG] SQLAgent is not allowed to run
2010-03-11 13:43:08 - ? [098] SQLServerAgent terminated (normally)"
Thanks again to those reading, and I'll have your babies, to those answering!!!
4Data
March 11, 2010 at 1:17 pm
What were the results on the Development boxes? Did this happen to them when you installed it there? It could be the product is out scanning everything, and that is why you are receiving timeouts.
Have you contacted the company that makes that ridiculous product? Why are you running Exchange and SQL on the same box? Do you have a backup of the Sharepoint database and the sharepoint server?
Andrew SQLDBA
March 11, 2010 at 1:20 pm
It seems that your Sharepoint instance services are not running. Has a password expired or changed for the sharepoint account used to run the services?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:21 pm
AndrewSQLDBA (3/11/2010)
Why are you running Exchange and SQL on the same box? Do you have a backup of the Sharepoint database and the sharepoint server?Andrew SQLDBA
Just speculating, but since it is Small Business Server - it's an all in one install. Not very fond of that product - it's a pain to configure.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:24 pm
Is SQL server agent also running? Does these databases marked as offline\suspect\or any other state in SSMS?
March 11, 2010 at 1:28 pm
Hi Andrew, thanks for replying....
Development boxes.... oooh, how I dream of development boxes!!!!
It's a Small business server. No such thing as development boxes in a small business - no money unfortunately.
So it's a case of make it go live, and hope it's enough.
The Sql stuff and Exchange are all squeezed in there by good old Microsoft, out of the box, so I guess it's meant to work.
As for contacting the company, Sophos (a fairly big player in the world of Anti Virus, and anti Spam) .... yep I've been through to them. They are concerned, and are looking into it themselves, but are quite clear that it's really not thier product at fault (although the issue did happen during the installation of thier product!). Anyhoo, they are trying to help but not as actively as I would have liked.
Good news - yep, we do have a backup, and the backup software WILL Read it, but I'm a tad nervous about doing a thing now, because I can't make any backup beforehand.
Any advice, would be really lovely! (other than the obvious, 'buy a development box' etc).
4Data
March 11, 2010 at 1:29 pm
Jason
Looks like your get what you pay for using Compuke Edition of SQL and SBS of Windows Server.
Andrew SQLDBA
March 11, 2010 at 1:34 pm
Hi GTR, thanks for your comments. can you tell me how to find if the databases are marked as offline etc using the ssms - as I said before, it doesn't want to open them but it's quite possible I'v missed a way of seeing thier state.
March 11, 2010 at 1:36 pm
4data (3/11/2010)
Hi Andrew, thanks for replying....Development boxes.... oooh, how I dream of development boxes!!!!
It's a Small business server. No such thing as development boxes in a small business - no money unfortunately.
So it's a case of make it go live, and hope it's enough.
The Sql stuff and Exchange are all squeezed in there by good old Microsoft, out of the box, so I guess it's meant to work.
As for contacting the company, Sophos (a fairly big player in the world of Anti Virus, and anti Spam) .... yep I've been through to them. They are concerned, and are looking into it themselves, but are quite clear that it's really not thier product at fault (although the issue did happen during the installation of thier product!). Anyhoo, they are trying to help but not as actively as I would have liked.
Good news - yep, we do have a backup, and the backup software WILL Read it, but I'm a tad nervous about doing a thing now, because I can't make any backup beforehand.
Any advice, would be really lovely! (other than the obvious, 'buy a development box' etc).
4Data
4Data,
Can you answer my above question does database have any status when you refresh them? Did you check all the IIS settings and security settings mention in that link?
March 11, 2010 at 1:39 pm
4data (3/11/2010)
Hi GTR, thanks for your comments. can you tell me how to find if the databases are marked as offline etc using the ssms - as I said before, it doesn't want to open them but it's quite possible I'v missed a way of seeing thier state.
Run this,
select name, status, status2 from sys.sysdatabases
March 11, 2010 at 1:41 pm
Please verify that you have SQL Browser service running.
Verify that the account for Sharepoint Instance of SQL Agent is a valid account with valid password (not expired, etc).
Verify that The Sharepoint SQL instance is started. So far it seems that it is not. You should have several instances for sql server listed in services.msc.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:51 pm
Hi Jason, thanks for the hint towards the account used to run the services. Both services log on using the Local System Account, which I guess has no password. Is this right, or should they be logging on with a different one - maybe this is where the issue is??
REALLY Grateful to everyone for your help.
4Data
Viewing 15 posts - 1 through 15 (of 48 total)
You must be logged in to reply to this topic. Login to reply