setting connection string

Question

I have been building my web application with visual studio and sql server express and now I'm in the process of deploying it on a server. I need to change the connection string

This is what I have:

<add name="MySiteDBConnectionString" 
     connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MySiteDB.mdf;Integrated Security=True;User Instance=True"
    providerName="System.Data.SqlClient" />

This is what I need to replace it with:

<add name="LocalSqlServer"
     connectionString="Data Source=DBServerName;Integrated Security=false;Initial Catalog=DBName;User ID=DBLogin;Password=DBPassword"
     providerName="System.Data.SqlClient" />

The problem is that I don't know where or even if I set up a password for the database. What is integrated security? I'm using linq-to-sql, do I also need to make some changes in the dbml file?

Thanks for some suggestions.

This isn't worth of a reply, but connectionstrings.com/sql-server-2008 is a great resource for connection string information! — Prisoner
– Prisoner, Commented Mar 23, 2011 at 2:30

Luke Lowrey · Accepted Answer · 2011-03-23 02:31:09Z

2

If you are not using Intergrated Security you will need to set up a user and password on the database server itself. If you are using shared hosting it is possible this will be provided for you. You can then replace DBLogin and DBPassword with your credentials.

Intergrated security uses your windows login/password details to authenticate against the database.

With your linq to sql if you are not passing in a connection string yourself you will need to use the designer to change the connection to the new database (or just overwrite the one in your config file).

answered Mar 23, 2011 at 2:31

Luke Lowrey

3,2053 gold badges30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

frenchie Over a year ago

ok, I got past that hurdle. I'm also using the file ASPNETDB.mdf and I've attached it to the site. On my local machine, there are no connection strings for it. On the server, I get "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'". I'm guessing I need to create a new tag with <add name="...> What do I put for the name?

tvanfosson Over a year ago

@frenchie - the name parameter should actually be the same as in your original. That's the key that your program uses to look up which connection string to use. Only the value of the connection string should change when you move to your production site.

frenchie Over a year ago

but I didn't specify a name attribute for the second db file.

tvanfosson · Accepted Answer · 2011-03-23 02:33:41Z

0

Integrated security means that it will use credentials that the web site (app pool) is running under to access the database. You'd need to have SQL server set up to allow this account access to read/write your tables in order for this to work. If your web site is set up to run under the anonymous network account, then it's unlikely that this would be the case. If your web site runs under a domain account, then it's possible that you would need to use integrated security.

If you're not using integrated security, then your DB admin will have set up a SQL login for your application. This is the id/password that you need to use in your connection string. It's possible that multiple accounts have been set up, an admin account, a read/write account, a read-only account, execute SP account (these describe the permissions assigned to the account, not necessarily their names). In that case choose the appropriate one -- it's almost certainly not the admin account unless your DBAs know nothing about security.

FYI, if you use the User ID=...;Password=... format, you can omit the Integrated Security=false as it will assume a SQL login account and password.

answered Mar 23, 2011 at 2:33

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

1 Comment

frenchie Over a year ago

ok, that's cleared up. The site is also runnning with a file called ASPNETDB.mdf. There are no connection strings for this database in the web.config file and I'm getting the error Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion. The hosting provider is giving a connection string but I'm wondering what I need to put in for the <add name="..."> tag. Thanks.

Jeffrey Hantin · Accepted Answer · 2011-03-23 03:08:08Z

0

'Integrated Security' mode is what was formerly called 'Use Trusted Connection': it uses the credentials of the currently logged on Windows user (in this case, most likely the IUSR_xxx account the web application is running as, or sometimes the computer account) as its login credentials.

edited Mar 23, 2011 at 3:08

answered Mar 23, 2011 at 2:29

Jeffrey Hantin

36.6k7 gold badges78 silver badges96 bronze badges

Collectives™ on Stack Overflow

setting connection string

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related