farshad Posted August 5, 2003 Posted August 5, 2003 I am using windows security to connect to sql server. what is the connectionstring that I can use so that a connection can be established based on the user having already logged into windows xp? p.s I do not want to use this as it is for a user which has a login in the sql server. "Server=SVR07;Database=servername;User ID=TestUsers;Password=12345678" Thanks Quote Farshad
JABE Posted August 5, 2003 Posted August 5, 2003 Omit User ID and Password, and add Integrated Security=SSPI . Quote
DayWalker Posted August 5, 2003 Posted August 5, 2003 Try "data source = "ServerName"; initial catalog = "DatabaseName"; Integrated security = "SSPI" Providing the user who is logged on to XP has the relevant permissions. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.