Last post Apr 22, 2005 09:04 PM by mhamlett
Apr 19, 2005 04:15 AM|nixor|LINK
I'm trying to install DNN on Windows 2003 machine, I've MSDE with trusted connection
<add key="SiteSqlServer" value="Server=(local);Database=DNN;trusted_connection=true;" />
I obtain this error... How Can I resolve it?
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Apr 19, 2005 12:16 PM|Ginters|LINK
Apr 19, 2005 07:42 PM|nixor|LINK
I've read your reply, but I'ven't know what I must to do... [:(]
Apr 19, 2005 11:06 PM|ecktwo|LINK
1. Configure MSDE for mixed mode security (both NT and SQL security).
2. Create a new SQL user with dbo rights to the DNN database.
3. Change your connection string, using the new sql user and password in step 2.
Apr 21, 2005 12:59 PMemail@example.com|LINK
What Ginters is saying is that you should change your key like this:
<add key="SiteSqlServer" value="Server=127.0.0.1;Database=DNN;trusted_connection=true;" />
<add key="SiteSqlServer" value="Server=.;Database=DNN;trusted_connection=true;" />
This assumes that you are only using a default instance of the database.
Your error implies that you need to add the 'NT
AUTHORITY\NETWORK SERVICE' as a user of your database. Add this user to your Security settings in Sql Server and give them at least db_owner access to your database. I just tested this and it works. Or you can go the
route too and add an actual database account. In this case you would remove the "trusted_connection=true" piece in the key and add your username and password as follows:
<add key="connectionString" value="Server=.;Database=Databasename;uid=username;pwd=password;" />
This is the way I do it most of the time, but both ways work.
Apr 21, 2005 01:04 PM|nixor|LINK
Thanks for your reply... but where I must to create a SQL user?? (in windows or in SQL)
How can I set the dbo righes to the DNN database?
Apr 21, 2005 01:33 PMfirstname.lastname@example.org|LINK
Apr 21, 2005 06:28 PM|nixor|LINK
but...the steps are:
- I must to create a new SQL User (in Ent.Man.)
- I create a login/password for this user
- I assign, in the DNN DB, the user created (with read/write permission)
- I use this user/password in the connection string
Is this all right???
Apr 22, 2005 09:04 PM|mhamlett|LINK