Wednesday, August 25, 2010

Self-hosted WCF service with SSL certificate security

Spent the whole day trying to force my self-hosted service to respond.

Finally what has helped is two lines below to execute (port, certhash, path and user name are up to you. Not sure about appid yet :-) ):

netsh http add urlacl url=httpS://+:2202/PatientService user=DOMAIN\user

netsh http add sslcert ipport=0.0.0.0:2202 certhash=ea81a9b4c330247f966d23d7e21266171f92cd47 appid={4EF5AB95-0A11-43b1-842C-51D56687CC7A}

Now need to understand - WHY??

Thursday, July 08, 2010

Tuesday, April 20, 2010

SQL Server 2008 setup: Error "Restart Computer Failed"

When trying to install SQL Server 2008 I found that it requires me to restart computer even after I did it two times.
It was really bad.

However, there are kind people around!
Especially here:
http://www.sqlcoffee.com/Troubleshooting051.htm
So the reason was in pending after-reboot file copying requested (and never performed)

I believe this might cause some mistakes if you really have pending files, so make sure to reboot first.

Thursday, February 04, 2010

Needed to script the MS SQL database including data.

Strangely :-), but Microsoft did it well:
http://blog.sqlauthority.com/2007/11/16/sql-server-2005-generate-script-with-data-from-database-database-publishing-wizard/

Visual Studio 2008 also have such tool built in.

(However I am not sure about complex databases (like encrypted) yet...)

Friday, January 22, 2010

how can I set the authentication mode for a SQLServer from code?

Change
HKLM\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\LoginMode
1 = integrated only, 2-mixed

For you will need to use MSSQL.n, where n relates to the instance you are interested in. You can find the right value by looking at HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQLame, and looking for the value that matches your instance name. SQL Express has an instance name of SQLEXPRESS, and the default SQL 2005 instance has a name of MSSQLSERVER. (on my box ...\Instance Names\SQL\SQLEXPRESS has a value of MSSQL.4)

From here: http://www.sqlservercentral.com/Forums/Topic439615-359-1.aspx

Thursday, January 21, 2010