TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dc
NA
663
0
C# connect to database
Feb 12 2013 5:40 PM
In a C# 2008 windows application I found out the following when the application is executed for a task scheduler:
The windows username and password are exactly the same as the sql server username and password.
Thus if the following is in the connection string in an app.config file, the following will use the sql server login and not the
windows user login correct?
<connectionStrings>
<add name="RPCSS_DEVConnectionString"
connectionString="Data Source=dev;Initial Catalog=DEV2;User Id=myUsername;Password=myPassword;"
providerName="System.Data.SqlClient" />
</connectionStrings>
Also can you tell me if there is any way for the windows user name and password to be used when connecting to the
sql server 2008 r2 database? If so, can you tell me what the connection sting would be so I know to avoid that connection string?
Reply
Answers (
1
)
HOW TO SAVE MULTIPLE RECORDS FROM THE DATAGRIDVIEW INTO DB
C# updating column in sql server database