?
Solved

search sql 2005 db from moss 2007 farm

Posted on 2011-05-05
13
Medium Priority
?
418 Views
Last Modified: 2012-08-14
Dear Friends,

Idea is to search a sql 2005 database from intranet based moss 2007 farm,
this sql 2005 database is sitting inside the network and is hosted on win 2003 server.
(this is one of the databases that is hosted on some server).

kindly advise.
 
0
Comment
Question by:Minesh Shah
  • 7
  • 4
  • 2
13 Comments
 
LVL 8

Expert Comment

by:Kobe_Lenjou
ID: 35697479
And what exacly is your problem?
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35697604
there is no problem, i want to drag it!
idea is to search a database, from sharpoint search, which resides in network but out of the farm.

ANY assistane would be highly appriciated.
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35697612
to search content of various data inside the sql database
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 8

Assisted Solution

by:Kobe_Lenjou
Kobe_Lenjou earned 400 total points
ID: 35697692
So is your problem connecting to the database, or searching in a non-sharepoint db?
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35703843
exactly.
0
 
LVL 6

Expert Comment

by:Jerryuk007
ID: 35728553
One way to do it might be to create BDC (Business Data Catalogs), then create Search Scopes based on the BDC(s) you created.

If you are looking for lookups within an InfoPath Form then you can open a direct connection (OLEDB/ODBC) from within the Form to any MSSQL Server to resolve a specific field.

J.
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35735117
thank you so much friends,
i was just wondering if there are any good links to strat up to search non-sharepoint sql 2005 database from moss 2007 search.
0
 
LVL 6

Expert Comment

by:Jerryuk007
ID: 35736166
Do you know already which fields you are going to search or do you want some kind of free-hand SQL Tool or ManagementStudio Interface within SharePoint?

J.
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35768651
yes i know the fields.
0
 
LVL 6

Expert Comment

by:Jerryuk007
ID: 35768674
Then all you need to do is to create a BDC, then create a Search Scope on that BDC (basically indexing it) which would allow searching it like any other indexed data.

J.
0
 
LVL 10

Author Comment

by:Minesh Shah
ID: 35768685
could you please locate me to start with create a BDC....
0
 
LVL 6

Accepted Solution

by:
Jerryuk007 earned 1600 total points
ID: 35768703
The two tools to create BDC (Business Data Catalog) which I would recommend are:
MOSS BDC Design Studio (from http://www.simego.com/Products/MOSS-BDC-Design-Studio)
and BdcMetaMan (from http://www.lightningtools.com/bdc-meta-man/default.aspx)

Both of them have simple user-friendly interface to get you started.

J.
0
 
LVL 10

Author Closing Comment

by:Minesh Shah
ID: 35774669
ok
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question