Hello everybody.
First of all, thanks for reading.
Today I get an error while was trying to access to the SQL menu under the HOST tab. (NOTE: This erro happend only while acceding to this menu. The rest of the portal works without any DB error)
The error si the next:
"No se puede abrir la base de datos predeterminada del usuario. Error de inicio de sesión. Error de inicio de sesión del usuario 'GUILLERMO4ADE\ASPNET'."
That means:
"Unable to open the database default user. Login error. Login error User 'GUILLERMO4ADE\ASPNET"
It is very weird because a few days ago I was acceding to that menu without any problem. I have check again the permisions, and the folder where the DNN is instaled have the ASPNET user with all the rights given.
Anybody can help me?
Anything have change in the web.config. Allthough I put here my configuration:
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
...
<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="dbo"/>