I found a work around for now by creating a copy of the live database on my VPS server at HostMySite. Not a great way to develop but will get me by for now. I think you're right the best thing would be to just install express. I just wonder how I ended up installing the eval in the first place LOL. My only thought was that if I purchased a license and applied it to the eval, then I could revive the database. If I install express, I don't think it has any kind of import export abilities so I wasn't yet sure how I would pull down the data from the live database. I have a license for Red Gate so I will likely install that and use it to synch the data. Thanks everyone for listening to my desperate pleas for help. I suppose it could be much worse LOL. Dusty
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/10/2008 12:51 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Yes, that's my understanding too. But why not just install the free SQL Express edition? Is it that your bandwidth is enough for email but not a large download? (Or maybe you're writing from your phone?) I think you may find that you can't "apply" a license to SQL Server to update the eval edition to purchase. I seem to recall running into that hassle once before, but hopefully someone will have better news. You mentioned fearing you'd need to buy a new machine or fly back if you couldn't resolve this: isn't there some way to get good bandwidth, even at some dear cost, to do the download? /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 10, 2008 10:47 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I think the cost for a developer license of SQL Server is in the neighborhood of $50 - and it's the equivalent of enterprise. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Tuesday, June 10, 2008 10:28 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Haha poor little me in Costa. Yes beautiful country. I'm in Tamarindo shooting surfing photos (my side job) and trying to carry on development at the same time. I could have sworn I installed SQL Express but I think you are right because it doesn't say express in the event viewer. It might be easier for me to just pay the license rather than having to uninstall, reinstall, then piece the database back together (being that I can't get to it now). I can't seem to figure out how to just purchase the license though. Hopefully there is a development price. Do you know anything about this? Many thanks for your help. Dusty _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/10/2008 9:52 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you sure that's SQL Server Express? Yes, it should be free with no eval period. It sure sounds like it's the full version (not the express). Does the error in Event Viewer identify the source as the express edition? In my machine, it shows specifically as MSSQL$SQLEXPRESS? I see a couple other instances of people asserting your problem, and they said their only solution was to remove and reinstall. I really wonder though if they are really looking at errors from the Express edition. I'll trust your reply to confirm things in your case. :-) If you have no choice, are you able to uninstall/reinstall? BTW, though I received this before your other note about being desperate in Costa Rica (a seeming contradiction for such a beautiful country), I see that you sent this 2nd, so it seems you've at least targeted the real source of the problem, right? Glad that the suggestion to look in event viewer helped. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 9:28 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I checked event viewer under application. The errors for SQL say the evaluation period is over. I'm using SQL express though and thought it was free. Does this sound right? Dusty _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/09/2008 8:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you looking in the Windows Event Viewer, or SQL Server log files, to get more info? Also, as for your info on running multiple IIS sites on XP, there are still other ways including the free tool IISAdmin, at http://www.firstserved.net/help/downloads. Doesn't get around the limitation of *running* more than one at a time, but at least is an interface option over the command line option below. Hope that helps someone. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 3:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. So now that I figured out CF was stopping and causing this, I have that going again. But SQL will not start. Everytime I try to push the start button I get an error that says sometimes services stop because they have no work to do. I've tried rebooting. Does anyone know why SQL would stop itself and then refuse to start again? _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/09/2008 3:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: problem with IIS on XP Pro. Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic "Cannot find server" error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. ---------------------------------------- In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: . Create a command prompt window. . Type "cd \Inetpub\Adminscripts" and press enter. . Find out what the highest numbered site you currently have is. You can do that by typing . adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. . Add one to the highest numbered site. Then run this command: . adsutil.vbs COPY W3SVC/1 W3SVC/x Where x is replaced by the new numbered site. For example if you run the enum command and the highest numbered site is 4, then type this: adsutil.vbs COPY W3SVC/1 W3SVC/5 . Run the IIS Manager. You should find a new site has been created. It will be an exact copy of site #1, so you will need to change a few things. Go into the properties for the web site. Change the site name, and the virtual directory for the root of the web site to point to another location on the hard disk. Usually, you will create a new subdirectory under Inetpub and point the virtual directory at that. . To use the site, you must first stop the currently running site, then start the new site. To delete a site, first stop it if it is running (bad things happen if you don't!). Then type: adsutil.vbs DELETE W3SVC/x Where x is the number of the site you want to delete. ---------------------------------------------------------------------------- --------- Dusty ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
