Solved

ADO.Net sql connection to a SQL Sever 2012

Posted on 2014-09-11
2
148 Views
Last Modified: 2014-09-18
I have a sql server installed in my pc and I'm trying to get some help with the following connection string... I'm getting an error on myConnection.Open()

            // String conString = @"Data Source=YGUYON-PC\YGUYON28;Initial Catalog=BobTaper;Persist Security Info=True;User ID=xx;Password=xx;Pooling=false;";

           //

            myConnection.Open();

Database screen shotDatabase screen shotDatabase screen shot 2Database screen shot 3
0
Comment
Question by:yguyon28
2 Comments
 
LVL 7

Assisted Solution

by:Camillia
Camillia earned 250 total points
ID: 40317922
I think since you have Windows Authentication, you need to either have Trusted_Connection=Yes attribute or  Integrated Security=SSPI,
0
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40318685
Camilla is right. With Windows Authentication you don't need to provide a user and a password. Will run with the current user credentials. But still miss the provider.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question