February 24, 2011 at 7:29 am
Hello,
I have been asked if creating a template of a server which has an application and SQL installed, to then be deployed in a training environment, is recommended. It is currently used but we are having problems with SQL losing connection to local logfiles and disk space being taken by the error log. I cannot think of a reason for this apart from the fact they are deployed from template and could have issues with SID's or something similar.
Basic setup is a simple virtual server using VMFS storage for a single disk containing all os/app/db data.
I have checked the VMWare and other virtual server forums but cannot find any specific answers. For a production environment i think sysprep or clean install would be best.....but to create 20 standalone app/sql training servers that way would be a pain.
Thanks
LilyWhites
February 25, 2011 at 7:14 pm
SQL Server Express comes with User Instance which is a single user mode SQL Server so you have to convert it to server instance before you can use it for training. If you need to convert it to server instance then I can help.
Kind regards,
Gift Peddie
February 28, 2011 at 4:14 pm
hi gift peddie
i have not been shown the install process of the original server the template was created from but i know the application that uses express as the back-end is unable to function in single user mode....it runs a number of services which each have a persistant connection and there will always be at least 3 services running at any one time
i have seen a post in ssc (http://www.sqlservercentral.com/Forums/Topic807764-324-1.aspx#bm808239) that seems to point to someone having a problem when the server randomly starts in single user mode....which judging by the difficulty i have in recreating the problem and the fact it only happens to servers from a particular template....could be the problem....although im not sure how the user could keep using the application in this situation
i assume a user instance will show up in sql configuration manager....i will check tomorrow. if this is installed by default on this server but the user is given a local admin account to use would it have an effect??
i am trying to get them to create a new template and will ensure that i get involved in the sql installation and set it to a server instance. assuming that is done please can you let me know what else i need to be aware of, whether you need any more detailed info on how the server will be used, and what possible problems i could face.
the new version of our software will only run on windows/sql 2008 and we will be making the training servers available soon so anything that may be different for usage in the same scenario would be appreciated.
many thanks in advance
lilywhites
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply