When creating my SharePoint 2010 sandbox farm I wasn’t able to get past connecting to the database server. This is the error I was seeing:
An error has occurred while validating the configuration settings. An exception of type System.ArgumentNullException was thrown. Additional exception information: The errorData argument cannot be null or zero length. Parameter name: errorData
I logged into my SQL Server 2008 R2 VM and updated the Start Mode of SQL Agent and SQL Serve Browser to Automatic.
What / Where / How
Start –> All Programs –>SQL Server XXX –>Configuration Tools –> SQL Server Configuration Manager
After it opens select SQL Server Services, right click on SQL Server Browser, select properties, click on Service, then set Start Mode to Automatic. Repeat these steps on SQL Server Agent service.
After doing this I restarted the server.
——– edit
if you are having trouble finding your SQL Server, Server Name try looking here:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
SNI10.0 — LastConnect
There you will find the name of your SQL Server
8 responses so far ↓
1 Howie // Dec 3, 2009 at 8:55 am
did this fix that error?
2 admin // Dec 3, 2009 at 4:16 pm
yep, let me know if you have any issues with it.
3 Toni // Feb 2, 2010 at 6:20 am
This is very good, but when I trie to start the SQL Server Agent service, I get an error:
Error during request or the service has not acted in time. Details, see the event log or other appropriate error logs.
4 admin // Feb 2, 2010 at 8:27 am
Toni, what account are you logged in as?
5 ict // Feb 4, 2010 at 10:30 pm
Thank guy.
But I do it same tip ,error apear again..plz help me.
Thanks
Yahoo : nguyenthuan.1990
Mail : dandoh@ict24h.net.
6 admin // Feb 5, 2010 at 9:51 am
is the account you are using to install the software an admin on the machine?
7 David // Feb 24, 2010 at 10:32 pm
when setting server agent to start automatic I get an error the remote procedure failed [0x800806be]
any help you can give me here would be much apprecatited
8 admin // Feb 25, 2010 at 2:07 pm
david, is the account you are using an Admin on the box / part of the Admin group?
Leave a Comment