Josh Haggin wrote
ok, so im finally trying to get this setup to function. i have been testing with a fresh install. i get all the way to the SQL connection part and it fails.
its either in the web.config file or the SQL settings.
lets start with the web.config file. what is the settings (under connection string and app settings) for connecting to sql standard 2005 and 2005 express on a seperate server?
i tried what was posted earlier but it seems like there is information left out, as it did not connect.
- Create a new sql server login which DNN will use. Note the username and password (if using SQL server authentication)
- Create a new database for DNN. Note the database name.
- Set up security in the new database, create a new user and map it to the new login. Assign the proper pernissions and database roles.
- Log in as the new user in SQL Server and create a test table in the new database, insert some dummy values in that table and do a select from that table. If everything works then the sql server side is set up correctly. I you get any issues in DNN, it's mostly a DNN problem.
- In web.config file of DNN, go to the connectionstring and modify the parameters to the use either the servername or ip address, username, password and database name. You have 4 parameters to change. If you're using a different port number or SQL Server instance name from the defaults, the connection string needs to have these also.
If you have connection problems from the web server to the sql server, troubleshoot the connection outside of DNN first by using a sql client tool and test to connect and do the select query as explained above. If you can't connect, turn off the firewall if you have one and test again. Run this command from DOS as a quick test: telnet server name/ip address 1433. If you get a blank screen instead of an error message, then sql server is listening and a connection is open.
If the sql client works from the web server, the issue is most probably the web.config file. Check for spelling and verify that everything in the connectionstring looks good. Error messages from DNN should be clear enough to give you hints and there could be several reason for any issue. Good luck.