Solved

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

Posted on 2007-03-29
1
218 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

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

Suggested Solutions

In this article I will describe the Backup & Restore 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.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 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