Hi,
This is my first DNN installation.
I downloaded the latest starter kit last week and fell in love with the platform over the next couple of days, put together a new site on my local machine using SQL 2005.
Yesterday I uploaded the site and the database to my hosting provider, but now I cannot connect to the database!?
I've worked with the provider and checked the connection strings, everything is correct. When I browse to my site in IE (7) the DNN I receive the following message:
'Cannot open database "{DatabaseName}" requested by the login. The login failed. Login failed for user {UserName}
I'm using the same login details I have used in another SQL based site this provider is hosting for me so I know the login details are correct.
When I go to the installation wizard and use the custom or typical method, the file permissions test is passed. I then get to the 'Configure Database Connection' page. Everything is already filled in for me (I have set the connection details in the web.config file). All details have been checked and are correct, yet I receive the following error:
'Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4060
Message: Cannot open database "{DatabaseName}" requested by the login. The login failed.
Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Login failed for user ',{UserName}.'
So I return to the start and select the Auto method. As soon as I click next I get the following error:
'Error Installing DotNetNuke
Current Assembly Version: 04.05.03
ERROR: Could not connect to database specified in connectionString for SqlDataProvider'
below is the relevant sections of my web.config file; which apart from changing the server name works on my local machine.
<
connectionStrings>
<
add name="SiteSqlServer" connectionString="Server={ServerName};Database={DatabaseName};uid={UserName};pwd={Password};;" providerName="System.Data.SqlClient" />
</
connectionStrings>
<
appSettings>
<
add key="SiteSqlServer" value="Server={ServerName};Database={DatabaseName};uid={UserName};pwd={Password};">
</
appSettings>
Of course this is the string provided in the Starter Kit so I expect this to be fine.
Te only thing I can think of is that my provider has not set up the database user correctly although from the conversation we've had it sounds like they have.
Does any one have any ideas?
Thanks
MartyNZ