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.
View 6 RepliesWhat 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
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
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
View 7 Replies View RelatedHello,
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
Hey,
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
Can I use database that i develop in SQL Server 2005 in hosting company that has SQL server 2000 installed?
Thanks guys !!
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've got a database stored on my computer using mysql server 2005, and I've just registered for hosting which uses the Plesk control panel.
In plesk I've setup a database and relevant user. What the easiest way of exporting the whole database on my computer and getting it onto my hosting account?
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?
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
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
Can SQL Express used in a web hosting scenarion... Does that require any extra license or is free?
View 3 Replies View RelatedHi 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 RelatedI'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?
Many Thanks,
Steve
Hi,
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?
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.
Thank you!
Hi 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
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?
View 6 Replies View RelatedIf i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
View 1 Replies View Related
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
I've started with the development of a website which will use a sql server 2005 database. I want to use the asp.net membership and roles functionality. In the end the website will be hosted by a hosting company.
What is the best way to store the database? In the App_data folder or outstide the App_data folder?
Second, do hosting companies support placing sql server databases stored into the App_data folder?
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies View RelatedHi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
Hi,
I want to make a component library in Visual Basic.NET and connect to a remote Sql Server. When I create a new DataSet with the wizard, I can only connect to a .mdf file, but not to a Sql Server. With Visual Web Developer I can connect to a Sql server. What is the difference between these enviroments ? How can I do the same with Visual Basic.NET ?
Thanks in advance.
Currently I have following things installed on my Computer
1. SQL Server Express 2005
2. SQL Server Management Studio Express 2005 CTP
I need to install following things
A. Microsoft SQL Server 2005 Express Edition with Advanced Services
B. Microsoft SQL Server 2005 Express Edition Toolkit
Do I need to uninstall any any of 1 or 2?
What should be my path to upgrade these software.
Hello,
I want to offer a SQL 2005 server in back-end configuration for my hosting clients. Basically this means that they administer the DB with a webbased tool and the DB server it self is configured in the backend and has no direct connect to the internet. The DBs can only be access from the frontend web server.
- What security considerations should I take to use this server in a public hosting environment?
- We only allow webbased administration, no direct connect to the server are allow and possible.
- Multiple databases will exist on the same server from different customers.
I really would like to have as many information as possible. There is not much usefull information available on the web or in the books I own about SQL.
The question should actually be: what do you want to prevent from happing on your servers by authenticated users and ofcourse unwanted users. And how to do this.
Hi,
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...
Stacy
HI
Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?
Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?
Regards
Hi all,
I have installed SQL server 2005 express edition with SQL server Management studio express (SSMSE).
I have installed also SQLce and I would know how I can manage sql compact edition databases (.ldf) with sql SSMSE, if it is possible!
I would be grateful if you could explain it trought a detailed guide (I am a beginner user of sql server tools) or trought a link to useful sites.
I'm Looking forward for your reply and still trying...
Alessandro
Hi all,
In my SQL Server Express (that is installed in my Windows XP Pro PC), SQL Server 2005 Network Configuration has Protocols for SQLEXPRESS. I tried to do "Enabling CLR Integration" in my SQL Server Express: (1) If I clicked on "Surface Area Configuration for Services and Connections", I got an error "An exception occurred in SMO while trying to manage a service, (Microsoft.SqlServer.Smo) Additional information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). (2) If I clicked on "Surface Area Configuration for Features, I got a different error "Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required computer has the required Windows Management Instrumentation components and then try again. (SQLSAC) Additional Information: An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo). Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). Please help and tell me how I should do to get "Enabling CLR Integration" in my SQL Server Express done and how I can create SQLCLR Project in VB 2005 Express.
Thanks in advance,
Scott Chang