I have a sql server 2005 database which is 5gb. My current host only allows 2gb and charges and obscene amount for extra space. Does anyone know of an inexpensive host that I can put a 5gb database 2005 on? It doesn't need much bandwidth, it will just be for storage/archive purposes.
I have built a website based off of The Beer House template/book and am about ready to launch it. I need SQL server 2005, and ASP.net functionality. I will either use the included forum module or am considering a third party forum such as aspplayground.net.
I would like to spend $10-$20/month, I don't mind paying a bit extra to have a fast loading site, but I don't want to spend too much. I would appreciate any suggestions.
The database will handle the forums, the store, the users of course, and a custom database I am building for some vehicle information. To start out the database is not very big (maybe 20mb), but I expect it to grow to support the forums and users, etc.
Also, I have already built a database (mdf) file on my computer through visual studio 2008. Is it true most shared hosting accounts wont allow you the access to copy and paste the database file directly? I don't really want to have to recreate all these tables on the host server.
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.
how do you guys do the maintenance for shared hosting SQL 2000/2005? Do you just let the customers do the maintenance, compacting and optimizing themselves or do you scheduled a task to do that?
Till now I had let my clients do that. But some clients it seemed do not really know much about this. But if we were to compact or optimize all the databases by task scheduling, I am worried that it is something against their privacy.
Just wanted to know how prevalent VS 2005 is now. We are basically virtualizing everything that moves as it is easier to upgrade to a new server and move the VPS around. Also we get to control the reboots etc.
A client of mine took over a website and transferred it to a new server. It uses SQL Server 2005. It is coded in VB/asp.net and I have all of the web content but not the original vb source. I thought everything was working, but an important part of the site apparently uses databasemail and is hard coded to use a particular profile.
Sooo.. I setup Database Mail, enabled it, created a profile and mail account, tested it, etc and got it working just fine. However, the website is trying to use a particular profile name and I have no clue what it is. My client is unable to get in touch with the former owner of the site at this point either due to political reasons. Therefore, I am getting this error:
System.Data.SqlClient.SqlException: profile name is not valid profile name is not valid at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at RER.signup.subAddContact() in C:UsersDusanVSWebCache....etc
I tried guessing obvious profile names. I tried running Network Monitor, but it can't capture the raw SQL queries due to it being a local SQL server. I looked into SQL Profiler, but I am running Workgroup Edition of SQL Server 2005 so it is not included. My next idea is to maybe place the database on a remote machine and have the website connect to it remotely so I can snoop the network traffic and maybe pick up the profile name. That is going to be a big pain however.
Does ANYONE have ANY suggestions on what else I can do to pull this profile name? Is there some way to trick SQL server into accepting a wildcard for a profile name or SOMETHING? It is such a minor issue and I feel like it should be a lot easier to solve than it has been!
I recently signed up with cartikahosting.com only to find out they do not support SQL server 2005 when I tried to install my application.
Their features and price are excellent so I would like to stay with cartika if possible, is there a way to convert my database to 2000? Or backup the database using sql server scripts?
I bought Windows Vista Ultimate OEM and installed it on the physical machine, can I install Virtual Server 2005 and install the ultimate OEM version again on the VIRTUAL server 2005??
I run MySql but I hate to run it on the physical machine, want to run on a virtual machine.
asp.net 2.0 + mssql server 2005 + ajaxtoolkit support
I need windows hosting with asp.net 2.0 + mssql server 2005 + ajaxtoolkit support for a website project that is being developed. It can probably be launched on shared hosting, but I would prefer at least a VPS. With any success this site would eventually need to be hosted on a dedicated server.
I have been offered a 1U Dell server for free with Windows Server 2003, Dual Xenon Processors, 2 GB ram and 2 x 80gb hard drives. It would probably serve the site well for a long time, but I would need to set it up (or get it setup $) for the above requirements and get it colocated somewhere. BTW, I'm not too familiar with Windows hosting.
To launch the site, I don't really want to spend more than $100 per month. And I'd prefer to stay in the $50 per month range if possible.
Open to any and all suggestions, comments, questions at this point? I've searched and see a lot of suggestions for shared hosting, but I'd really like your opinions on colocating the dedicated server.
We use VS 2005 and are happy with the stability and performance etc but wanted to know if there are any great advantages to using virtuozzo? It seems that a higher ratio of VPS per box can be achieved with virtuozzo due to the ability to share RAM but is this worth it for the extra cost of licenses and possible security / stability risks?
I got some question regarding MS virtual server2005 R2.
1. If i created an instance of Windows2003 in virtual server2005, if i screw up something. would it affect or crash my host server? I have a colo Windows2003 R2 standard server but it also host several websites that i don't want it to go down if i mess up the instance in vs2005. i believe it won't affect the host but i just want to confirm this. does anyone have problem with screw up guest OS taking down the host OS?
2. how about liscense? do i need to purchase an liscense of Windows2003 in order to run in virtual server?
3. how much RAM do you think i need to assign to it? my colo server spec. is AMD64 dual core 4000+ w/4GB of RAM. Do you think 512mb is good enough for the guest OS (windows2003).
I was trying to bring down license fee for a customer who needed SQL Server on Windows Server.
realised that MS has released a fix to install the SQL Server 2005 on a Windows 2008 Web Edition.[url] The license fee for the web edition is lower than the standard version.
Do you know is Microsoft Virtual Server 2005 R2 really free? By this I mean can I start VPS hosting business using Microsoft Virtual Server 2005 R2 without paying any license fee for virtualization product? Are there any restrictions?
I was very unpleasantly surprised when I found out that VmWare Server is actually not free and totally unusable for VPS hosting companies, although when you read their FAQ you get impression that its free and that ESX is just "better version". In fact for VPS hosting VmWare is not free and its totally useless.
So I am interested if there is some "minor glitch" in Microsoft agreement for Virtual server as is in VmWare agreement for VmWare Server?
After carefully choosing a VPS Host, I decided to go with SolarVPS. The VPS was created quickly. I needed a SQL server for small developemntal purposes; So I didn't want to shell out the $10/month extra just yet. I submitted I ticket to them with a copy of my CAL and Product Key:
http://www.nuerom.com/sqlcal.pdf
They sent me a e-mail back saying:
I'm sorry but the document you have attached does not reflect that the software is licensed to you so with this limited information you provided I cannot approve the use of SQL Server 2005 Standard on your VPS.
Well, I sent them the CAL and product key, so what more could they want? The copy of SQL server was recieved from a Microsoft Launch Event, Launch Tour 2005, so I didn't get a invoice. I sent them a copy of the items sent out with:
And opened a chat with them. The chat conversation is attatched:
http://www.nuerom.com/solarvpschat724.txt
In summary,
I asked what they needed to validate - they claimed they needed a invoice.
I didn't understand how a invoice would prove anything, since it is something that can be generated by anyone in a few minutes.
They claimed they get audited from time to time by Microsoft, so they have to make sure genuine software is running on their VPS.
I offered them my MSDNAA license, since I would be only using the server for developmental purposes. I send the a PDF of the MSDNAA order; only to have them deny it again. They claimed that it wasn't valid because I paid with a paypal business account. Even though the MSDNAA terms clearly state that it is a valid license for test and developmental purposes; and that the license is perpetual.
I offered to ship the DVD, CAL and BOX to them. They claimed that this wouldn't be enough to validate. (Implying, of course, that they had some reason to believe I might have stolen the DVD).
At a loss of what to do; I finally contacted Microsoft to have them validate the product; partner support was very nice and directed me to the appropiate departments. I sent solarvps a e-mail back:
I contacted Microsoft and recieved this information. They advised me that the only restriction on this software is that it is NOT FOR RESALE, and that I may put it in full production use. I was told that if you needed validation, you may call 800-426-9400 option 3, option 1. You may reference my name, or my phone number, which will validate my conversation with Microsoft.
See also, http://download.microsoft.com/documents/useterms/SQL%20Server%20Standard_2005_English_9137cd88-ab33-48b7-ac2a-544f2ec58c4d.pdf
They have yet to reply. I am at a loss of what to do; as I have other promotional software I'd like to install on that VPS; but if its this much of a hassle, I might just go with another host. Unfortunately, solarvps canceled their refund program, so I am at a loss what to do there.
In particular - I feel that SolarVPS just doesn't want to authorize the SQL server because they want me to pay $10/month. This is way too much validation. Besides, as a MS partner, if they were afraid of the software failing auditing they could have called their MS Partner line to verify it was genuine software. Additionally, I felt that Bogdan Fetita, their "senior tech" had attitude that made me feel very unwelcomed.
Should I just move on and find another VPS server after days of trying to find the right one? Or should I hope solarVPS will lighten up?
My client is looking for a company that can provide managed dedicated servers for use with SQL Server 2k5 and IIS. I believe the client is looking to have everything installed for them and then be handed the keys once complete.
I am in search of windows host supporting .net 2.0 and sql 2005 and atleast 2 domains (3 will be good). I need around 3 gb space and 20gb bandwidth is enough. My maximum I have checked the offers section and other posts here and below are the shortlisted hosts:
discountasp eukhosts appliedi exabytes
Can someone who's using them give a suggestion/feedback or else can suggest one?
I am curious what "methods" Windows providers out there use to deploy Windows Server to Virtual Machines using Virtual Server 2005 when the machine is "remote" at a datacenter.
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.
I have several gigs worth of data which my programmer wants to put into MS SQL 2005. But the last time I check, MS SQL comes in blocks of only a few MB (eg 200MB for $25).
Now if I have 10GB of data, that yould cost me like...thousands?).
One solution is to use mysql which is free of course, but the website is done in ASP.NET. How will this affect performance?
Also, is there any other way which I can purchase SQL 2005 myself? If yes, how much for one domain name?
I would like a VPS account, but the problem for me is that my site is asp.net and has a MS SQL 2005 database. From the research I have done so far, it appears that only the shared hosting solutions provide a MS SQL database, and if I go with a VPS solution I have to own and install my own copy of MS SQL. Is this correct? Does anybody know of a VPS solution that would also provide me with a MS SQL 2005 database as well? I can't afford to pay $5000+ for MS SQL 2005 Standard Ed.
I am using SQL 2005 Express Management Console in the CTP version, but when I upgrade to the release version, it can't login. Do I need to upgrade the SQL 2005 Express to Service Pack 2 first before it can login? Anyone facing similiar issues?
Secondly is there anyway I can upgrade from SQL 2005 Express to SQL 2005 Express Advance version?
Knowing that Port 1433 is one of the most attacked ports, I am thinking whether I should just change the default port of my new MS SQL 2005 installation, but issue is, what will be the disadvantages to users if I do so?
I have never upgraded SQL 2005 express edition before thats why a bit worried. What is the safest way to upgrade it to Service Pack 1? Secondly the management console upgrade. Which to upgrade first the SQL or the SQL Express Management console?
I have to tranfer our user and their Databse to a dediServer. How can i move all/selected user I know how to mmove the database with detach attacj function but how user login can transfer along with their databse. Is it possible using Managmaent studio.
Windows 2003 Enterprise edition IIS 6.0 Sqlserver2005
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).
Can I upgrade MS SQL 2000 Standard Edition to SQL 2005 Express Edition? I know I can upgrade to SQL 2005 Standard as well as Enterprise Editions, but I want to know if I can also upgrade to the SQL 2005 Express Edition.
Do website builders generally go with shared hosting or dedicated server? I mean, if they work on several websites would they get a dedicated server instead of shared? From what I understand through reading shared hosting is basically if you only have one website. So one with multiple websites would go with a dedicated server?