DNN 4.0 MSDE and connection string

Home ›

ASP.NET Forums » Starter Kits and Source Projects » DotNetNuke » DNN 4.0 MSDE and connection string

Shortcuts

Previous Next

DNN 4.0 MSDE and connection string

Last post 11-10-2005 12:33 PM by abbey normal. 1 replies.

Sort Posts:

DNN 4.0 MSDE and connection string

11-09-2005, 10:27 PM

Contact

15 point Member
abbey normal
Member since 09-15-2005, 5:55 PM
Posts 3

ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: SELECT permission denied on object

Hello. I sucessfully installed dnn 3.0 on my w2k server, but when we upgraded to 2003, I thought I'd upgrade to 4.0 and asp net 2.0. but I have not had any luck on (new, not upgrade) install. I have tried a zillion things. I'm not sure that I have the connection string correct. Can someone see anything wrong with this? Thanks,

<connectionStrings>
<add

name="DotNetNuke"

connectionString="Server=SRV-MY;Database=MYdb;uid=Userid;pwd=Userpw;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Re: DNN 4.0 MSDE and connection string

11-10-2005, 12:33 PM

Contact

15 point Member
abbey normal
Member since 09-15-2005, 5:55 PM
Posts 3

oops. when I assigned the roles to the users in the data base, I assigned all roles, which included db_denydatareader and db_denydatawriter. I took them off, and got farther in the intall, it's just now I have the infamous "object reference not set to an instance of an object " :
create random keys for the Membership machine keys
Line 90: xmlConfig = Config.UpdateMachineKey(xmlConfig)
I'll try a clean install....

Page 1 of 1 (2 items)

RSS Available