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
253 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

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