March 11, 2010 at 3:57 pm
Thanks again Dan. It may help if I detail the SQL related services and thier states...
MSSQL$SBSMONOTORING.................Started, Automaitc
MSSQL$SHAREPOINT........................Started, Automatic
SQL Server (ACT7)..........................Started, Automatic
SQL Server (SOPHOS) .....................Started, Automatic
SQL Server Active Directory Helper.....Not Started, Manual
SQL Server Browser.........................Started, Automatic
SQL Server VSS Writer.....................Started, Automatic
SQLAgent$SBSMONITORING..............Not Started, Automatic
SQLAgent$SHAREPOINT...................Not Started, Manual
It's the last two that won't start and I reckon are the problem.
Having tried to start the SQLAgent$SBSMONITORING Service, I get a pop up message telling me "The SQLAgent$SBSMONITORING Service on local computer started and tehn stopped. Some services stop automatically if they have no work to do, for example the Performance Logs and Alerts Service."
In the event log (Application it gave me this.... Event Type:Error
Event Source:SQLAgent$SBSMONITORING
Event Category:Service Control
Event ID:103
Date:11/03/2010
Time:22:53:04
User:N/A
Computer:SERVER
Description:
SQLServerAgent could not be started (reason: Unable to connect to server 'SERVER\SBSMONITORING'; SQLServerAgent cannot start).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
For the SQLAgent$SHAREPOINT service I tried to start it, and I got the same popup message, and the following in the event log...
"Event Type:Error
Event Source:SQLAgent$SHAREPOINT
Event Category:Alert Engine
Event ID:324
Date:11/03/2010
Time:22:55:32
User:N/A
Computer:SERVER
Description:
SQLAgent is not allowed to run.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
Does that help at all?
March 11, 2010 at 4:26 pm
For grins:
Try stopping the sophos service and the windows firewall service.
Stop and restart the mssqlserver$sharepoint service as well.
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 4:54 pm
Stopped all the Sophos Services, and the firewall.
exactly the same.
I'm gibbering into my cocoa now.
Any more help would be very greatfully recieved!
March 11, 2010 at 4:59 pm
What SP level do you have Sharepoint at?
Please also check the event logs (application and security). Filter the results for those down to error messages. Let us know what you see in there.
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 5:22 pm
It's windows Sharepoint services 2.0 SP3
As I've said, the event log (application) is riddled with the follwoing, since this issue began....
Event Type:Error
Event Source:Windows SharePoint Services 2.0
Event Category:None
Event ID:1000
Date:12/03/2010
Time:00:15:35
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.
Nothing odd in the security log, otehr than a couple of failures as the user that I am logged in as, doesn't have access to ACT, but I've tried to open that a couple of times.
Head still spinning at the mo 🙁
Are there any other ways using SQL to simply roll back a configuration to the way it was a few days ago. I suspect not, as someone would have said, but it's worth asking!!!
Thanks
4Data
March 11, 2010 at 5:25 pm
4data (3/11/2010)
It's windows Sharepoint services 2.0 SP3As I've said, the event log (application) is riddled with the follwoing, since this issue began....
Event Type:Error
Event Source:Windows SharePoint Services 2.0
Event Category:None
Event ID:1000
Date:12/03/2010
Time:00:15:35
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.
Nothing odd in the security log, otehr than a couple of failures as the user that I am logged in as, doesn't have access to ACT, but I've tried to open that a couple of times.
Head still spinning at the mo 🙁
Are there any other ways using SQL to simply roll back a configuration to the way it was a few days ago. I suspect not, as someone would have said, but it's worth asking!!!
Thanks
4Data
What user are you trying to login as when connecting to the Sharepoint instance?
SA or NT or something else?
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 5:28 pm
Simply as the system administrator.
Should I try something else?
March 11, 2010 at 5:29 pm
Also, it appears that this is a common issue with SBS and sharepoint. Most of them appear to be just as difficult to resolve.
Here is one source of info that might help resolve. Unfortunately it requires an uninstall and reinstall. Still looking for other resources.
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 5:31 pm
GTR (3/11/2010)
4Data, don't rush go through this knowledge based article, do step by step.
http://support.microsoft.com/kb/823287
It has security settings information also.
Also, need to re-emphasize this article. But it is not looking very successful in your situation.
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 5:34 pm
Last few recommendations I have for now:
You'll never be able to start or access companyweb if cannot see
MSSQL$SHAREPOINT is not installed or running. My suggestion to you would be
to reinstall sharepoint services and companyweb.
Take a look at this document on how to remove and restore sharepoint and
companyweb.
KB829114
but first make sure you backup companyweb. this document will tell you how
to backup and do a disaster recovery on sharepoint and companyweb.
KB827701
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 5:35 pm
4data (3/11/2010)
Simply as the system administrator.Should I try something else?
That is 'sa' from SSMS, right?
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 5:35 pm
Jason:
I have to say, you are a real star. Thanks for all this help. I'm thinking like you that the uninstall / reinstall may be the only way, but I need to do that tomorrow. It's 00:33 and I'm flagging here.
PLEASE, if you do have any time, keep pumping this thread full of suggestions - I understand if not, but you guys are saving my hide at the moment.
Thanks a million, and I'll see what's been said in the morning!
4Data
March 12, 2010 at 12:52 am
Hi Jason (Or enyone else with the most basic grasp of SSMS....
I've not used it before downloading it yesterday. You ask if I'm ligging into the instance as 'SA' or 'NT' from within SSMS.... I really don't know how to. When I right click and go to properties, the authentication is set to 'Windows Authentication', and the username is my logged in, and greyed out username.
Now, since this server was installed, the passwords for all users have been changed, so would that cause these problems.... the issue is though, how would it cause the issues as the passwords were changed first, years ago. So why would it only affect it now?
when installing the Sophos products, it DID ask for a username and password, so I entered the current admin's username and password, not the one that was used when the server was set up (as that clearly wouldn't have let the Sophos product install).
I have the feeling that I'm barking up the wrong tree here - but I am looking around and I feel like I'm in a forest. Finding the right trree may be pretty tricky!
Thanks again for everyone reading and helping out on this.
4Data
March 12, 2010 at 1:00 am
The current admin account, are you referring to an account in the format of a domain account (yourdomain\yourlogin)? Or did you type in 'SA' for the user account and then some other password?
To login using SQL auth, there is a drop down box on that logon screen you described. You can select SQL Authentication from the dropdown. Once selected, then type SA in the box that used to show your greyed out user account. You will also need to supply the current password for that SQL account.
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 12, 2010 at 1:17 am
Thanks again Jason! (Don't you ever sleep???!)
Okay, yes, I'm talking about the Domain account. I am logged in as the overall system administrator in Windows.
I HAVE tried changing the Authentication to SQL Server Authentication. I've typed in 'SA' as the user.... but I don't have the faintest what the 'SA' password would be.
As this was all installed either by the Operating system or the applications, I simply don't have this information. I've tried it with no password.... no joy.
Now you've got me this far, I've been playign around though, and find that if I try to connect to one of the working instances - Sophos, using sa, and no password, I get a "login failed for use 'sa'" error. But if I try it on the Sharepoint Instance, it take about 15 seconds, and then gives me the following....
TITLE: Edit Server Registration Properties
------------------------------
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
My logic is that if it were simply a security issue, then this message would be the same for both.
Now, am I right in thinking that The Sharepoint and SBSmonitoring instances (both which fail) are tied in with the MSDE? Does that have a bearing, as I think the Sophos and ACT7 instances are purely Sql 2005 - and they both work
Thanks again, and sorry to be a thorn in your side!
4Data
Viewing 15 posts - 31 through 45 (of 48 total)
You must be logged in to reply to this topic. Login to reply