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
Peter
NA
20
0
Connection string blues (C# -> SQL)
Jan 25 2009 2:32 PM
I'm learning SQL and how to access it from C#.
This is all on the same machine running XP Pro and .Net 2.0
- I've created a database in SQL Server Express and can manipulate it just fine from the SSMSE console. But when I try to open a connection to it in C# using the
SqlConnection.Open()
method it say's I'm "Not associated with a trusted SQL Server connection".
I've tried different things in the User Id and Password parameters in the connection string, including my PC login password and not using them at all (hoping it would take the default).
When I start up the SSMSE it lists the "User name" as "GEMINI\peter" (GEMINI is my PC) but if I use that in the connection string it just says GEMINI\peter is not associated with a trusted SQL Server connection.
How do I figure out what it wants? Thanks in advance!
Reply
Answers (
4
)
my first qiestion
using .Net Reflector