Hi!

I have a wss site that displays some data from a SQL Server database. This
database contains products, spare parts, descriptions, etc.
This databased is not indexed by the WSS search service. How do I set it up
so that a database on SQL Server is indexed by WSS Search Service?

Thank you!

--
Zaur Bahramov, MCP

Re: How to search SQL Server database from WSS site by Anna

Anna
Mon Aug 25 10:42:43 CDT 2008


Hi,
I assume this is some kind of external SQL data that you want to be added to
search scope, or is it inside a site collection?

If you have WSS only, the option with external database isn't possible: "
Search covers a single site collection. Only SharePoint content in the site
collection can be crawled. You cannot crawl databases, mail servers,
application servers, or Web sites and file shares outside of the site
collection. In a deployment with more than one site collection, each site
collection provides search only for content on that site collection, and
there is no aggregation of search results across site collections"
have a look here for more details on this:
http://technet.microsoft.com/en-us/library/cc288477.aspx

Here some basic steps how to configure search in WSS:
http://geekswithblogs.net/karskip/archive/2007/11/30/117263.aspx

Anna



"Zaur Bahramov" <zbakhramov@msn.com> wrote in message
news:e8GlsTsBJHA.4316@TK2MSFTNGP05.phx.gbl...
> Hi!
>
> I have a wss site that displays some data from a SQL Server database. This
> database contains products, spare parts, descriptions, etc.
> This databased is not indexed by the WSS search service. How do I set it
> up so that a database on SQL Server is indexed by WSS Search Service?
>
> Thank you!
>
> --
> Zaur Bahramov, MCP
>



Re: How to search SQL Server database from WSS site by Zaur

Zaur
Mon Aug 25 14:54:14 CDT 2008

Yes, this is an external dastabase and is not part of WSS content database.
I have hundreds of products and thousands of spareparts that are visualized
in WSS site by DataGridView. What I need is to enable a user searching for a
specific part number or description.
What is the common approach for that?



--
Zaur Bahramov, MCP
"Anna" <Anja_Amelia@hotmail.com> ha scritto nel messaggio
news:utpX4ksBJHA.3200@TK2MSFTNGP03.phx.gbl...
>
> Hi,
> I assume this is some kind of external SQL data that you want to be added
> to search scope, or is it inside a site collection?
>
> If you have WSS only, the option with external database isn't possible: "
> Search covers a single site collection. Only SharePoint content in the
> site collection can be crawled. You cannot crawl databases, mail servers,
> application servers, or Web sites and file shares outside of the site
> collection. In a deployment with more than one site collection, each site
> collection provides search only for content on that site collection, and
> there is no aggregation of search results across site collections"
> have a look here for more details on this:
> http://technet.microsoft.com/en-us/library/cc288477.aspx
>
> Here some basic steps how to configure search in WSS:
> http://geekswithblogs.net/karskip/archive/2007/11/30/117263.aspx
>
> Anna
>
>
>
> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message
> news:e8GlsTsBJHA.4316@TK2MSFTNGP05.phx.gbl...
>> Hi!
>>
>> I have a wss site that displays some data from a SQL Server database.
>> This database contains products, spare parts, descriptions, etc.
>> This databased is not indexed by the WSS search service. How do I set it
>> up so that a database on SQL Server is indexed by WSS Search Service?
>>
>> Thank you!
>>
>> --
>> Zaur Bahramov, MCP
>>
>
>



Re: How to search SQL Server database from WSS site by Zaur

Zaur
Mon Aug 25 16:41:27 CDT 2008

Could WIndows Search Server 2008 Express be a valid solution to address my
issue?
http://www.microsoft.com/enterprisesearch/serverproducts/searchserverexpress/features.aspx

Thank you!


