SQL Express And Selling As A Hosting Service.
Apr 29, 2006Hi,
Can a web hosting company charge clients for using an SQL Express instance on their network?
E.g. The host charges the client $x per month per instance. Is this legal?
ADVERTISEMENT
Selling/Distributing SQL Server Express
May 3, 2007Hello all,
Thanks for all your great forum topics; it gives me a nice break from coding all day!
I know the answer to this question is in the documentation that comes with the SQL Server Express [9] download, but I've been unable to find it. What I was wondering is what the restrictions were if you were to incorporate the "free" SQL Server Express for selling or general distribution? Any help would be greatly appreciated!
Thanks,
P.
Replication To Web Hosting Service
Jun 6, 2007Architecture question for anyone....We have a typical SQL Server 3-tier VB.net app running at corporate and want our customers to interact through a website. If we host the website on-site, we can simply access the DB; but if we host at a remote location and want the users to perform updates (think DHL, Wells Fargo, Amazon), we'll need replication with Peer-to-peer. Some basic questions:
1) is everyone doing it this way?
2) will we need a full time replication consultant to set this up, keep it up, and keep an eye on it (administering the 50 user, 200 table DB is relatively easy and we've not needed a DBA for the past 10 years).
3) we're not DHL or Amazon, we just want that kind of end user add/update/delete functionality...so transation rates will be miniscule. But still, the corporate site is constantly being updated so we'll need a fat pipe to the hosting service, etc... any thoughts on performance?
any other tips on doing an installation like this?
thanks in advance
john
Hosting SQL Everywhere In A Windows Service
Jul 13, 2006The Sql Mobile site on MSDN recommends that you do not host SQL Everywhere when running as a service. Is this a recommendation, if so why, or is it simply not possible. My understanding is that when hosteed in a IIS hosted application a not supported exception is throw.
If anyone has any ideas on this or pointers to some resources i would appreciate them.
Thank You
My Hosting Service Requires Csv Upload ONLY!!!!
Oct 20, 2007Hello,
Im a bit of a novice at this so please bare with me
Does anyone know how to convert a .mdf to .csv as my hosting provider will only allow .csv importing to there SQL servers.
Plus will my data base work in this .csv format. (comma separated value)
Thanks in advance
Problem Setting Up SQL DB With Web Hosting Service (IPOWER)
May 6, 2008I created a small ASP.NET website with VS2008 that employs user authentication (login) functionality to protect some of the site data and allow access only to authenticated users. This functionality created an ASPNETDB SQL database in the project to hold all the user data such as usernames, passwords, user roles, etc. The website works flawlessly on my local PC but when I copy the files to my windows-based web server (IPOWER host) I can't find a way to activate the SQL database so the user authentication functionality works. I've been through all the Scott Guthrie tutorials on this subject here and here, but none of the suggestions worked for me. IPOWER is no help since they will not provide technical support for scripting.
I'm at a loss. This is just a simple little website but I've hit a wall and can't seem to find my way around it. I am new to ASP.NET and SQL server applications so my newbie status certainly plays a role here.
I will gladly pay someone (via PayPal) to spend time with me on the phone talking me through the steps to get the site working on my web hosting site. Other than that, are there any other suggestions on what I could try?
Thanks in advance for your help with this.
Doug
SQL 'Server' Or 'Local' Database For Uploading To Hosting Service Provider
Mar 23, 2007Hi, I'm developing a website using VWD 2005 Express, which needs a Membership system and a products database. Using the VWD inherent Web Site Administration tool makes the membership set up easy but by default it creates a 'Local' SQL database in a folder named 'Apps_Data' in the VWD project. My question is: considering I will need to upload my web site to a Hosting Service, would it be better to change the default so that the membership systems, and the product database I need, are created in an SQL 'Server' database instead of a 'Local' database?
The hosting service I am considering using is having a bit of a problem understanding this question, I hope it makes sense to someone or am I asking a stupid question?
Regards
Sean.
Sql Express HOSTING
Jun 24, 2007hello guys
I am developing ASP.NET applications in order to build a portfolio, im using MS SQL EXPRESS databases, do i need a hosting account that allows multiple sql databses or does SQL express fit in to your application, eg as many as you like in as amany applications. I am asking this because i know MS SQL server is a different thing from MS SQL EXPRESS server and hosting companies say stuff like 1 MS SQL databse and stuff. I have multiple applications that wont need the real MS SQL databse because there not live just portifolio stuff.
Can somone sugest a ASP.NET hosting company please a cheap one.
Thanks
Nadeem
SQL Server Express Hosting
Dec 29, 2005I am currently developing an asp.net 2.0 app which uses form authenication now implemented in a sql server express mdf database file. I wonder if there will be problems when I want to deploy this app on a hosted server from a hosting provider. I have the impression that hosting a SQLexpress user instance is currently not supported by hosting companies. Is this correct? Should I revert to an msaccess database instead (we don't want to pay extra for full blown sql server storage).
Ronald
SQL Express License For Hosting
Apr 25, 2006Can SQL Express used in a web hosting scenarion... Does that require any extra license or is free?
View 3 Replies View RelatedShared Hosting And Sql Express Issue
Jan 4, 2007Hi guys, I hope this is the correct place to post this question. 1) My website makes use of the Membership and Roles of asp.net 2. 2) I have uploaded my website to a shared hosting server, which doesn't support sql express (mdf files). It does support mysql, so I used a custom Membership provider for MySql. 3) It worked greate on my local computer, however (!!) it still creates a aspnetbd.mdf file in the AppData folder. 4) Obviously, when I tried to run it on the website, I got an error. My questions: Why my website still creates a aspnetbd.mdf file even if I am not using it anymore for the Membership ? How can I disable it, in order for it to run on a server which does not support it ? Thanks, Itye.
View 1 Replies View RelatedSQL Express Not Allowed On Shared Hosting !!!
Jan 16, 2006I've created a new website using the new Visual Studio 2005 Express edition. This site uses SQL Server Express (free software) as a storage for personalization data, etc. Now I want to deploy my site, but here it ends for me:My web site hoster does not support the SQL Express edition in a shared hosting environment. I think most people have a website running in a 'shared hosting' plan. How can this large group enjoy the new Express line when SQL Server Express is not supported? "SQL Server Express is not a part of the SPLA SPUR (Services Provider License Agreement)", they all say. Here it ends for me, my ISP and their licence supplier. Even at Microsoft's Response Management Team, 'no' is the answer.
What to do now? Move on to an expensive 'dedicated hosting' plan? Write a membershipprovider for MySQL?I feel as if I was given a free ticket for a nice journey but there's no traffic possible.
Who can help me out here? What can I do...
How To Use SQL Express In A Shared Hosting Environment
May 1, 2006
All--
Please help.
I have deployed my site to my shared host and I am getting the following RTE...
An attempt to attach an auto-named database for file... ..App_DataCommerceDB.mdf failed
...and I cannot find the issue.
Note that I have given Full-Permissions on root folder for the IUSR account and for the ASPNET account.
The full error message is below.
Anyway, do you have an suggestions?
My web hosting provider has advertised that they do support SQL Express 2005. What exactly do I need to ask them to do in order to get this working?
Please advise.
Thank you.
--Mark Kamoski
Server Error in '/mkamoski/S16' Application. --------------------------------------------------------------------------------
An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
Line 88: ''' <returns></returns>
Line 89: Public Shared Function GetCart() As ShoppingCart
Line 90: Dim rdr As IDataReader = ShoppingCartProvider.Instance.CartGetCurrentCart(GetUserName())
Line 91: Dim cart As ShoppingCart = New ShoppingCart()
Line 92: cart.Load(rdr)
Source File: c:hostingwebhost4lifemembermkamoskiS16App_CodeBLLShoppingCartManager.vb Line: 90
Express Edition Hosting Issues
Aug 20, 2007Hi - I am about to sign up with a new hosting company and I wanted to check my use of Express edition would be ok with their setup (full version 2005), they replied:
----------
yes the formats are the same but some functions in the Express Edition are not supported by the full Version as the Express Edition is for development only. We cant say if you will run into any errors as we don't know what you do and which functions you are using.
----------
Is this true - I figured it would be more likely that the the Express edition represented a subset of the full versions functionality and since they produced the same format, would be compatible in this direction. It smells of BS to me but i just wanted to check with the experts...what do you reckon?
Many Thanks,
Steve
SQL Server 2005 Express Hosting
Jan 27, 2008I have developed asp .net wbsite with SQL Server 2005 Express Edition and Crystal reporting. I want to know that whether i can deploy my website with SQL Server 2005 Express Edition? If yes, Please say SQL Server 2005 Express Edition is a local database version like MS Access or server database version. And also give me name of website or server name on which i can host my website.
View 6 Replies View RelatedLicensing Sql Express For Web Hosting Providers
Oct 24, 2006For the second time in as many months I've been asked the question. What is the license requirement for me, the service provider, for offering my clients the ability to use SQL Server Express?
I understand the license to say that as long as I'm registered (no cost) there is no further licensing needed in order to offer this to my clients.
Could someone clarify this for me? If I'm incorrect I'd appreciate the right answer.
Thank you!
How To To Transfer SQL Server Express To Web Hosting Provider
Oct 13, 2006Hello,FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the expree editon dont have function to import or export.Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables usin management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please
View 7 Replies View RelatedWeb Hosting - ASP.NET With SQL Server 2005 Express Database
Jun 6, 2006What is needed for a hoster / hosting company to be able to host .Net applications with SQL Server 2005 Express database?
My questions regarding this issue basically are:
If a hoster has several sites hosted on a server, can each one of them have its own SQL Express database?
Or, do they have to be migrated to full SQL Server?
What is with the Upsize Tool for SQL Server Express (or something like that) - is it available?
Generally, how do hosters do their hosting - do they have SQL Server SPLA signed? Or do they just have SQL Server 2005 Express and allow users just to copy their web sites and databases to server?
I would really appreciate any answer.
Kind regards,
Luka
How To To Transfer SQL Server Express To Web Hosting Provider
Oct 16, 2006Hello,
FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the express editon dont have function to import or export.
Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables using management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please
I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings???? when i ask the provider they told me to use the management studio for the databse for connection into their server.
i also noticed if i install the application which use sql server dataabse it can be install the database including the tables and the data, so how is it i want to make my web site including the database be like installer. Like CommunityServer Forum? i just install into web hosting..is it possible?? How the way?? Thank you
note: I'm newbie in VS and Sql server
SQL Express License Hosting For Business Purpose?
Apr 25, 2006Hi every one,
SQL Server 2005 Express License allow hosting for business purpose, as DB size is limited to 4 GB?
Any restriction or limitation ?
regards
Sql2005 Express NOT AVAIABLE As Shared Hosting Option?
Nov 24, 2005I recently come to problem. I want to deploy my web site, which uses SQL2005EE extensively, so I began searching for host, SHARED HOSTING solution. I haven't find one offering SQL2005EE on .NET2.0 final frameworkI have been told that there isn't ONE host which would offer SQL2005EE on Final .NET2.0 shared hosting, that it is illegal! Only if the shared host provided is free, which is insufficient in my needs (free hosts have low trafic/disk space etc).Is it true? If I pay for hosting, I can't have SQL2005EE as an option in their hosting plan? Just SQL2005 full as an option? This way I need to pick up some expensive shared hosting plan?How you ppl solved this problem?
View 6 Replies View RelatedSql Server Express - Shared Hosting - Connection String - What Do You Guys Do?
Feb 2, 2007Hey,
I have a asp.net 2.0 app that has a sql server express backend. I have been scratching my head for weeks trying to find a good wasy to encrypt my connection string. I store the string in web.config (which in itself is in theory "safe" because it's not servable) and I have scoured the web to try to find a simple way to encrypt the connection string. Even using user store would require running aspreg_iis.exe on the host with a command prompt (which clearly I cannot do). It seems that everyone's solution requires running a command prompt executable on the server.
So I am left to wonder what everyone else does. I am not comfortable using just the web.config because a determined hacker could get to that info. Then again, a determined hacker could get into any system , I guess. There are no credit card #'s stored in this app, but in theory there must be a way. I run all access to the db through stored procedures with permissions, for whatever it's worth.
Thanks in advance!
David
Connection String For Selling Web Applications?
Jan 5, 2005If I'm wanting to sell my Web Applications to clients that run using SQL Server, is it best to use a UserID and Password in the connection string, or would using Windows Integrated Security (SSPI) do? The reason I'm wondering is because I wouldn't know my customer's UserID and Password when they purchased one of my web apps, I would have to recompile the app with the new connection string (I'm not storing it in the web.config file)..
What is the best way to handle this on a global level, so that it would work on any system?
for example, would having the following connection string be a good idea for a production site?
string strMyConnectionString = " Data Source = (local); Integrated Security = SSPI; Initital Catalog = MyDBSource; ";
Selling My Software And SQL Server 2000 As Part Of The Package
Jul 7, 2006Hi everyone,
I have developed a VB6 application that works with SQL server 2000. My client does not have a SQL server installed on their machine. I wonder do I have to purchase a copy of SQL server 2000 and install it to client's computer ?
How much would a basic version of SQL server 2000 cost ?
I am new to the softwarel world. Please give me some advise.
Thanks
How To Import SQL 2005 .BAK From One Hosting Package To A Different Hosting Package?
Nov 3, 2007
I have a SQL .bak generated by our existing hosting package at 1and1.com, I want to import that SQL .bak to our new hosting package at ixwebhosting.com.
ixwebhosting.com don't have a import feature in their control panel.
I have to maintain the SQL at ixwebhosting.com using Microsoft SQL Server Management Studio Express since they don't have that feature in their cp. I don't see any import features in Microsoft SQL Server Management Studio Express either.
How can I import it using Microsoft SQL Server Management Studio Express or another free GUI program?
SQL Server Express Installed But No SQL Server Express Service Present!?!
Mar 14, 2007Hi
I'm a newbie and I have a problem that i can't solve despite sitting here all day trying to wortk it out.
I have installed SQL Server Express 2005 along with the associated toolkit. Previous to that i installed MS Visulal studio 2005, .NET 2.0 and MSDN.
The problemn is that it appears despite installing everything i don't have SQLExpress services running on my PC. I have admin rights, it installed okay but there is nothing to connect to.
When i run "sqlcmd.exe -s (local)SQLExpress -E" from the command prompt i get the following message:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
When i run SQL Server Configuration there is no "SQLExpress" service present under "SQL Server 2005 Servcies" in SQL Server Configuration dialog; just a message saying:
"there are no items to show in this view"
When i run Surface Area Configuration i get the following message:
TITLE: Surface Area Configuration
------------------------------
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------
BUTTONS:
OK
------------------------------
If you can shed any light on this id be extreamly grateful as i'd been here for hours before stumbling across the toolkit (why this wasn't bundled i don't know) only to realise once i had it that the SQLExpress service isn't running :(
Cheers,
Nick.
Does Service Broker Come With Sql Express?
Sep 13, 2007we're a little confused, we understand that between instances of sql express that a licensed edition would be necessary for service broker to be used but what if there is just one sql express edition/instance in the picture, does service broker come with express and can most of service broker's features be used "intra" (inside) that instance?
View 3 Replies View RelatedRemoving SQL 2005 Express Service
Jan 18, 2008I read on MSDN how to manually uninstall the instance of SQL server 2005 express, however i am not sure that it will remove the service. The reason i need to do this is that an application i have installed SQL Server 2005, and also QPulse5 SQL Server. I have two instances and it is giving me compile issues which i believe is related to having both services. I did add/remove programs and reinstalled just SQL Server 2005 and recieved error message saying that the service failed to start. The whole problem of this occured when we ran DCPromo with SQL installed. After we did we relized you could not promote with SQL Server. I understand that it is not recommended running SQL Server on a DC, however we did not have a choice. I am hoping someone here may have a solution for this. If there is any other information you need just let me know. Thanks
View 1 Replies View RelatedService Broker In Express Edition
Jun 9, 2005I'm trying to figure out if I can use express edition for service broker. Documentation says it can be used as Subscriber only -- but what does that mean? Can it only be a target for service broker messages? Or can it send messages as well as long as the other end of the conversation is a licensed server?
View 5 Replies View RelatedSQL Express 2005 Service Will Not Start
Mar 24, 2008
Hi
I've tried downloading SQL Express 2005 but it will not install properly, stating that it is already installed. I cannot get the SQLExpress Service to start. I keep getting the message (The request failed or the service did not respond in a timely fashion). Can anyone help or point me in the right direction?
Thanks
Integration Service Express/2005
Sep 13, 2007I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
SQL Express Needs To Work On XP Service Pack One
Jul 9, 2006SQL Express 2005, MUST work on windows XP Service pack 1, it should not need XP SP 2. Also it should not require windows server 2003 SP1. This is seriously limiting our possibilities as a development company, this is ruining business, ANYONE READING THIS MESSAGE WHO CARES ABOUT THIS ISSUE, AND THAT INCLUDES ANYONE WHO WANTS TO DISTIBUTE SQL EXPRESS, SHOULD ADD THEIR SUPPORT BELOW, COME ON GUYS, PLEASE LET M.S. KNOW HOW WE FEEL ON THIS ISSUE....
View 8 Replies View RelatedSQL 2005 Express Service Pack 2
Apr 8, 2007I have been receiving the update notice from MS about SQL 2005 Express Service Pack 2. I download it and install. It states successful installs but I get another message requesting the same update. It is Ground Hogs day and Deja Vu all over again.
Question:
Where do I find out if it actually installed?
How do I stop getting the messages from MS to download and install SQL 2005 Express Service Pack 2? I shut the the automatic update but if I turn it on a few days later. I get the same message.
Any help appreciated.