Post reply

MSDE 2000 and Encryption

  • May 15, 2006 at 4:22 am

    #93981

    Is it possible to force encryption in MSDE as is done with the network utility in SQL Server 2000.

    I have searched in vain to find the OSQL to switch this on/off.

    Many thanks in advance for any replies....

  • May 17, 2006 at 11:06 pm

    #638627

    The osql utility is not MSDE per se - much like enterprise manager is not sql server standard/enterprise... osql happens to come with all flavours of SQL..

    Anyhow, see here.

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe

    You can force protocol encryption for your entire server.  You can also do a similar thing by setting up a client alias on your workstation so that rather than connecting to Server: [MY_SQL_SERVER], you can connect to alias [MY_DB_SERVER_ALIAS] - for this alias you can specify things such as protocols, etc.  You can get to the tool via

    C:\windows\system32\cliconfg.exe  (on Win2k/NT it will be c:\winnt instead by default).  This tool has a similar checkbox for protocol encryption.

    If you are connecting from your app or from another tool that accepts a connection string then you can specify encryption in the connection string (I've never tried this)

    Good luck

  • May 18, 2006 at 12:24 am

    #638634

    Thanks a lot for your reply - much appreciated....

     

     

  • May 22, 2006 at 2:17 am

    #639168

    No probs

    Just reread my post to remember what I said...  The tool on win2k is still in the system32 folder, just that the windows folder is winnt   Apart from that, all should've been accurate

Viewing 4 posts - 1 through 3 (of 3 total)

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