Microsoft Office Tutorials and References
In Depth Information
Database Settings page
S P E C I F Y T H E D E F A U L T D A T A B A S E
SharePoint obviously needs to use SQL databases for configuration, content, and service data.
When you create new web applications, a new content database can also be created, if you aren’t
reusing an existing one. Either way, SharePoint needs to know where that database should be.
And since that is a requirement for every database, it is convenient to have the database server
field already filled in by default. That is what the Default Database Server setting is for, so you
can specify a default database server for the server farm. It can be overridden during web
application creation, but at least the option is available to accept the default. As an added bonus, this
setting lets you see, at a glance, what the name of at least one database server is for a new
network with which you might be unfamiliar.
This setting takes you to a page that simply lets you specify the default SQL server for
content and service databases for the farm (Figure 11.33). It is usually propagated on a server farm
with the server specified during installation, but you can change it here.
C O N F I G U R E T H E D A T A R E T R I E V A L S E R V I C E
Data retrieval services are technologies that use Simple Object Access Protocol (SOAP) or XML
to pass data from a source to the data consumer. The Data Retrieval Service page (Figure 11.34)
is prepopulated by default and doesn’t give you much leeway to modify it, although you can
register a third-party service by using the bindservice operation in STSADM.
The data retrieval services supported by default are Microsoft SharePoint Foundation, OLEDB,
SOAP Passthrough, and XML-URL. You can enable or disable these services entirely as a group.
Initially they are all enabled for the farm (globally), but you can choose to stop inheriting the
global settings so you can disable all retrieval services for the specified web application. There is
no option to pick and choose among them. Under normal circumstances, you should not disable
those services. Other settings on this page are basically about the size (in kilobytes) that the data
source returns to the data retrieval service that requested it. The default service is OLEDB. You can