SQL and UpdateListItem?

[Andy]

I am migrating my InfoPath form and code to a new Sharepoint server.
Everything seems to work fine except that a routine uses the UpdateListItem
web services. I am getting a SoapException error. I have captured
the detail of the exception and the error is:

The SQL Server might not be started.
0x81020024

I am confused as I am not intentionally using SQL for this application.
Any Ideas?

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello andy,

Please read the links below
http://support.microsoft.com/kb/288536
http://msd2d.com/wb/default.asp?boardid=5&action=9&read=33821&fid=58

I hope these will help you

 

[Andy]

Kalya,
Thanks for the quick reply. Does SQL have to be enabled for this webservice
to operate? I am confused as to why I get this error on a web service call.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello Andy

Yes you need to enable SQl because the Sharepoint DB will be in SQL. If the
DB is not enabled then How will the Webservice call the Data from Sharepoint
which is in SQL. Basically Sharepoint is connected to SQL in the Back end. So
just the Restart the Sharepoint server now to overcome the problem.

 

[SSA]

Andy

Sometimes you get this error even when your SQL is working perfectly fine.
It's strange but this error has nothing to do with SQL. Usually people waste
their time trying to monkey with the SQL server. Check if the web service was
deployed properly on the new server and the user has required privileges on
the new server. Try to access the web service in your browser and see if it
shows you the service description. Also, if you made changes to your
web.config, reverse them and try again. This error usually occurs when the
changes in your web.config are not working. Just for the sake of testing, put
the web service DLL in GAC (if it's your own custom built web service).

Hope it helps

SSA
MOSS MVP