Hi I have been developing a website based on filesystem project for last couple of weeks. Now we want to deploy it over iis. I created a virtual directory on my local iis first and pointed it to the source code directory. When I tried to browse the default.aspx page, it threw an error saying "login failed for user machinename/aspnet " to resolve this , i added aspnet user into my sql server db and gave access to schema like dbo, dbo_owner etc. after this the login problem got resolved but then i m getting The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist Please let me know why is it trying to install the DNN again. I dont want to install it again .. I just want to deploy the existing dnn website to which I have added my own code and data tables etc. Please help asap. Regards

Hi Brian To make things straight. I created a new website and this time selected http based website under my local IIS and then added all the code from filesystem based website manually. This was now I have a filesystem based website and another one based on local iis. When I build and run the filesystem web site. it works fine the asp.net web server. But when I try to run the iis instance of website, it doesnt. How do I check if ASPNET has access to dbo.GetPortalAliasByPortalID as mentioned by you? How do I check data provider ObjectQualifier. I am really struggling with this for the whole day.

Open up the web.config files at the root of your two websites.  Search for objectQualifier, and make sure that they are the same (should both be empty).  Near the top of your new website's web.config, there should be a connection string element (which is repeated in the appSettings section).  I would consider changing this connection string to use SQL authentication (create a SQL login in Management Studio, assign that login to your database, make sure it has db_owner permission for that database).  Then it will be a lot easier to test what permissions that user has available to is (you can just log into Management Studio with that user's credentials).

Hope that helps,

---

Brian Dukes Engage Software St. Louis, MO 866-907-4002

DNN partner specializing in custom, enterprise DNN development.