SQL Server Connection String

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"/>
Ray TurnerSenior ConsultantAsked:
Who is Participating?
 
Lee SavidgeConnect With a Mentor Commented:
Specifically http://www.connectionstrings.com/sql-server-2008

Much depends on your server set up and how you want to connect to it.
0
 
Lee SavidgeCommented:
0
 
BuggyCoderCommented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
PeteEngineerCommented:
Or do this:

 In the design view drag in the sql data source object and configure from there.
0
 
Rose BabuSenior Team ManagerCommented:
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
 
YZlatCommented:
you are connecting to SQL Server databse and Microsoft.ACE.OLEDB.12.0 is a provider for Access db
0
 
RickCommented:
<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
 
Ray TurnerSenior ConsultantAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.