Click here to Skip to main content
14,931,892 members

S Douglas - Professional Profile



Summary

    Blog RSS
2
Author
3,549
Authority
5,054
Debator
12
Enquirer
654
Organiser
2,989
Participant
0
Editor
Just another hack, who manages to take care of issues that would otherwise go unsolved. Smile | :)

 

Reputation

Weekly Data. Recent events may not appear immediately. For information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilver
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSubEditor, Mentor, Protector, Editor
Store personal files in your account areaplatinumplatinumSubEditor, Editor
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Edit a Question in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Edit an Answer in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Delete a Question in Q&AYesSubEditor, Protector, Editor
Delete an Answer in Q&AYesSubEditor, Protector, Editor
Report an ArticlesilversilversilversilverSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubEditor, Mentor, Protector, Editor
Edit other members' articlesSubEditor, Protector, Editor
Create an article without requiring moderationplatinumSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending QuestionProtector
Approve/Disapprove a pending AnswerProtector
Report a forum messagesilversilverbronzeProtector, Editor
Approve/Disapprove a pending Forum MessageProtector
Create a new tagsilversilversilversilver
Modify a tagsilversilversilversilver

Actions with a green tick can be performed by this member.


 
GeneralSQL Server Errors Pin
S Douglas27-Oct-10 4:40
professionalS Douglas27-Oct-10 4:40 
GeneralRe: SQL Server Errors Pin
S Douglas6-Jul-11 11:16
professionalS Douglas6-Jul-11 11:16 
GeneralSSAS - Processing Error Pin
S Douglas22-Oct-10 20:58
professionalS Douglas22-Oct-10 20:58 
GeneralRandom bits of SQL Pin
S Douglas24-Sep-10 4:12
professionalS Douglas24-Sep-10 4:12 
GeneralRandom bits of SQL Pin
S Douglas24-Sep-10 4:10
professionalS Douglas24-Sep-10 4:10 
GeneralRandom bits of SQL [modified] Pin
S Douglas23-Sep-10 11:52
professionalS Douglas23-Sep-10 11:52 
GeneralTSQL Case statement Pin
S Douglas23-Sep-10 11:26
professionalS Douglas23-Sep-10 11:26 
General(6 years, 2 months) Pin
S Douglas9-May-10 21:03
professionalS Douglas9-May-10 21:03 
GeneralSSAS Backups Followup Pin
S Douglas1-Jul-09 18:23
professionalS Douglas1-Jul-09 18:23 
GeneralCatch up.... [modified] Pin
S Douglas29-Jun-09 8:26
professionalS Douglas29-Jun-09 8:26 
GeneralSSAS Backups Pin
S Douglas27-Apr-09 4:07
professionalS Douglas27-Apr-09 4:07 
GeneralRandom Junk Pin
S Douglas25-Apr-09 21:17
professionalS Douglas25-Apr-09 21:17 
GeneralSSAS Best practices Pin
S Douglas24-Apr-09 3:57
professionalS Douglas24-Apr-09 3:57 
GeneralSSRS... Pin
S Douglas20-Apr-09 10:44
professionalS Douglas20-Apr-09 10:44 
Okay so I have a new challenge on my plate. First off I know it sounds like I’m constantly bitching about things, but blogging is really is just a good place to complain. No one really cares about blog anyways. Smile | :)

So this weekend our SQL Server Reporting Server decided to up and roll over. The web portal was up to serve reports, but every one of the reports would error with some type of permissions issue. Nothing had changed on the server, and I mean nothing that I can tell has changed, it’s the weirdest thing. Now mind you I’m not the one who handles reports or deals much with the reporting services, my boss just said okay everyone, time to get up at 05.20 on Sunday morning and troubleshoot this issue (which is when it was first noticed). Turns out, that the report server started having health issues Saturday morning. The web front end can’t connect to its internal dB, the database for reporting services is up and running just fine it’s the internal engine that appears to be off in lala land.

So much so in fact, we can’t connect to it to do any report admin or push new reports. It’s really got me perplexed. I’ve not yet found a resolution for the issue and will post it as soon as I do, but for the time being we got past the outage by opening permissions up on the DW dB side.

For what its worth, here is the error message I’m seeing in the event log.

Event Type:	Error<br />
Event Source:	Report Server (MSSQLSERVER)<br />
Event Category:	Management <br />
Event ID:	107<br />
Date:		4/20/2009<br />
Time:		9:30:02 AM<br />
User:		N/A<br />
Computer:	xxxx<br />
Description:<br />
Report Server (MSSQLSERVER) cannot connect to the report server database.<br />
<br />
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


There is also this weird error message, but its been occurring for quite some time now

Event Type:	Error<br />
Event Source:	DCOM<br />
Event Category:	None<br />
Event ID:	10016<br />
Date:		4/20/2009<br />
Time:		11:40:44 AM<br />
User:		NT AUTHORITY\NETWORK SERVICE<br />
Computer:	xxxx<br />
Description:<br />
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID <br />
{BA126AD1-2166-11D1-B1D0-00805FC1270E}<br />
 to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20).  This security permission can be modified using the Component Services administrative tool.<br />
<br />
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I’m suppose to be working on a new Cube, and modifications to a couple of existing cubes, but that’s been put on hold while I try and come up with a solution to this issue. Gotta love working in a small team eh?


Common sense is admitting there is cause and effect and that you can exert some control over what you understand.


GeneralSSAS... Pin
S Douglas2-Apr-09 17:59
professionalS Douglas2-Apr-09 17:59 
GeneralSSAS from the trenches Cont... Pin
S Douglas11-Mar-09 18:33
professionalS Douglas11-Mar-09 18:33 
GeneralSSAS from the trenches (Cont...) Pin
S Douglas11-Mar-09 18:07
professionalS Douglas11-Mar-09 18:07 
GeneralSSAS from the trenches Pin
S Douglas11-Mar-09 17:52
professionalS Douglas11-Mar-09 17:52 
GeneralCode formatting Pin
S Douglas23-Jan-09 19:18
professionalS Douglas23-Jan-09 19:18 
GeneralRe: Code formatting Pin
S Douglas21-Feb-09 9:16
professionalS Douglas21-Feb-09 9:16 
GeneralRe: Code formatting Pin
S Douglas21-Feb-09 9:20
professionalS Douglas21-Feb-09 9:20 
GeneralWhats happening Pin
S Douglas21-Feb-09 13:13
professionalS Douglas21-Feb-09 13:13 
GeneralHEHE Pin
S Douglas21-Feb-09 13:15
professionalS Douglas21-Feb-09 13:15 
GeneralMap printer, vbscript Pin
S Douglas23-Jan-09 19:11
professionalS Douglas23-Jan-09 19:11 
GeneralDelete files, vbscript Pin
S Douglas23-Jan-09 19:07
professionalS Douglas23-Jan-09 19:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.