|
Rank: Newbie Groups: Member
Joined: 10/1/2010 Posts: 3 Points: 9 Location: UK
|
Hi
We are using Windows 2008 x86 with SQL Server 2008 SP1.
we are also using MLA 3.7
When a user expands user databases after 1 min it says page cannot be found.
if they go to Tools > SQL Query it gives error:
The page cannot be displayed because an internal server error has occurred.
why is this?
our config file has <askdb value="true" /> already (as seen in another post) and the SA password is correct in web.config
Quick help appreciated as this is a production server.
UPDATE: this works fine if we login as SA. But not as a user. this use to work fine for users too, (created through website panel)
Chris Danks Cyber Host Pro Ltd - UK Hosting Solutions
|
|
Rank: Newbie Groups: Member
Joined: 10/1/2010 Posts: 3 Points: 9 Location: UK
|
I've just installed the new SQL 2008 SP2 released earlier this week but still we sometimes have this issue. its weird as sometimes it works on new query but sometimes not. either way its really slow.
Chris Danks Cyber Host Pro Ltd - UK Hosting Solutions
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Hi Chris
Are you logging from MLA login page? or silently from a cp?
From MLA, check that you correctly enter the name of the db you want to administer.
From a CP, check that the InitialCatalog parameter (the db name) is correctly sent to MLA silent login module.
|
|
Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
You can also check that all the dbs of your server have the autoclose option set to false.
|
|
Guest |