getting SQL sever password

• rajeshmoorthy

  Grasshopper

  Points: 15

  More actions

  February 1, 2004 at 11:25 pm

  #76119

  I want to connect to the sql server with VB.  I do not want to specify the username and password in my coding.  I would like to use the password of "SA" (System Administrator).  That is if the admin changes the password at the backend the front end should take the password automatically.  How and where do I find the password for SA.

  Thanks in advance

  regards

  Rajesh

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 2, 2004 at 1:14 am

  #492449

  If this is for production code, I think it is not a good idea to allow connections with sysadmin privileges for normal users. Imagine anyone connecting to SQL Server can virtually do everything on the server. Nothing, that would let me sleep quiet.

  What do you want to do with it?

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]