error in connecting with sql server

[veer]

hello expert
i want to connect sql server with password but it is producing the login failed
and when i access the sql server which has no password it is connecting
both of them are on my lan Network
my code is
con.Open "Driver={SQ L Server};Server= " & txtserver & ";Database=mast er;Uid=sa;Pwd=u kvulcan"

[debasisdas]

If the server has no password then why are you connecting with password ?

[veer]

i think you dont understand my query i have two sql server one has password and other has no password
when i conect with second server which has no password it works fine and when i conect with first server it show error login failed
that is my question


thanks

If the server has no password then why are you connecting with password ?

[CyberSoftHari]

Read my thread posted in below link. That will be easy to use connection string for PWD Sql server and without PWD Sql server.
suggestions in connecting to an access database?