I've been paying $160 a month for a dedicated server that runs my web application and my mssql 2008 database.
Due to the economic times, I've been searching for a cheaper alternative... This gets me thinking... Wouldn't this be a good business plan for VPS companies?
Include 4-5 databases on a extreme, high-performance MSSQL server for all windows vps.
I know there are current setups like this, but no host really emphasizes the power of their mssql server. If they show how their db server is extremely fast, customers would be less likely to try and run their own express version on the vps. Thereby decreasing ram/cpu load on the vps, and increasing the overall efficiency of the dedicated server running the vps'.
Are there any hosts that currently market like this? If not, why don't you?
With Windows 2003 server, there are comprehensive lists of what you need to do to secure the server before use. For Windows 2008, I wonder is there such a list? Or is it true as what I heard from Microsoft that it is already secured out of the box?
Anyone has any resources on the hardening or preparation of 2008 for server hosting uses?
I'm making a reasonably uninformed comparison here. Since Windows Vista is noted to be more resource intensive and slower than Win XP, are we right in assuming that Windows 2008 is slower than Windows 2003?
For instance, with two boxes with an identical hardware setup but the two different server OSes, will the same application like, say MySQL run slower on the Win 2008 machine?
I've got MSSQL 2005 Enterprise running on Windows 2003 Standard R2 x64. The server has 12GB RAM.
Now, I've been trying to find some way to monitor how much RAM MSSQL takes up, but found two conflicting things.
One source says that MSSQL 2005 Enterprise can only use up to 4GB RAM on Windows Standard R2 x64. Another says Microsoft changed this to 32GB for Windows Standard R2 x64 only (i.e. not x86).
Could anyone confirm either of these? I'd find out myself if I knew how I could see how much it's using (it only shows 90mb in taskmanager).
I restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
We received the following request from customer in order for his website to function properly:
Go to the control panel of your Windows Server change Regional Settings so that the default language iS Greek.
Also, change the collation of Microsoft SQL Server to Greek-Accent Insensitive-Case Insensitive.
Will these create any problems to the rest of the websites that are hosted on the server? And if no, how to change the collation of the Microsoft SQL Server?
I downloaded a windows 2008 iso file onto my centos 5 server, How can i mount the iso file and boot it in rescue mode over serial port? I am wanting to install windows instead of centos.
I have an account which used a remote MSSQL server which I have since deactivated, but before deactivating I forgot to remove the DB and Server from plesk.
So now I can't remove the remote MSSQL server from plesk as there is a DB associated with it, and I can't remove the DB because it obviously can't find the remote server! I'm now stuck in a loop!
How I can force remove the DB/User from plesk and then the remote server ? I'm now receiving errors whilst backing up the account, so needs to be done.
I have Plesk 12 on Windows Server 2012 and SQL 2014 Express, and I am unable to add the SQL server to Plesk. It looks like it is waiting for a long time for something, then I get this error:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)Click to expand...
I am using Plesk 11.5.30 Update #39. The statistics in not updating the mssql database size. It is always showing 0. I am attaching the screen shot. This account has 2 mssql 2008 database and uses 70MB. In plesk it is showing as 0 MB.
We are not able to block the account for mssql over usages.
I notice that the Windows 2008 Firewall has some default setting opened, wonder what are the ports opened for? Anyone can give any idea? Can I close them?
i wanted to buy a dedicated server and when i had questions about 2003 web, i talked to hivelocity live support and i think it was dave who told me that Windows 2003 web has a restriction for mysql which was 512 KB. I myself is planning to own a gameserver that uses java and mysql and i know for sure uses much much more space than 512 KB. Is this true that 2003 restricts the size of your DB and when your DB reaches 512 kb, it can no longer be used? Also, is the windows 2008 web licensing fee the same as windows 2003 web?
I am about to move my site to a dedicated server. My current site is running on PHP and MYSQL on a Linux box (shared host), but I am familiar with Windows/IIS so I decide to run the site on Windows 2008 instead of Linux on a deciated server.
Before I begin to move, I would like to ask for your experience. Have anyone here ever tried PHP/MySQL on Windows server in production environment? What are the limitations (and/or performance issues) when running PHP/MySQL on Windows?
I've started to use Plesk 8.4 on Windows Server 2008 at work, and totally love it. The IIS7-native MS rewrite engine works pretty good. It's a dedicated box.
For my own hosting, I use either shared/reseller or VPS. Looking around, it seems every VPS is still on Windows Server 2003 and IIS6.
I took a look at the Parallels site, but came up empty. Is Server 2008 not supported by Virtuozzo yet? Is that what everybody's waiting for? If that's the case, any news/rumors on when it may be supported? IIS7 is a huge leap over IIS6, in terms of PHP and the Rewrite (plus a few other things, though not as important to me).
I have a Windows 2008 Web Edition server running, but i noticed that the DNS Role is not included in this edition.
Dous anyone know if there is an other way to create 2 nameserver for my domain/server, If so: Could you please make a small tutorial how to create these nameservers.
I'm running DotNetPanel on my server to manage my website.
Windows 2008 has much more functions than the typical Windows 2003, wonder anyone has any guide on how to best secure this server? Any resources available on the Internet?
Also any additional anti virus and firewall recommended for this?
With Windows client OS (e.g. Vista), it's always good practice to hold upgrading till the first service pack comes out. How true is this for Windows Server software? We're going to upgrade some Windows servers and would like to know if we should stick to Win Server 2003 or go ahead and get 2008?
On February 27, 2008, Microsoft will jointly release Windows Server 2008, Visual Studio 2008 and SQL Server 2008, kicking off what it calls a "launch wave" with hundreds of events worldwide. Microsoft will pitch the products as a platform for next-generation Web service applications.
Windows Server 2008 is still expected to be released to manufacturing before the end of the year, with November as the rumored timeframe. Microsoft took a similar tack with Windows Vista, making it available to businesses in November before its public launch in late January.
[url]
What do you think this means to hosts offering windows servers? Will they start offering Server2008 in november as the rumor goes, or only in February when it'll be officially launched?
What about swsoft and virtuozzo. What timeframe do you think they'll need to adapt server 2008 for their virtualization.
