“Special midwifery service, Pat is on his way” “what’s it going to be today”
Category Archives: Uncategorized
Change MSSQL database owner / schema
Looking to change the schema/owner on a stored procedure that you’ve restored from a different MSSQL database server. The following took me a while to work out based on all the different options. sp_changedbowner did not work for me, I had to change the schema rather than the actual owner.
ALTER SCHEMA [new schema name] TRANSFER [old schema].[stored procedure/object]
example:
ALTER SCHEMA dbo TRANSFER databdev.sp_ASPBannner_DBinfo
This was annoying to find especially as I was initially getting ‘Cannot find the object ‘sp_ASPBannner_DBinfo’, because it does not exist or you do not have permission’ and similar errors.
Jay Greig
DCOM Config Security options greyed out
If you come across a similar issue to myself with Windows 2008 within Component Services that all of the security options in the majority of the DCOM Config entries are greyed out and you cannot change them you may need to do the following on the particular CLSID entry in regedit
1. Open regedit to 'HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\
{61738644-F196-11D0-9953-00C04FD919C1}' <- this is the CLSID of the app you wish to
amend
2. Right click the {61738644-F196-11D0-9953-00C04FD919C1} key and select
permission.
3. Next click Advanced and change the ownership from Trusted Installed to the
administrator account that you're using.
4. Re-open the component services/dcom config screen and you should now be
able to amend security on the CLSID.
The particular error I had was the following:
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{61738644-F196-11D0-9953-00C04FD919C1}
and APPID
{61738644-F196-11D0-9953-00C04FD919C1}
to the user DOMAIN\sharepointwa SID (S-1-5-21-3696552686-295401563-3087639421-4121)
from address LocalHost (Using LRPC) running in the application container Unavailable
SID (Unavailable). This security permission can be modified using the
Component Services administrative tool.
This actually turned out to be the IIS WAM Admin Component
IIS Rewrite Redirect Non HTTPS to HTTPS
A quick and simple method for forcing people to use HTTPS on a site. The code uses Microsofts IIS Rewrite which is an additional feature in IIS 7 and IIS 7.5. You can easily place the following code into the applications web.config and adjust accordingly, it maintains the subfolder/path string and won’t strip it out.
<configuration>
<system.webServer>
<httpErrors errorMode="DetailedLocalOnly" defaultPath="./error/404.html" defaultResponseMode="ExecuteURL">
<remove statusCode="404" subStatusCode="-1" />
<error statusCode="404" prefixLanguageFilePath="" path="./error/404.html" responseMode="ExecuteURL" />
</httpErrors>
<rewrite>
<rules>
<rule name="HTTP to HTTPS redirect" stopProcessing="true">
<match url="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" />
</conditions>
<action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Found" />
</rule>
</rules>
</rewrite>
</system.webServer>
</configuration>
There’s a few examples out there that don’t seem to work to great, but the above is tested and works just file.
Hope this helps people!
Jay Greig
RedBull Stratos
Brilliant achievement:
Megane off road
Just another image I took yesterday of the megane in a field after an interesting drive to work
Interesting Morning
Had an interesting drive to work today…..
megane off road
Tesco Scan as you Shop
So, last night went to my local Tesco superstore in Wellingborough to find that they had added a ‘Tesco Scan as you Shop’ service. Trust-based shopping at it’s (Tesco) finest. I wonder how much they’ve weighed the benefits of reducing staff, speed of checkout processing against a drop in profits from customers ‘accidentally’ not paying for things:)
Time will tell.
Jay Greig
- Tesco Scan As You Shop
Let’s go fly a kite
A song that’s constantly whirring around in my head at the minute!
Enjoy!
Hello
Hello all,
I’ve no idea why really but i’ve decided to setup wordpress on this site. The original content and open source projects will be here again soon, the server we had was flakey at the best of times so bare with me on that.
What i’m aiming to do is open this site for technical posting really. I work for an ISP and over the past 6 years I often come across challenges and as a natural born problem solver I wish to share some of what I’ve come to appreciate when building a reliable service.
I’ve a lot of work to do on the site especially as I have no idea about wordpress. In my line of work the only things I seem to ever hear are that someone’s wordpress has been hacked so maybe this isn’t the best choice, but, lets face it I’m even less motivated to build a new site from scratch at the moment:)
Check in again soon:)…. Now, how do I publish this….
J Greig