Microsoft Office Tutorials and References
In Depth Information
configuration is usually listed in this section by default for the Database Server name.
In my case, it is correct. Make sure it is correct for you, or enter the correct server name.
Beneath the server name field is the Database Name field, already filled with a default
name for a BDC database. I like most of the database name, but I am going to get rid of
the GUID part and replace it with the number 1. This means my BDC database name will
be BDC_Service_DB_1 . This database keeps track of all the BDC-related configuration
data, such as external systems and content types. You can follow my lead, or use a
database name that’s right for you.
3. For database authentication, there are two options: the default setting of Windows
authentication or SQL server authentication. Windows Authentication is correct for me,
because my SQL server authentication is Windows integrated. However, if your SQL
server used SQL authentication, this is where you would enter the username and
password this service would use to access the server. In my case, I’m keeping the default
selected for database authentication, as you saw in Figure 3.33.
The next two sections of settings to create a new service application are Failover Server
and Application Pool, as shown in Figure 3.34. The Failover Server section is used if
database mirroring is enabled in SQL and you have an alternate SQL server for this service to
section, creating a
4. In my case, I have only one SQL server installed, so I am going to leave the Failover
Server section blank.
In the Application Pool section, you can either assign the service an existing application
pool or create a new one. I’m going to create a new one in this case. The BDC might be
doing a lot of the work in the future, and I’d rather not have it share an application pool
with any other service.