|
|
Rank: Newbie
Groups: Member
Joined: 2/21/2010
Posts: 2
Points: 6
|
I am using myLittleAdmin Lite 3.6 on a Plesk server.
I can login fine and view the System Databases, activity monitor and such but when I try to click User Databases or New Query, it seems to timeout and then give "The data area passed to a system call is too small." on the right side page.
The server is running MSSQL 2008. The sa password works for login and viewing the system databases, but it also will not list the user databases.
I am not seeing any errors in the Event log. There are many "Starting up Database" events but no errors.
Anyone have any ideas?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
This error usually occurs when - there is an important count of dbs on the server - or when the db have the autoflag property set to true To avoid it, you can simply specify the db name when you log in the login dialog box. UPDATE: as you can see many Startup database event, it means that the autoclose flag is set to true. Change it to FALSE and you will notice great enhancement http://technet.microsoft.com/en-us/library/bb402929.aspx
|
|
Rank: Newbie
Groups: Member
Joined: 2/21/2010
Posts: 2
Points: 6
|
So, by "important count of dbs on the server", you mean that there are too many databases on the server?
A Google search didn't really help me understand the 'autoflag' property you referred to. Could you let me know more about what it is and how to disable it?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
|
|
Rank: Newbie
Groups: Member
Joined: 6/17/2011
Posts: 1
Points: 3
|
So, by "important count of dbs on the server", you mean that there are too many databases on the server?
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Check that you use the latest release of myLittleAdmin.
In the connection page, do not forget to fill the Database text box with the name of the database you want to administer.
|
|
|
Guest |