Help!  I am going through the backing up of the database to a server videos of issue 22.  My SQL service is running as TOWER\SQLExpress.  I have created a login called calvaryfellow (with the same as password) and a user in the database I have attached (G:\CALVARY_FELLOWSHIP\APP_DATA\DATABASE.MDF) with access to all asp.net roles and db_owner checked.  (And the user is associated with the login, as shown in the second video).

my connection string in the web.config file is as follows:
    (add name="SiteSqlServer" connectionstring="Data Source=.\SQLExpress; Initial Catalog=G:\CALVARY_FELLOWSHIP\APP_DATA\DATABASE.MDF;User ID=calvaryfellow;Password=calvaryfellow" ="" providername="System.Data.SqlClient")


and I have the following key adjusted under appSettings:
    (add key="SiteSqlServer" value="Data Source=.\SQLExpress; Initial Catalog=G:\CALVARY_FELLOWSHIP\APP_DATA\DATABASE.MDF;User ID=calvaryfellow;Password=calvaryfellow")

I have cleared the cache, restarted the sql service, and have double checked the spelling of the username and password.  when I try to connect, I get the following error:

DotNetNuke Error: - Version 04.05.03

Login failed for user 'calvaryfellow'. The user is not associated with a trusted SQL Server connection.

Everything was smooth sailing until I tried to connect! 

Thank you so much in advance for your help!
This is a great site!

Tony Angelopoulos

Not sure if this is the forum messing up your code, but there is a ="" before provider name in the connection string:

="" providername

Also double check capitalisation for the username and password

ah, yes, it must be. the ="" is not there, it goes directly from the last quote in the connection string, a space, and then providername.
using visual studio to look at the file, it looks like there are no syntactical errors there. Still lost! Thank you for your quick response!

I have also rechecked the file permissions on the file level, and they seem appropriate as well... Still not sure of what else to check. Any ideas out there?

Tony

Found it! Turns out I had Sql set up for Windows Authentication, and needed to set it up for "Mixed Mode" authentication, by right-clicking on the database, going to properties, and checking the appropriate text box under authentication. Now it works! Thanks Lee! Now I'm on to your 3rd video!

Tony

Great!