Windows VPS With .NET2 And MSSQL

May 20, 2007

I'm looking for a Windows VPS provider that offers .NET2 and MSSQL?

View 0 Replies


ADVERTISEMENT

Hi Perf. MSSQL 2008 DB W/ Windows VPS

Mar 9, 2009

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?

View 0 Replies View Related

Windows Hosting With MSSQL Database

May 7, 2008

Any windows hosting provider with MSSQL database?

View 14 Replies View Related

MSSQL 2005 + Windows 2003 Standard X64

Jun 4, 2008

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).

View 4 Replies View Related

Plesk 11.x / Windows :: Add Existing MSSQL Database?

Sep 18, 2012

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.

View 2 Replies View Related

Plesk 11.x / Windows :: Change Database From MySQL To MSSQL

Apr 22, 2013

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.

View 7 Replies View Related

Plesk 11.x / Windows :: Copy Mssql Database In Panel

Feb 5, 2014

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:

"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."

View 7 Replies View Related

Plesk 11.x / Windows :: Regional Settings And MSSQL Collation

Apr 28, 2014

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?

View 3 Replies View Related

Plesk 12.x / Windows :: MSSQL Webadmin Connection String

Oct 3, 2014

I am using connection string that written below but it does not work in your host.

<add name="LocalSqlServer" connectionString="Data Source=mssql.mydomain.at; Initial Catalog= mydb; User ID= myuserid; Password= mypassword; MultipleActiveResultSets=True;"/>

Any connection string instance for mssql webadmin ?

View 1 Replies View Related

Plesk 11.x / Windows :: Delete Inactive MSSQL Remote Server

May 13, 2014

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.

View 1 Replies View Related

Plesk 12.x / Windows :: Unable To Add MSSQL 2014 Express Server

Aug 9, 2014

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...

View 4 Replies View Related

Plesk 11.x / Windows :: MSSQL Quota Not Updating - Statistics Showing 0

Apr 3, 2014

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.

View 1 Replies View Related

Plesk 11.x / Windows :: External MSSQL Servers Connected To Multiple Installations

Oct 21, 2013

I'm looking for information about having EXTERNAL ms-sql 2008/2012 servers with MS-SQL Web Edition license connected to one or more Plesk servers.

We don't want to use the Express version coming with Plesk but use MS-SQL 2008 & 2012 (both accessible by clients if possible), on individual dedicated machines for SQL only.Of course we'd like to have all current functionality coming with Plesk Power Panel inc. backup/restore options from within Plesk.

View 2 Replies View Related

Plesk 12.x / Windows :: MSSQL 2012 User Is Created Without DB Owner Role

Jan 5, 2015

After upgrading to Plesk Panel 12, when db user is created on MsSQL 2012 server, db user seems to be missing db_owner role which is causing a lot of hassle at the moment.

I was not able to locate any settings for such except for following option.

"Enable the db_backupoperator role membership for all Microsoft SQL Server database users"

Please note, this only applies to new db user created as Plesk 11.5 didn't have such problem and only seems to be related to SQL 2012 not 2008.

View 5 Replies View Related

Plesk 12.x / Windows :: MSSQL - Unable To Backup Database Operating System Error 5

Mar 28, 2015

12.0.18 update #39
Server 2012r2

Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:

Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.

(Error code 21)

I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.

PrivateTemp folder appears to have write permissions for Group MSSQLSERVER

View 6 Replies View Related

MSSQL Server + MSSQL Express

Aug 4, 2008

I already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.

Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?

Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.

View 5 Replies View Related

MSSQL Express 2005 Instead Of MSSQL 2005 ?

Dec 27, 2007

I`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.

MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.

I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.

Is there any limitations for major scripts on those? or will those make any doubts for programmers?

Please share your experiences and suggestions.

* I`m going to install "Hosting Controller" on that box.

View 8 Replies View Related

IIS And MSSQL

Mar 20, 2007

I am planning on starting a new project and am curious as to if there would be an issue with hosting the websites (IIS) and the MSSQL Databases on the same server?

Basically housing all of the websites and SQL DBs on the same server?

Is this going to cause major problems? I originally thought that I should house the DBs separate but am starting to think that we can house the web and dbs on the same machine but I wanted to get some advice from other that know more about Windows then I.

View 2 Replies View Related

Win/MSSQL Hosting

May 19, 2008

what level of hardware/hosting plan I need for one of my clients.

Current stats:
~65 ecommerce orders per week
~5000 unique visitors per day

Requirements:
Win2k3
ASP.NET 3.5
MSSQL 2005

My first recommendation to them was RackSpace due their good reputation, but they were not able to pay for the plan suggested to them by RackSpace.

My other question is what type of plan do you guys recommend based on the above stats/requirements (managed/VPS/dedicated/etc.)? VPS is what came to mind for me since we'll probably end up using this setup for more than one website/domain and since they are so price sensitive.

I'm fairly comfortable setting up and administering Win2k3 and MSSQL. I'm sure that plays into the choices a little.

I know there is probably some information I have left out that would help you guys make a recommendation. Please just let me know what else would help.

View 8 Replies View Related

MSSQL - Setup

Jun 1, 2008

I have around 5 servers each running an instance of MSSQL. Four of them hold small databases (largest is 4GB) and all fairly active (I was monitoring the largest for around a minute with SQL Profiler and it used about 2000 rows).

