Solved

SQL Express vs. SQL 2005 need additional features but native client install of 2005 isn't helping

Posted on 2007-03-29
1
221 Views
Last Modified: 2010-03-19
SQL Express vs. SQL 2005. I had SQL Express installed on my workstation and SQL 2005 on a server. I also have a free version of Visual Studio. On the server the SQL management studio includes ways to connect to Reporting Services and Analysis Services etc. but on Express it does not, you can only connect to the database engine. Also on the server the Business Intelligence (Visual Studio) it installed includes projects like Report Model and Integration Services etc. which are not included on my free version of Visual Studio. When I try to install the Native Client for 2005 it does not let me and says I have a higher version. I uninstall SQL Express and install the Native Client and still don't get even a management studio showing up or any additional features in Visual Studio. It seems ridiculous that you can only do this work from the SQL server itself, there must be a way to get these tools intalled on a workstation. Thanks
0
Comment
Question by:biotec
1 Comment
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18818772
You have to install the SQL Server 2005 Workstation Tools to get Management Stuido and Business Intelligence Studio.

There should be a Tools folder on the SQL Server 2005 CD. REun Setup from there.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

726 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