Server ertificates and "Log on as:"
Posted on 2009-04-06
I'm attempting to configure an 05 Express install running on an Amazon's EC2 winserver05 instance. Because data is not persisted on the c: drive when an instance is terminated (and since this is a development/testing box, I'll be terminating this server quite often) I'm trying to relocate the system databases to e: drive which _is persisted. I've also copied the .cert files from the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data path to the new path.
So far, I've made the necessary adjustments to the point that I can run sql with all system databases living in the e: drive. But I'm getting an error tossed during service startup: 'An error occurred during decryption.' And the service refuses to start under anything except Network Service.
Since this box/install is only a testing/dev server, perhaps I shouldn't worry too much about it but running the service at that level doesn't seem right. And down the road I may want to have this db interacting/replicating to production servers.
To date, i don't have any data populated and am actually thinking i might be best off to create an install script that would let me specify my preferred paths and start the whole thing off from scratch. But something tells me if i re-gen the server certs and tweak some user accounts correctly I'll get this running without a reinstall.
thoughts and guidance much appreciated.