Connecting OSQL to MSDE using Windows NT Authentication?

Tech-Archive recommends: Fix windows errors by optimizing your registry



I am installing MSDE SP3a on an NT 4.0 server and experiencing the
'CryptoAPI failed' error.
Now I found the error solution on the MS website, but this requires using
osql and connecting using Windows NT Authentication.

I have installed using SQL securitymode. Will this prevent me from
connecting using Windows NT Auth..?
If so, how can reset the securitymode to SQL after I have installed and
applied the correction for the original issue?

I am logged onto the NT server using the ADMINISTRATOR id, can I start OSQL
without the -U and -P parms?
Does the ADMINISTRATOR id require any additional permissions to connect to
MSDE? The reason I ask is because the MS document specifies "Make sure to
use Windows NT Authication while you are logged on with a Windows NT Account
that is a member of the SQL Server sysadmin role".

Install parms:
MSDERelA\setup.exe DATADIR=^sDataDrive"^ DISABLENETWORKPROTOCOLS=0
INSTANCENAME=XXXXX SAPWD=SA_pwd SECURITYMODE=SQL TARGETDIR=^sDataDrive^ /L*v
^sDataDrive XXXXX.log^ /qb


Thanks for any/all help..

Jim K.


.



Relevant Pages

  • Re: Dell PowerEdge 2450 & Win2k3 server
    ... The other thing you can do is try to run just one CPU and see if one of the ... Enterprise server sp1. ... I get this error after the windows setup process. ... Tried installing with the PERC and also tried installing using the ...
    (microsoft.public.windows.server.general)
  • Re: Windows Advanced Server 2000 PKI
    ... following as a rough guideline for installing a Windows 2000 Enterprise or ... - install or reconfigure your DHCP server accordingly ... Join Windows 2000 member server to new domain and install Enterprise or ... > We would like to setup PKI having server2 as the> certificate authority. ...
    (microsoft.public.win2000.security)
  • Re: Time learning openSUSE
    ... should think about when talking to Windows admins ... I must honestly say I have had more downtime on the Linux server then on ... installing Linux on Bill Gates PC. ...
    (alt.os.linux.suse)
  • Re: SBS & WSUS 3.0
    ... If you are manually installing the WSUS 3.0 SP1 product on Windows Small ... Business Server 2003, follow the instructions in Installing Windows Server ...
    (microsoft.public.windows.server.sbs)
  • Re: hardware firewall
    ... >> comment was about firewalls and security based on his question. ... he wanted to limit the connections to his Windows development web server ... month and am installing over $328K worth of them next week. ... >> I would assume, from your comment, that you've never run a Windows based ...
    (comp.security.misc)