Showing results 1 to 2 of 2

Thread: Password on SQL server2005

  1. #1
    Join Date
    17.12.2007
    Posts
    35

    Default Password on SQL server2005

    Hi
    I'm using SQLDRV to write data to a new DB in SQL 2005 and ADO to to read data.
    I want to setup a DSN (on the server and on WEB client) with mixed authentication mode and with an existant default user (ie sa), this to avoid, in case of hardware changes, to add a new user on SQL. Normally "sa" has password, but zenon installation probably password was changed. I don't want to change password because I don't know if zenon use this user, so my question is ....is possible to know password of 'sa' user on SQL Server2005 (V6.21,V6.22)

    Thanx

  2. #2

    Default Re: Password on SQL server2005

    we recommend installing a new SQL Server 2005 EE instance, if you plan to read and write data with the SQL driver. This to be indepenant of zenon editor projects and or future changes in the database being used by zenon.

    You can install a new SQL Server 2005 express edition instance parallel to the ZENON_DEV instance which zenon is using, by executing the setup from the zenon installation DVD.

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •