ISP Problem Solving Blog, Software Development and More

Mor-Pah.net

Category Archives: Uncategorized

Change MSSQL database owner / schema

Posted on by Posted in Uncategorized Leave a comment

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

Posted on by Posted in Uncategorized Leave a comment

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

Posted on by Posted in Microsoft, Uncategorized 1 Comment

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

Tesco Scan as you Shop

Posted on by Posted in Uncategorized Leave a comment

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:)

Tesco Scan As You Shop

Time will tell.

Jay Greig

Tesco Scan As You Shop

Hello

Posted on by Posted in Uncategorized Leave a comment

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