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
254 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
[X]
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
  • 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
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 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

734 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