Can't find the SAC tool within SQL Server 2005

Question

Can't find the SAC tool within SQL Server 2005

rami.atedgi

Right there with Babe

Points: 776
More actions
December 1, 2008 at 1:42 pm

#215905

Hi every body,
I was installed SQL server 2005 express edition
when I try to configure the SAC , I could not find it
not in the microsoft sql server subfolder and not via the start menu
any suggestion?
Thanks
Rachamim

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You need SAC to configure SQL Server 2005 Express so I am assuming you need to install SQL Server 2005 Express management studio to get SAC and Configuration manager.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en

Kind regards,
Gift Peddie

rami.atedgi Right there with Babe Points: 776 More actions · Answer 2

I already installed sql server express but its seems that the SAC utility is missing and I dont know the reason

Regared

Rachamim

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

I am not telling you to install SQL Server Express I am telling you to install Management Studio Express it comes with SAC and Configuration Manager.

Kind regards,
Gift Peddie

rami.atedgi Right there with Babe Points: 776 More actions · Answer 4

sorry,

but I meant that the ssmse already install in my machine and I cant find the SAC utility

can it possible that I was download a version without it?

thanks

rachamim

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

If SAC is installed you should find it in the location below double click it and you can configure it from there because I just tried it in my box. I run the developer edition which like SQL Server Express all features comes disabled by default. Here is a tutorial that you may need.

(%ProgramFiles%\Microsoft SQL Server\90\Shared\SqlSAC.EXE)

http://www.databasejournal.com/features/mssql/article.php/3692831/SQL-Server-2005-Express-Edition---Part-4---Surface-Area-Configration.htm

Kind regards,
Gift Peddie

rami.atedgi Right there with Babe Points: 776 More actions · Answer 6

during the installation (within the wizard flow) it asked me if I want it with all the feature and I select the one with all the feature

its said that the installation complete successful

but I'm still cant find it even via the path you sand to me

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

Rerun setup and choose repair because I verified it in my box before I posted it, make sure you choose all components.

Kind regards,
Gift Peddie