The largest server is used as a central database for logs for the above four servers.

This server runs across 4 * 15k drives in RAID10, but the RAM is a huge bottleneck (64bit OS, 32bit MSSQL). I also watched this server for around a minute in SQL Profiler and saw around 2000 rows being used again.

Now I'm looking to centralise everything into a single instance of MSSQL. I can't afford for MSSQL to be slow, but it will be housing 7 databases (3 'main' databases, 3 log databases, 1 misc. database).

I'm looking at this:
- 2 * Quad Core Xeon 5405 - 2.00GHz (Harpertown)
- 12GB RAM
- 250GB SATAII - Windows installation / Programs
- 250GB SATAII - Backup drive, MSSQL transaction logs
- 10 * 73GB SA-SCSI 10k (RAID10) - MSSQL instance, all databases here

I'm just wondering if anyone could hazard a guess if this would be sufficient? I've tried to explain things the best I can. I guess to summarise would be that there are a lot of read and writes that would happen if I conbined all the databases into a single instance.

View 1 Replies View Related

MSSQL Licencing

Apr 29, 2008

I see that SQL Server Express said to be free but does that mean its free for commercial use? personal use? development use? I don't see any information.

Also I read on this board that some hosts offer this. Are they just using the free free version or something else?

View 12 Replies View Related

MSSQL Best Way - Can't Beat It...

Jun 5, 2007

what is the best way to connect to a MSSQL from a Centos box?

View 2 Replies View Related

Adding MSSQL Support To PHP

Jul 15, 2008

I installed mssql support to my cpanel server as you mentioned on cpanel forums. When i request some data it gets charecters in error and writes them to mysql server.

I've installed this on previous server and didnt have this kind of problem.

I set same configs with old server (mysql.php,etc.) but it's not working.

[ http://forums.cpanel.net/showthread....ighlight=mssql ]

cPanel Ticket Message;

we are still having same problem on mssql, there are difference with 2 dedicated but we did not solved it yet. for example, you can see on first screenshot, there is some character errors while it getting datas on mssql server and we think that, it will cause problem and not showing totals but we did not have any problem on old server without characters problems

New server :
http://img142.imageshack.us/img142/2091/newservercc8.jpg

Old server :
http://img362.imageshack.us/img362/4138/oldserverzz0.jpg

View 0 Replies View Related

ASP.Net Site With MSSQL 2005

Oct 20, 2009

I am looking for a company to host a relatively simple data driven ASP.Net 3.5 website and a MS SQL 2005 database. There will be minimal traffic on the website as it is for a small business and also minimal media will need to be hosted. Features like Ajax should of course also be enabled.

Data security is of importance although as the developer of the site, I would like the flexibility of being able to configure the database (run scripts) through management studio remotely.

Email features will also eventually be required.

The company should ideally be based in the UK and decent support id (and when) the need arises.

Any recommendations? What sort of price range should I be looking at?

Most companies seem to support MySQL- but this is not flexible.

View 10 Replies View Related

MSSQL Mirroring / Failover?

Jul 8, 2008

I'm building the infrastructure for a live event site.

I have specced 8 app servers but I'm still unsure with regards to MSSQL.

The site functionality makes a single write to the DB with no reads. A simple option would be to have a MSSQL DB instance on each of the APP servers and simply collate the information after the event.

I've also been looking at the mirroring function of 2005 as it would mean we could get away with two MSSQL servers instead of 8.

Has anyone used MSSQL 2005 Mirroring? Is it easy to setup and maintain? Any caveats?

View 1 Replies View Related

Restoring MSSQL Database

May 5, 2009

How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.

View 12 Replies View Related

MSSQL Backup Location

Aug 2, 2009

At the moment our MSSQL defaults to backing up db's to C:/Windows/Temp. On some occasions it backups up to the sql backup folder. Any ideas where these settings exist in MSSQL Management Studio?

View 1 Replies View Related

MSSQL Server Attacks

Oct 11, 2009

I can see lot of MSSQL Server attacks. In event viewer "Login failed for user 'sa'. [CLIENT: Some IP]"

Most of the attack coming from Chaina. Tipically what I'm doing manually is get that entire IP range and block from Windows Firewall level.

Now I have plenty of blocked IP ranges all over the world.

What would be the best way to avoid from those kind of attacks ?

View 6 Replies View Related

Plsek Mssql Backp

Jan 22, 2009

I use windows hosting and use plesk 8.3.0.1

I can see any icon except add database, inside the database folder.

In add database too i cant find any import or export option.

How do i upload a local database into my server?

View 3 Replies View Related

Large MSSQL DB Hosting

Jul 1, 2009

Does anyone know any shared hosting or semi-private VPS hosting for a site with large MS SQL2005 DB? Our DB is currently 1GB already but could get up to 5-10GB when all is said and done. The site is a B2B networking platform with many users, company profiles, products, etc.

View 3 Replies View Related

MSSQL 2005 Hosting

Dec 23, 2008

i am finding a MSSQL 2005 server for one of my application for my client.

Actually, it is a small business program. It will not have a heavy load on the server.

Do any hosting packages company for that with reasonable price? It is not a website. It is a C# software application. So the port will not be 21 or some web port.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved