473,666 Members | 2,096 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server Express 2008 R2(free version) from SQL Server 2008 R2 Management Studio

AR Ratheesh
25 New Member
Hi ,
How can i create SQL Server Express 2008 R2(free version) from SQL Server 2008 R2 Management Studio.

I have SQL Server 2008 R2 management Studio. for my MS Access database i need to deploy Access 2010 as front end and SQL Server Express 2008 R2 as back end.

I am not sure on SQL Server.Any way to create the free edition of SQL Server Express for my databases.

If my question is wrong,sorry for that.
Please Help me.

Thanks in advance

AR Ratheesh.
Sep 4 '11 #1
3 3231
Stewart Ross
2,545 Recognized Expert Moderator Specialist
I guess you mean that you want to use SQL Server Express for the production back-end database. You should be able to install this on the server you intend to use as the back end, but I think you will need to do so from a SQL Server Express installation file.

I am fairly sure that Management Studio does not provide you with a license to deploy a full-version SQL Server installation as an enterprise server for your organisation.

If you look up the product details for Management Studio and its Express versions on MSDN you should be able to find out for certain what the license conditions are.

-Stewart
Sep 4 '11 #2
Stewart Ross
2,545 Recognized Expert Moderator Specialist
I checked the version info for Express and you can certainly deploy it free of charge for business use on a relatively limited scale. To quote MS's information:

SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applications. Download SQL Server 2008 R2 Express or try SQL Server Code Name “Denali” CTP3, which includes SQL Server Express LocalDB, a new lightweight deployment option for Express.
MS also make it clear that the Developer editions cannot be used for deployment of SQL Server installations.

-Stewart
Sep 4 '11 #3
NeoPa
32,568 Recognized Expert Moderator MVP
Assuming that you're really trying to ask whether it's possible to manage an Express Edition Server instance from the full copy of Management Studion then I think the answer is yes. The best way for you to find out though is simply to try it out.
Sep 5 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
1837
by: Learner | last post by:
we can download the Management Studio Express for free from MS website. I did the same thing on my personal laptop. But can we develop applications using free downloaded Management Studio and deploy later on with the free stuff at work? Or else may i want to get it off Sql server 2005 that we got when we bought the software.
3
2781
by: RayPower | last post by:
I'm having a system using Access 2000 as both front-end (queries, forms, reports & temp tables for reports) & back-end (data) with back-end running on the server. The application runs on the network with around 15 users. The back-end database is suffering from performance issues. There were several corruptions since few months & one major corruption & corrupted the MSysObjects table. Also, the system will run batch process that generate...
3
2614
by: leonaisse | last post by:
Hi I have a bunch on tables and data in my local SQL Server 2005 Express master DB and I want to export it to a database.mdf within my wwwroot (visual studio) file - how can i do this? Thanks for you help leonaisse
5
1488
by: Nick | last post by:
hi, I have a project about to finish. It is asp.net 2.0 project using sql server experss database. Now, I am trying to find some webhost provider for it. I saw some saying asp.net 2.0 support. Is this all I need, or there is some other stuff in order to make the sql server express database supported? Thanks.
1
6279
by: Billy | last post by:
I have read all of the posts regarding this subject as well as 3 "Dummies" guides and I keep having the same problems. I have a very simple multi-user application that has to hit a database. We cuerrently have this system deployed and it is working fine on a domain based network. We are scaling back and the network we will be using is now a workgroup not a domain. It should be simple. I have XP boxes (clients) trying to hit the SQL...
1
1549
by: Jeff | last post by:
Hey I'm wonder if installing Visual Web Developer 2008 Express version an Express version of Sql Server 2005/2008 will be installed too or must Sql Server Express be installed separately??
2
6329
by: John Fox | last post by:
Hi there, We have recently deployed a couple of new SQL 2005 x64 servers in our hosting environment. We have previously used SQL 2000. I need to start rolling out the new client tools so our developers can start working on them. I tried to copy the sql tools msi off the installation CD and install it on the developers machine but it will not install on them as the workstations are 32bit and the server is x64.
1
4505
by: Alex Pavluck | last post by:
Hi. I am managing a SQL server that is running SQL 2005. I really like the management studio that comes with the full version because I can view tables and easily create relationships and queries. Is this same level of control available with the SQL 2008 express edition? I want to get familiar with the tools and the syntax on my laptop but I don't want to install a full version. Thanks! Alex
4
6533
by: nagmvs | last post by:
Hi i installed Sql Server 2008 R2 in my windows 7 system.When i open the sql server 2008 R2 Management studio and try to connect using the options like Server Type : Database Engine Server Name : (local) Authentication : Windows Authentication when i am click on connect button it shows an error like Cannot connect to (local)
0
1544
by: KennyV | last post by:
Hello, last week we installed a SQL Server 2008 R2 Express edition on a production machine (OS = Win XP with 2Gb ram & Core2Duo CPU) It's running very very slow. A sample query is taking about 1m30seconds to complete, allthough on my laptop it only takes 2 seconds with the same version of SQL Server and the same database (copy of the production database) Any thoughts, this is really driving me nuts?? What I allready did: - update...
0
8356
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
6198
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5666
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4369
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2773
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1776
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.