SQL Server Connection String

Posted on 2012-03-27
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"/>
Question by:Ray Turner
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 25

Expert Comment

by:Lee Savidge
ID: 37770837
LVL 25

Accepted Solution

Lee Savidge earned 500 total points
ID: 37770869

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

Expert Comment

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users


Expert Comment

ID: 37770999
Or do this:

 In the design view drag in the sql data source object and configure from there.
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.
    <add name="ConnStrNSMDB" connectionString="Data Source=vcnsql90\i90;Initial Catalog=nsm;User Id=nsm1171;Password=[Secret Password];" providerName="System.Data.SqlClient"/>

Open in new window

Try this
LVL 35

Expert Comment

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

Expert Comment

ID: 37771487
<add name="ConnectionNameHere" connectionString="Data;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"/>

Open in new window


Author Closing Comment

by:Ray Turner
ID: 37774971

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

623 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