2005 no client tools installed

I have a customer that their IT "expert" loaded SQL Server 2005, but
only the database - no other tools, so the SQL Server Management Studio
isn't loaded. Then, the SP for SQL 2005 has been installed on the
machine. Now, I can't load the Management studio because the version are
different - it returns a message about getting a correct version of
sqlcnli.msi.
My main reason to get this is I need to change the SQL security to allow
both windows and SQL security, and I need to set the password for SA. I
know I can change the password via osql -E, but is there a way to change
the main security mode of SQL to allow both windows and SQL from the
osql prompt? If so, what command will do it.
Secondly, what options do I have to get the management studio loaded
since the SP has already been loaded?
Thanks in advance.
Darin
*** Sent via Developersdex http://www.codecomments.com ***>I have a customer that their IT "expert" loaded SQL Server 2005, but
> only the database - no other tools, so the SQL Server Management Studio
> isn't loaded. Then, the SP for SQL 2005 has been installed on the
> machine. Now, I can't load the Management studio because the version are
> different - it returns a message about getting a correct version of
> sqlcnli.msi.
You can download and install sqlncli.msi separately, install it, then run
the SQL Seer 2005 setup again and you should be able to install the client
tools.

> My main reason to get this is I need to change the SQL security to allow
> both windows and SQL security, and I need to set the password for SA.
Can't you do the former from the Configuration Manager and/or Surface Area
Configuration tool? Those should be there.
A|||Where can I download the sqlcnli.msi from?
Also, I looked on the configuration and the surface manager and couldn't
find on either where the security mode for SQL is set.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||Also, I tried to run sqlncli.msi off the CD and received:
Installation of MS Sql Server Native CLient failed baecause a higher
version already exists on the machine. To proceed, uninstall the higher
version and then run MS SQL Server Native Client Setup again.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||> the SQL Seer 2005
Is that the new "Predictive Assessment Tool" I've been hoping for?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%236uQj5THHHA.4112@.TK2MSFTNGP04.phx.gbl...
> You can download and install sqlncli.msi separately, install it, then run
> the SQL Seer 2005 setup again and you should be able to install the client
> tools.
>
> Can't you do the former from the Configuration Manager and/or Surface Area
> Configuration tool? Those should be there.
> A
>|||Dang, I don't typically miss two letters. :-\
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:On2Z1fUHHHA.4068@.TK2MSFTNGP03.phx.gbl...
> Is that the new "Predictive Assessment Tool" I've been hoping for?