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
249 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 69

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 69

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 69

Expert Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now