Login

• Shajan S

  Grasshopper

  Points: 18

  More actions

  July 28, 2005 at 12:09 am

  #110064

  I ve installed sql server 2000 in a windows 2000 server machine.And my vb application is installed in the client machine which contains windows 2000 professional os. While accessing sql server through this application it asks for server machine's password. But i ve to connect to sql server with out giving server's password. Please give me a solution

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  July 28, 2005 at 5:02 am

  #577823

  Hi Shajan,

  If i understand u need to check the connection string of the appilcation and see what username u used to connect the sql server database or check the dsn name if using.

  from

  killer

   

   

• Hemantgiri S. Goswami

  SSC-Addicted

  Points: 443

  More actions

  July 31, 2005 at 10:21 pm

  #578405

  Hi  Shajan,

  Open registry editor : and opn HKEY_LOCAL_MACHINE->microsoft -> microsoft sql server -> 80 -> mssql server -> login mode -> add new string as 1 and value as 1

  it will make you able to log in using sql authentication mode .

  HTH

  

  Hemantgiri S. Goswami | SQL Server Specialist & Consultant
  SQL Server Citation[/url] | Follow me on Twitter