By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,057 Members | 1,401 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,057 IT Pros & Developers. It's quick & easy.

error in connecting with sql server

100+
P: 198
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={SQL Server};Server=" & txtserver & ";Database=master;Uid=sa;Pwd=ukvulcan"
Nov 27 '07 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
If the server has no password then why are you connecting with password ?
Nov 27 '07 #2

100+
P: 198
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 ?
Nov 27 '07 #3

Expert 100+
P: 487
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?
Nov 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.