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).
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.
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 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.
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
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
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?
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.
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?
I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's? The DB's will be used for database driven websites. Please let me know what your thoughts are. Thanks,
I have established roles to restrict access to the data entry pages. The database is SQL Server which I've established on the hosting server. Security was previously maintained through ~/app_data/aspnetdb.mdb (MS Access). It works, but isn't too stable, so I have modified the security to use SQL Server with an aspnetdb.mdf file, also located in the app_data folder. Is this appropriate? Since it doesn't work, I assume not.It's now my assumption that I need to setup a SQL Server database to support the security/roles. I have seen some reference to using a script to build the aspnet.mdf on the hosting server. If I do create such a database, is there anything special I need to do to have my application read the aspnetdb? Do I need a connection string in the membership and/or roleManager sections of my web.config. A little guidance would be appreciated.Thanks
I have been reading on aspnet_regsql.exe tool and still haven't found my answer. So here we go... I am using VWD Express and I have already made many pages in many dbs within the app folder. My question is how do I use the aspnet_regsql.exe tool to know what DB that I want the tool to know AND how do I put in the name of the DB on my sql hosting server? For instance:Let say in my app folder I have a DB named testDB.mdf and my hosting sql server is named sqlHostingServer... so if I use the command line entry in accordance with the documentation, it should look like this (in the dos prompt):aspnet_regsql.exe -E -S localhost -d testdb.mdf -A all -sqlexportonly c:output.sqlbut it seems that for the DB name I can put anything I want and still gives me output... wtfark... any help? I don't work at Microsoft so please simple documentation or something like that.Thanks,MR
Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..
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?
I'm a web developer who writes transact-SQL to make my web applications run properly. I'm not real strong in other areas of SQL. Let me explain our set-up and then I'll explain what I want to do:
We have an ecommerce web site and all sales are saved in a SQL Server 2008 R2 database at our hosting company. We also have a local Windows 2012 network that has SQL Server 2014 Express installed.
Here is what I want to do:
I want to copy sales rows from the SQL Server 2008 database at our hosting company and save them in the SQL Server 2014 Express database on our local Windows 2012 server. I'd like to automate this if possible so that it happens each night perhaps. I know there is a way to schedule SQL jobs but I've never actually done this. I also would need to know how to attach to our hosting company DB as well as our local network DB.
I'm new to database development and have created a database-driven website which now needs to be uploaded to the client's hosting company server. What is the easiest way for a newbie to upload a copy of the databse to the host. Thanks in advance.
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 am using a SQL Server 2000 Database for the purpose of development.
Now I want to host the SQL Server2000 database in the internet and I want to access it via the ASP.Net
1) Please, what is the best server that host SQL Server databases? 2) And Can I control the database remotely(such as execute srcipt to change table structure in the hosted database) as I did in Query Analyzer? 3) Is the administer of the hosting server able to change the strucure and contents of My Hosted DataBase?
I am trying to use the new Common Language Runtime (CLR) hosting feature to write stored procedures in C# i have addedMicrosfot.sqlserevr.server name spaceand ia m trying to use sqlContext Object as below using (SqlConnection connection = new SqlConnection(dbConn)) { connection.Open(); SqlCommand sqlcmd = new SqlCommand("select @@ version", connection); SqlContext.Pipe.ExecuteAndSend(sqlcmd); } i get the below error when i execute (SqlContext.Pipe.ExecuteAndSend(sqlcmd);) System.InvalidOperationException was unhandled by user code Message="The requested operation requires a SqlClr context, which is only available when running in the Sql Server process." Source="System.Data" i checked if (SqlContext.IsAvailable) and it returns false as well. Please le me know how to make it work. Thanks THNQDigital
I am new to database. I have a website in a hosting environment and it uses sql server 2005 databases. I want to have a complete backup of my database in addition to the hosting company's routine backup. I want to write a program to automatically backup everything every night. And of couse have the ability to restored the whole database if necessary. How should I do it? Are there any tools exist that I can use? What is the best way to deal with backup/restore in hosting environment? Thanks!
hi all,my hosting company uses a different port for connect to their sql server.how do i register a server in sql server management studio with a different port number??
I have a database in my local system. here every thing is working fine. now i need to upload the database in the hosting server. i dont know how to upload the db. so i sent a msg to my hosting support center , they told "use microsoft enterprise manager software for upload". pls let me guide how to upload through enterprise manager. please. i know the remote database username and password.
We have request where client want to host both application server(IIS...etc) and MSSQL DB server on same machine. (DB is used for Time & Attendance tracking only, so there are not many transactions per day and No HA) .........
Do we have any disadvantages if we host both on same Machine.?
