Error message: The data area passed to a system call is too small. - Lite Edition

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Lite Edition » Error message: The data area passed to a system call is too small.

Error message: The data area passed to a system call is too small.

Options · View

Previous Topic · Next Topic

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

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Lite Edition » Error message: The data area passed to a system call is too small.

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.