myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Error message: The data area passed to a system call is too small. Options · View
rxmiller123
Posted: Sunday, February 21, 2010 11:10:11 AM
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?
elian
Posted: Sunday, February 21, 2010 11:49:35 AM

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

rxmiller123
Posted: Monday, February 22, 2010 7:54:21 AM
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?
elian
Posted: Saturday, March 06, 2010 6:10:29 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
autoclose explanation on MS SQL :
http://msdn.microsoft.com/en-us/library/ms135094%28SQL.90%29.aspx

Help about sp_dboption (the sp used to turn on/off this prop)
http://msdn.microsoft.com/en-us/library/ms187310%28SQL.90%29.aspx
kakazhu
Posted: Friday, June 17, 2011 2:32:23 PM
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?
elian
Posted: Tuesday, June 21, 2011 8:35:59 AM

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.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.