Solved

SQL Server Connection String

Posted on 2012-03-27
9
535 Views
Last Modified: 2012-06-21
I have migrated a Microsoft Access 2010 database to Microsoft SQL Server 2008.  Is the following connection string correct?

    <add name="ConnStrNSMDB" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=vcnsql90\i90;User ID=nsm1171;Password=[Secret Password];Initial Catalog=nsm;" providerName="System.Data.SqlClient"/>
0
Comment
Question by:Ray Turner
9 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 37770837
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 37770869
Specifically http://www.connectionstrings.com/sql-server-2008

Much depends on your server set up and how you want to connect to it.
0
 
LVL 20

Expert Comment

by:BuggyCoder
ID: 37770891
Just remove provider key:-

<add name="ConnStrNSMDB" connectionString="Data Source=vcnsql90\i90;User ID=nsm1171;Password=[Secret Password];Initial Catalog=nsm;" providerName="System.Data.SqlClient"/>

Open in new window

0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 8

Expert Comment

by:PeteEngineer
ID: 37770995
0
 
LVL 8

Expert Comment

by:PeteEngineer
ID: 37770999
Or do this:

 In the design view drag in the sql data source object and configure from there.
0
 
LVL 16

Expert Comment

by:Rose Babu
ID: 37771155
remove Provider=Microsoft.ACE.OLEDB.12.0; in the connection string and update the connectionstring as below.
  <connectionStrings>
    <add name="ConnStrNSMDB" connectionString="Data Source=vcnsql90\i90;Initial Catalog=nsm;User Id=nsm1171;Password=[Secret Password];" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Open in new window

Try this
0
 
LVL 35

Expert Comment

by:YZlat
ID: 37771170
you are connecting to SQL Server databse and Microsoft.ACE.OLEDB.12.0 is a provider for Access db
0
 
LVL 13

Expert Comment

by:Rick
ID: 37771487
<connectionStrings>
<add name="ConnectionNameHere" connectionString="Data Source=server.domain.com;Initial Catalog=DatabaseNameHere;Persist Security Info=True;User ID=UserIdHere;Password=PasswordHere;pooling='true';Max Pool Size=240;Connection Timeout=600" providerName="System.Data.SqlClient"/>
</connectionStrings>

Open in new window

0
 

Author Closing Comment

by:Ray Turner
ID: 37774971
Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
monitoring configuration for SQL server DB 32 45
MS SQL Server select from Sub Table 14 41
shrink table after huge delete 2 27
ASP.net Markup for Sub Menu 2 39
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

685 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