--
Zaur Bahramov, MCP
"Zaur Bahramov" <zbakhramov@msn.com> ha scritto nel messaggio
news:OV0pbxuBJHA.1628@TK2MSFTNGP03.phx.gbl...
> Yes, this is an external dastabase and is not part of WSS content
> database. I have hundreds of products and thousands of spareparts that
> are visualized in WSS site by DataGridView. What I need is to enable a
> user searching for a specific part number or description.
> What is the common approach for that?
>
>
>
> --
> Zaur Bahramov, MCP
> "Anna" <Anja_Amelia@hotmail.com> ha scritto nel messaggio
> news:utpX4ksBJHA.3200@TK2MSFTNGP03.phx.gbl...
>>
>> Hi,
>> I assume this is some kind of external SQL data that you want to be added
>> to search scope, or is it inside a site collection?
>>
>> If you have WSS only, the option with external database isn't possible: "
>> Search covers a single site collection. Only SharePoint content in the
>> site collection can be crawled. You cannot crawl databases, mail servers,
>> application servers, or Web sites and file shares outside of the site
>> collection. In a deployment with more than one site collection, each site
>> collection provides search only for content on that site collection, and
>> there is no aggregation of search results across site collections"
>> have a look here for more details on this:
>> http://technet.microsoft.com/en-us/library/cc288477.aspx
>>
>> Here some basic steps how to configure search in WSS:
>> http://geekswithblogs.net/karskip/archive/2007/11/30/117263.aspx
>>
>> Anna
>>
>>
>>
>> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message
>> news:e8GlsTsBJHA.4316@TK2MSFTNGP05.phx.gbl...
>>> Hi!
>>>
>>> I have a wss site that displays some data from a SQL Server database.
>>> This database contains products, spare parts, descriptions, etc.
>>> This databased is not indexed by the WSS search service. How do I set it
>>> up so that a database on SQL Server is indexed by WSS Search Service?
>>>
>>> Thank you!
>>>
>>> --
>>> Zaur Bahramov, MCP
>>>
>>
>>
>
>



Re: How to search SQL Server database from WSS site by Anna

Anna
Thu Aug 28 10:45:35 CDT 2008

Hello,

Yes that would be a solution for you.
Look here for how to configure it on your wss 3.0 environment:

http://technet.microsoft.com/en-us/library/cc297193.aspx

Anna


"Zaur Bahramov" <zbakhramov@msn.com> wrote in message
news:%235dnVtvBJHA.2476@TK2MSFTNGP06.phx.gbl...
> Could WIndows Search Server 2008 Express be a valid solution to address my
> issue?
> http://www.microsoft.com/enterprisesearch/serverproducts/searchserverexpress/features.aspx
>
> Thank you!
>
>
> --
> Zaur Bahramov, MCP
> "Zaur Bahramov" <zbakhramov@msn.com> ha scritto nel messaggio
> news:OV0pbxuBJHA.1628@TK2MSFTNGP03.phx.gbl...
>> Yes, this is an external dastabase and is not part of WSS content
>> database. I have hundreds of products and thousands of spareparts that
>> are visualized in WSS site by DataGridView. What I need is to enable a
>> user searching for a specific part number or description.
>> What is the common approach for that?
>>
>>
>>
>> --
>> Zaur Bahramov, MCP
>> "Anna" <Anja_Amelia@hotmail.com> ha scritto nel messaggio
>> news:utpX4ksBJHA.3200@TK2MSFTNGP03.phx.gbl...
>>>
>>> Hi,
>>> I assume this is some kind of external SQL data that you want to be
>>> added to search scope, or is it inside a site collection?
>>>
>>> If you have WSS only, the option with external database isn't possible:
>>> " Search covers a single site collection. Only SharePoint content in the
>>> site collection can be crawled. You cannot crawl databases, mail
>>> servers, application servers, or Web sites and file shares outside of
>>> the site collection. In a deployment with more than one site collection,
>>> each site collection provides search only for content on that site
>>> collection, and there is no aggregation of search results across site
>>> collections"
>>> have a look here for more details on this:
>>> http://technet.microsoft.com/en-us/library/cc288477.aspx
>>>
>>> Here some basic steps how to configure search in WSS:
>>> http://geekswithblogs.net/karskip/archive/2007/11/30/117263.aspx
>>>
>>> Anna
>>>
>>>
>>>
>>> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message
>>> news:e8GlsTsBJHA.4316@TK2MSFTNGP05.phx.gbl...
>>>> Hi!
>>>>
>>>> I have a wss site that displays some data from a SQL Server database.
>>>> This database contains products, spare parts, descriptions, etc.
>>>> This databased is not indexed by the WSS search service. How do I set
>>>> it up so that a database on SQL Server is indexed by WSS Search
>>>> Service?
>>>>
>>>> Thank you!
>>>>
>>>> --
>>>> Zaur Bahramov, MCP
>>>>
>>>
>>>
>>
>>
>
>