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.developersdex.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|||> 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 message
news:%236uQj5THHHA.4112@.TK2MSFTNGP04.phx.gbl...
> >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
>|||Dang, I don't typically miss two letters. :-\
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:On2Z1fUHHHA.4068@.TK2MSFTNGP03.phx.gbl...
>> the SQL Seer 2005
> Is that the new "Predictive Assessment Tool" I've been hoping for?