Can I exclude the User ID and Password in the connection string

Discussion in 'Databases' started by cindyyu, Sep 23, 2010.

  1. Hi,
    The Connection String provided in our Winhost control panel is following:

    "Data Source=tcp:s03.Winhost.com;Initial Catalog=<database name>;User ID=<user id>;Password=******;Integrated Security=False;"

    Question 1: Can I not put down the User ID and the password in my connection string, and change it to:

    "Data Source=tcp:s03.Winhost.com;Initial Catalog=<database name>;Integrated Security=True;Persist Security Info=True;"

    Btw, do we really leave the password set to "******", or we are supposed to replace it by our real password?

    Thanks a lot!
    -Cindy
     
    Last edited by a moderator: Oct 14, 2015
  2. Ray

    Ray

    No you need to put the the db login and password otherwise your application will not be able to access the SQL server.

    And no, the password is not "*********" we try to keep the password secured and we will not know it. It is common in most companies to put ******* on the password to relay a message that only you know the password.
     

Share This Page