הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
Question
Friday, April 17, 2009 9:24 AM
Hello
i wrote a program that connect to sql server via a specify server name , user name , password
dim baby as new sqlconnection("server=baby;uid=sa;pwd=sa;database=baby")
now how can i coonect to sql server via windows Authentication( how specify a sql connection string)?
All replies (3)
Friday, April 17, 2009 9:35 AM ✅Answered | 1 vote
Hi Baby_Tehran,
you should really use the Search function of this forum. Searching for: SQL windows Authentication gives you the first hit: http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/63bd7ea7-7ab2-419c-9ac7-ff19c7d55405/Mark the thread as answered if the answer helps you. This helps others who have the same problem !
Friday, April 17, 2009 10:03 AM ✅Answered
Thanks Heslacher
Here is the excerpt from that post
Provider=SQLOLEDB;Data Source='(local)';Initial Catalog='<catalog name>';Integrated Security = SSPI; Thanks, A.m.a.L | [Remember to click "mark as answered" when you get a correct reply to your question]
Friday, April 17, 2009 11:58 AM ✅Answered
I highly recommend that you place a bookmark in your browser for http://connectionstrings.com/
This site has just about every variation of connection strings you can imagine. Very useful resource.