Sql2005 Express NOT AVAIABLE As Shared Hosting Option?
Nov 24, 2005
I 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?
Hi 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.
I'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...
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
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.
Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting? With database size limit, user number restriction and other features.
i am getting ready to build the back end for a client server application, using a shared sql server as a back end. microsoft's white pages don't mention shared hosting. i need to know if anyone else has had problems with lisencing in a shared hosting environment. my web host told me i don't need to liscence my users (who will have read write priveledges), but microsoft gave me the impression that i did. anyone know a clear answer?
I'm currently on a shared hosting plan which has a SQL Server component to it.
At the moment, I'm on 2000. I have a DTS package that runs locally and does a backup of the remote database and backs that up using sequential file numbering.
I'd like to move to 2005, but I'm not sure quite how to replicate this process. Basically:
- I don't have access to the server as it's shared hosting - I don't have the credentials for backups and stuff like that - They only send backups on demand - They don't perform regular backups on your data - They won't have the backups saved to my web directory
If I: - use import/export, which is almost the only thing I know I can use, I can only copy tables and views. I'd like to copy everything (SPs, Functions, ect)
The only thing I can come up with is software that would compare the structure and data and generate T-SQL to copy it over (ie. Apex SQL).
I'd like to do this:Have a SQL Server database hosted on a public facing web server.I want it to be held at an ISP/Web hosting company. Though I have ADSL hereI don't want to manage a server.I want some ASP pages accessing the database.I would also like for a very small number (probably 2) of users to accessthe database from a richer client. Perhaps Access/VB.I've tried using www.shanje.com, as a test. It seems to work, though thereare worries about security.I want to keep cost down!On 'normal' shared MS hosting, would it be possible to connect to the dbfrom a client like Access. The way most web hosts talk it doesn't look likeit.Is there any way of providing a richer client interface than plain webpages? I want things like autocomplete (beyond the first character) for dropdowns, keyboard shortcuts etc.This would be low volume. Essentially a private database held on theinternet.Yours, Jo
I am an ASP.NET 2.0/SQL 2005 web developer, and I have run into a huge frustration for some time now that I can't seem to get past. My goal is to develop SQL databases for my costomers on my development machine, and then upload the completed database out to my host. I have not found a host that allows this yet. Some hosts do not allow remote SQL connections altogether, and the best hosts I have been able to find allow remote SQL connections, but do not allow SSIS or DTS packages to run to transfer database objects to the production server.
What does this mean? Well, I have to manually transfer or recreate individual stored procedures and recreate primary, foreign, and other table constraints. I cannot just run a DTS package to transfer the completed objects. So this means duplicating effort, changes for mistakes, and more server downtime during site upgrades. I have called so many host providers, and I haven't found one that can get me past this.
Also, I contacted Microsoft to ask about Licensing (thinking I would just lease a dedicated server), and the only option I can use is SPLA licensing. The catch, I have to lease the OS through SPLA as well, and all the hosts I have contacted put the OS on the server themselves. This means I would be paying for the OS twice.
Ideally, I would just love to find a shared web host package that I could use efficiently with my SQL development. Am I missing something? If anyone has any advice, please help! I would be so appreciative!!! Thanks.
I just recently added 30MB of SQL Server database space on my Share hosting account.
I want to put the SQL Web Data Administrator on the server but it is an MSI file and I cannot figure out how to install it.
Also, I will be testing my .Net pages on my local machine. How do I go about it without accessing the SQL Server on my host? I used MS Access before and I have a copy of both databases on my local machine and on the server. I'm thinking of using MSDE on my machine and I just change the connection string when I upload my code. Is this a good idea or is there a better alternative?
I'm trying to get the External Activation Sample to work on a shared hosting Sql Server. The error seems to indication that I might be able to enter my db un/pw to get it to work. Where in the code or app.xml can I provide credentials? Here's the EA log. Thanks!
3/29/2007 4:47:39 PM STATUS: External Activator initialization completed. 3/29/2007 4:47:42 PM WARNING: Failed to connect to Notification SQL Server 'sqlb2.webcontrolcenter.com' and Database: 'xyz' because: Login failed for user ''. The user is not associated with a trusted SQL Server connection. 3/29/2007 4:48:17 PM STATUS: External Activator is shutting down...
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.).Net SqlClient Data Provider at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] buff, Int32 offset, Int32 len) at System.Data.SqlClient.TdsParserStateObject.ReadUInt32() at System.Data.SqlClient.TdsParser.ReadSqlValueInternal(SqlBuffer value, Byte tdsType, Int32 typeId, Int32 length, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ReadColumnData() at System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
Ive just started getting this on a stable application thats used a datareader on millions of records.
Not sure where to got from here and I can't find anyone else whos getting the failure during the processing.
I could disable shared memory protocol but that seems extreme. I'm on Sql Enterprise 9.00.2047. Maybe the process is hammering the server very hard? Personally I've rarely ever seen SQL be the cause of an error, only user config, bad disks or power issues.
I'm running the app again with SQL Profiler capturing "standard" events.
Just need it to blow up again.
I can run the app on another machine of course and I wouldn't get Shared Memory Provider being used. Maybe I ought to do that as well. At least if the error is not really in the Shared Memory I'd have another avenue to explore.
Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
hello 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
I 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
Hi - 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?
I 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.
For 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.
Hello,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
What 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?
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
I have a web app and database created in sql server 2005 express. In addition to using the membership and role providers I have added custom tables and stored procedures to my db. When I try to export this with Sql Server Management Studio (not the express version) to my db on my shared host(sql server 2005) the custom tables and stored procedures are not transferred. How can this be accomplished? Thanks in advance.
I am new here and new to SQL Express. I've searched for my issue, but can 't quite find anything close to the problem or how to solve it, if it's even solvable. I am using SQL Express on a pc to connect to the back end of a database. The front end application (an access runtime) also runs on the same pc. This pc is on a domain. I think I've tried every combination of protocols, and although connectivity via ODBC is successful, the application can't connect - gives the "server doesn't exist or access denied". When I log on to this computer with the "machine" logon (not the domain), I have SQL Express configured to use shared memory, the application runs just fine. I need to use this database for testing in a non productivity environment, but I really hate to log off the domain to run it. Ideas?
Hi everyone! I'm on my way to learn SSIS by myself and it's a little complicated! I'd like to ask you one thing:
I have two tables at my data source, one is "Clients" and the other one is ClientsAddress. That is, a client can have more than one address. Both tables are related by a one to many relationship and the tables description is:
CLIENTS CLIENTSADDRESS #PK_Client #PK_Client other fields.. #ID_address ... other fields
What i intend to do is to obtain one table with approximately 3 fields, each one for a possible client address; something like this: CLIENTS PK_Client ID_Address1 ID_Address2 ID_Address3
My question is what transformation can i use? an how ?
Thanks very much in advance!! Emilio Leyes Salta, Argentina
Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?
I just installed SQL Server 2005 Express. I would like to import tables from another DB, and I read in the help files that I just need to (1) right-click on a non-system database in Management Studio Express, and (2) select Import/Export under the Tasks menu.
I tried this, but my Tasks menu only contains these options: Detach, Shrink, Backup, Restore, Generate Scripts.
I googled for "sql server 2005 "no import" tasks", and it appears that a couple of people have had this problem -- the only solution I read was to install the "Workstation Components," but I already have, and still no luck.
I recognize that this question borders on blasphemy but I am curious as to whether there is a version of sql2005 express for the mac platform. Would like to keep a compatible local instance of 2005 on my mac notebook.