I cant manage to login to a remote Dnn402 db using SQL Express, although I have no problem locally.

Locally I use WinXP, VWD, database is in app_data, connection string is the default:

    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />

My remote server is W2003, on which I have also installed SQL Server Express.  I have given user IUSR_WPG full access on the website directory and subdirs.  I get message "user NT SYSTEM/NETWORK AUTHORITY cannot login etc.etc.

Any suggestions please?

John b

unless you have made IUSR_WPG a domain account I think it won't do you a lot of good as it's trying to access the .mdf file on another machine...

My assumption is that this method connects to the .mdf file directly (i.e. through the filesystem rather than a service).  Could you prove/disprove this by configuring your site to impersonate a domain rather than a machine account with permissions on the 2k3 server's .mdf file location ?

Hi,
I have successfully installed dotnetnuke 3.0.2 on my machine
I wish to connect to remote sql server by modifying web.config

When I tried to change "SiteSqlServer" key, I received dbo.GetPortals Error

Can anyone help me in this? How do I use remote Sql Server with Local Installation of DotNetNuke?

Thanks in Advance.

- - - - -
Darshan Pandit