• 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

  • 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.





  • 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 .


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

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

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