March 19, 2006 at 9:39 pm
The installation of SQL 2005 was done by someone else, and I suspect some componenets were omitted, or not specified correctly. For instance, the test databases (pubs & northwind replacements) are not there. I also can't get to SSIS from a client, just from the server. What's the best way to make sure everything gets installed, without messing up the databases that a developer is already working with.
March 20, 2006 at 1:49 am
You need to know versions.
Adventure works are a seperate installation.
SSIS is not available if you are using SQL Server Management Studio Express (SSMSE)
If it's a ful verison and you want to add components, just use add/remove programs > change. It's an MSI so you can add change the installed components without reinstalling.
March 20, 2006 at 7:45 am
We're using enterprise manager, actual build # is 9.00.1399.06
SSIS works if I log on to the server directly, but I get an access denied error if I try it from my desktop, although I am a full sql admin. When I go into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tab to enable Services and Remote Connections, but Integration Services does not expand to a Remote Connections option, just Services.
March 21, 2006 at 10:33 am
I'd go to Control Panel, Add or Remove Programs and select Change for Microsoft SQL Server 2005. Then you can go into each component you want to check and add options that might be missing. Don't let it worry you when it goes through the Installation Wizard and System Configuration Check. I've been adding missing components on my pc and test box, and it works great. If you make no changes, nothing is installed or removed.
March 22, 2006 at 2:51 am
You don't want to use enterprise manager, you want to use SSMS.
March 22, 2006 at 6:10 am
Sorry ... my typo .... I meant Enterprise EDITION, not EM .... d'oh !
Thanks for the other suggestions .... I 'll be trying it later today.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply