Viewing 15 posts - 16,561 through 16,575 (of 19,560 total)
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...
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
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...
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
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...
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:29 pm
4data (3/11/2010)
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...
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:25 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...
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:59 pm
I think an easier solution would be to backup the database and restore to the dev server via script and automated task. This can be done on a weekly...
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:39 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:26 pm
GTR (3/11/2010)
Ok, i think i overlooked at it. Then i think Check that instance name in services it may not be running, i was thinking only single instance on this...
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 3:38 pm
Thanks Dan.
That is an excellent item to bring up. Sophos quite possibly altered some firewall settings (if you have Windows Firewall enabled).
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 3:29 pm
ChrisM@home (3/11/2010)
CirquedeSQLeil (3/11/2010)
ChrisM@home (3/11/2010)
CirquedeSQLeil (3/11/2010)
Off to the desert I go (or should it be dessert 😉 ). Lynn is the tent available?
To paraphrase Nicole Kidman..."I get to sleep with...
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 3:18 pm
pshaship (3/11/2010)
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 3:17 pm
ChrisM@home (3/11/2010)
CirquedeSQLeil (3/11/2010)
Off to the desert I go (or should it be dessert 😉 ). Lynn is the tent available?To paraphrase Nicole Kidman..."I get to sleep with a hippo"
Glad...
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 3:05 pm
GTR (3/11/2010)
Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.
I've found it shows me the same sort of info, but when I double...
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 3:04 pm
Are you seeing deteriorating performance?
Your memory available could be a result of the AV and max memory setting on your SQL instance.
I suggest you go ahead and do the Grant...
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 2:55 pm
tosscrosby-60625 (3/11/2010)
sing4you (3/11/2010)
Need any musicians? :w00t:Always!
I can play my mp3's, does that count?
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 2:52 pm
Viewing 15 posts - 16,561 through 16,575 (of 19,560 total)