Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

asp.net 3.5 vs studio 2010 ultimate and sql express.  Does vs studio 2010 come with a functioning version of sql 2008

Posted on 2011-09-07
6
251 Views
Last Modified: 2012-05-12
I am trying to upload my first database to discountasp.net hosting and can't get it to work.

From within vs 2010 I created a new web site, added new item (sql database) in App_Data folder, created and table, configured the sql datasource.  Ctrl +F5 and I can view the table in my browser.  Changed connection string as per discountasp.net and used their control panel to try to attach database which fails as my version of sql is not supported.

How do I tell which version of sql vs studio is using?

The programs menu on my computer shows sql 2005, 2008, and sql 2008r2 installed.

I also installed sql server express 2008r2..

What version of sql should a small company be using to add a database on their website?
What is the approximate cost?  ms sql server site is confusing and does not show prices.


0
Comment
Question by:ExpressMan1
  • 3
  • 3
6 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 36502389
>>How do I tell which version of sql vs studio is using?

you can run "SELECT @@VERSION" from SSMS

>>What version of sql should a small company be using to add a database on their website?

express is good.

>>What is the approximate cost?  

0$ for express

>>ms sql server site is confusing and does not show prices.

because you need to go through reseller
0
 

Author Comment

by:ExpressMan1
ID: 36503605
Downloaded sql server configuration manager.  Here is a screen shot.  How can I tell which version vs studio is using? Sql-Server-Configuration-Manager.docx
0
 

Author Comment

by:ExpressMan1
ID: 36503699
Ok.  forget the last post.  I have the correct open program now.  "ms sql server management studio"

How or where do I run "SELECT @@VERSION" ?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 36503970
In a query in ssms
0
 

Author Comment

by:ExpressMan1
ID: 36504821
Worked.  Thanks.   Looks like it's running 2 versions.  Is there a way I can cancel one?

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)   Jul  9 2008 14:17:44   Copyright (c) 1988-2008 Microsoft Corporation  Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 36504983
you can stop the service
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
RLDC Reporting in Visual studio 11 29
Add a step to a system backup job 6 16
Testing of the web services 1 32
asp.net mvc , views, hidden values ? 2 16
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question