Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
257 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

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 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.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

730 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