Web Research Network Add-on User Guide
Contents
1. How to Install the Web Research Network Add on 1 If not yet done download the Web Research Network Add on 2 Runthefilewr network setup exe Firewall Configuration The Windows Firewall closes ports such as 445 that are used for file and printer sharing to prevent Internet computers from connecting to file and print shares on your computer or to other resources When SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session SQL Server communicates over TCP ports and these ports must be open SQL Server clients that are trying to connect to SQL Server will be not be able to connect until SQL Server is set as an exception in Windows Firewall To set SQL Server as an exception in Windows Firewall use the steps that are listed below How to configure the Windows XP or Vista Firewall 1 Click Start Control Panel Classic View Windows Firewall 2 On the Exceptions tab select File and Printer Sharing 3 Click Add Port to open TCP Port 1433 4 Click Add Port to open UDP Port 1434 Installation 4 Starting Web Research Server Manager Getting Started This chapter describes the most important steps to create and access Web Research network collections Starting Web Research Server Manager After successful installation you will find Web Research Network Add on in the program groups in the Start menu Click the icon Web Research Server Manag er The Web Research Server2. The collection is temporarily no longer needed All users should no longer be able to access the collection You want to Store the collection somewhere else move it Data backup or protection How to Close a Network Collection 1 Start Web Research Server Manager and expand the SQL Server and the col lection you want to close Note In order to find the physical database file more easily first check and remember the file path in the properties of the collection 2 Right click the collection and click Close Network Collection J Console Root a Web Research Server Manager if Database Servers ify SERVER Windows NT Delete Server Collection Close Server Collection Change Owner Shrink Log File 3 Click Yes to close the collection Contact Addresses 27 Cannot Connect to SQL Server Collections Web Research Server Manager P Do you want to detach the server collection Entwicklung from SQL Server SERVER Afterwards users cannot connect to that server collection anymore Note If you close a collection that is still in use by other users you will get a mes sage If you proceed the users will be disconnected and will probably receive an error message Opening an Existing Network Collection Closed or disconnected network collections can be reconnected anytime so that they are again available on the network How to Open a Network Collection 1 3 Copy the database files to a folder
3. BX 2 Console Root Login Name EA Web Research Server Manager MACROPOOL Martin El 4 Database Servers exe 5 6 Foii NT AMACROPOOLI Ludwig MACROPOOLI Ludwig ollections i F WMACROF Delete MACROPOOL Martin fiz Marketing 5 Bmacror Properties MACROPOGLIRoland gF Properties 3 7 F Users HPYORDER ren VORDEFINIERT Administratoren By group m M Fulltext Index ey Testdaten af Logins Help Shows the properties of the user Users and Rights 22 Cannot Connect to SQL Server Collections 2 Change the permissions according to your needs and click OK Collection User Properties DB user name MAR OP OOL Ludwig The user is member of the Following database roles Read permission cs reader write permission cs writer Structure permission cs structurer Security administrator db securityadmin Access administrator db accessadmin Database owner db owner Description Has the permission to add or delete folders and categories cancel Users and Rights 23 Cannot Connect to SQL Server Collections SQL Server The following chapter describes some advanced settings for the older SQL Server 2000 If you are using SQL Server 2005 Express this is not applicable Changing the Authentication Mode with SQL Server 2000 By default SQL Server 2000 is configured to support only Windows authenti cation SQL Server authentication with username and password independent from Win
4. Moving a Network Collection If you want to store a database file in a different folder on the hard disk of the SQL Server computer you first have to close the collection then move the file by using Explorer and finally reopen it using Web Research Server Manager How to Physically Move a Network Collection 1 Right click the collection and click Close Network Collection 2 Move the database file mdf and the associated transaction log file LDF by using Windows Explorer to the folder of your choice 3 Back in Web Research Server Manager right click the Collections node and click Open Network Collection 4 Type a name for the collection and select the mdf and ldf file Displaying Collection Properties Web Research Server Manager displays additional technical information about network collections To see the information click the Properties node under the Collection node The following properties will be shown Network Collections 15 Cannot Connect to SQL Server Collections i Console Root Web Research Server Manager Database Servers SERVER Window FIB C Console Root Mame value E a Web Research Server Manager El 11 Database Servers S i SERVER Windows NT eg Collections fo Marketing Database name ContentSaver_Testdaten Database owner MACROPOOLI Martin Creation time Jun 12 2006 Default collation Latini General C45 Search in PlainText True 4 Testdaten ef Properties ContentSaver Archive Version 1 61
5. Shrink Log File Liaw LI Network Collections 16 Cannot Connect to SQL Server Collections Importing Local Collection files csa Users can open local collections csa und network collections at the same time in Web Research und copy documents folders between the two collections by using a drop and drop operation To copy all data from a local collection to a server collection we recommend using our migration tool WRCopy exe which is installed in the program directory of the Web Research Server Manager It runs in a separate process and you can continue working with Web Research in the meantime Another advantage is that this tool does not create duplicates in the case that you have to interrupt the copy process Enable Full Text Indexing Search queries in Web Research network collections can be sped up significantly if you enable full text indexing in SQL Server In addition full text search for Micro soft Office documents stored in the network collection will be enabled Note Not every SQL Server edition supports full text indexing How to Create a Full Text Index 1 Right click the node Full Text Index and click Create Full Text Index ary Web Recherche Server Manager if Database Servers I SERVER Windows NT J Collections Tey Marketing Creating a full text index for the server collection Marketing Do you want to proceed 3 The indexing state will now be displayed Name Valu
6. g B Collections fp Marketing 2 MACROPOOL udu Windows User MGmacropo _ Delete Windows User Grant ay Testdaten Wfimacropc LUCE Windows User Grant ae if Standard Grant n Windows Group Grant Name Gast Access security D Den ACCESS SQL Server Authentication Password 3 Click the ellipsis button next to the Password box The Change Pass word dialog box appears Change Password New password pese Confirmed jeereeee coe _ 4 Enter the password twice and click OK Users and Rights 19 Cannot Connect to SQL Server Collections Customizing User Rights at Server Level When creating a new SQL Server user account this new user can only connect to the SQL Server but cannot perform any of these actions Creating new collections Closing existing collections Opening collections Deleting collections Adding new users If you are working as administrator and want a user to be able to perform one of these actions you have to customize the user account to allow one of the above ac tions Note Users who are in Administrator Group can perform any action by default How to Assign Server Roles 1 Click the Logins node right click a user and choose Properties iti Console Root Web Research Server Manager Database Servers SERVER les Console Root Name Type Access H Web Research Server Manager 3 Gast Standard Grant 5 f Database Servers WE MACROPOOLILothar Windows User
7. Grant D SERWER ac NT E MATR OPO u Loduaic Windows User rant a See fmacropo Delete Windows User Grant ay Testdaten Wfimacropc DCE Windows User Grant TA Standard Grant n Windows Group Grant Shows the properties of the user Users and Rights 20 Cannot Connect to SQL Server Collections The SQL Server Registration Properties dialog box appears SOL Server Login Properties Server roles are used to grant server wide security privileges to an user System Administrator sysadmin Security Administrator securityadmin Database Creator dbcreator Description The members of the server role sysadmin can perform any activity on SOL Servers and have complete control over all collections 2 Click the Server Roles tab and select a server role The following roles are available System Administrator can perform any activity on the SQL Server This in cludes the rights of the following roles Security Administrator can create and manage SQL Server user accounts including changing there passwords but cannot create change or delete collec tions Database Creator can create alter and resize collections Adding Collection Users To let users open and access a network collection you need to give at least read permissions Otherwise only System administrators are allowed to access How to Add a New User 1 Right click the Users node and click New User iti Console Root Web Research Server Manager
8. of your choice on the hard disk of the SQL Server computer Right click the Collections node under the SQL Server node and click Open Network Collection 2 Console Root Web Research Server Manager id Database Servers S i SERVER Windows NT es me af Create New Server Collection Open Server Collection The Open Network Collection dialog box will appear Open Server Collection Attach collection using the Following database name Testdaten Select database file mdf me Enter a name for the network collection No spaces and special characters Select transaction log File IdF Network Collections 13 Cannot Connect to SQL Server Collections 4 Click the ellipsis button to choose the database file from the server Please note that only files with an mdf suffix can be selected Select Database File Select 4 database fil on SERVER C 8127 ME free De 2880 ME free Exchange Speicher RECYCLER SOL Server Datenbanken Musterarchive Testdaten Alte Datenformate Grosse Dabenmenge mdf Serverarchiv 41 mdf E Serverdaten maf E test mdf E Entwicklung mdf E Marketing mdf E WebResearch mdf System Yolume Information urlcache w eneel 5 Choose the associated transaction log file LDF Note These files usually reside in the same folder and have the same file name as the mdf file but ending with log MDF 6 Click OK Rena
9. the Internet You can then use the network collection in the same way as on your local network To connect to an external SQL Server follow these steps 1 Enabling SQL Server Authentication If you do not log on to your domain remotely you need to configure SQL Server for SQL Server authentication Please see page 24 2 Configuring Firewall and Proxy Server If you are using a firewall or a proxy server you have to configure them in that way that a connection to Port 1433 is allowed To do so create a new IP pack age filter with the following settings e IP protocol TCP e Direction Both e Local Port Fixed Port Port number 1433 fixed e Remote Port all Ports Port number Depending on the firewall software you can also set which IP address or which address area is able to connect 3 Configuring SQL Server for TCP IP Protocol Depending on the version and service pack the SQL Server is configured to communicate with the connected clients either via TCP IP protocol or Named Pipes or both For remote access TCP IP has to be enabled How to Enable the TCP IP Protocol 1 Start the SQL Server Network Configuration a If you are using the licensed SQL Server Version you will find a shortcut in the SQL Server program group b If you are using MSDE 2000 start the program SVRNETCN exe in this folder C Program Files Microsoft SQL Server 80 Tools Binn 2 Verify that the TCP IP protocol is activated on Port 14
10. 33 3 Click OK 4 Enable PING Web Research pings a SQL Server computer before connecting Check if ping is possible Type the command ping server com at the command line It should return a reasonable result SQL Server 25 Cannot Connect to SQL Server Collections Troubleshooting Cannot Connect to SQL Server Collections If you cannot connect to a SQL Server or network collection don t only rely on the error message you get Check the following causes 1 MS SQL Server Service must be available If you get the error message SQL Server does not exist or access denied a Verify the server name or IP address and ping the server computer with the Ping command form the command line b Check if the SQL Server service is running c Check firewall settings and network settings Maybe they are too restric tive See page 25 for more details d Check if the TCP IP NetBIOS Helper system service is running on the SQL Server machine 2 Wrong autentication mode If you get the error message Login failed for user User name Cause Not associated with a trusted SQL Server connection You try to connect to an SQL Server with username and password but this SQL Server is not configured for SQL Server authentication You need to change the authentication mode See pages 8 and 24 3 Check access rights Start Web Research Server Manager and check 1f the user account you are try ing to connect is li
11. Database Servers SERVER Windows NT C Seles Console Root Name Login Mame Database z lg Web Research Server Manager EE dbo MACROPOQL Martin Granit 5 4 Database Servers LEIMACROPOOLI Ludwig MACROPOOL Ludwig Grant Ha SERVER Windows NT Ef mMacROPOOL Martin MACROPOOL Martin By group m ld a an F MACROPOOL Roland MACROPOOL Roland By group m ES Properties PI VORDEFINIER T Administratoren VORDEFINIERT 4dministratoren By group me Mew User WE New Window from Here New Taskpad View Export List Help Adds security account to the current collection Users and Rights 21 Cannot Connect to SQL Server Collections 2 Select a Login name and a DB user name New User Login name DB user name Markus The user is member of the following database roles WW Read permission cs_ reader Write permission cs_ writer Structure permission cs_structurer Security administrator db securityadmin Access administrator db_accessadmin Database owner db_owner r Descripten Has the permission to add or delete folders and Categories 3 Select the permissions you want to grant to the user An explanation of the user rights can be found on page 18 Change User Rights at Collection Level How to Change the User Rights in a Collection 1 Click the Users node right click a user and click Properties iti Console Root Web Research Server Manager WDatabase Servers SERVER Windows NT C
12. Manager will be loaded in the Microsoft Management Console At first no SQL Server will be displayed im Web Research Server Manager File Action View Favorites Window Help amp m B im Console Root E Console Root Mame E in Web Research Server Manager cfg Web Research Server Manager id Database Servers Connecting to SQL Servers In the next steps you make a connection to a SQL Server so that you can create network collections and administer users Note You must have the permission to log on to the SQL Server How to Add a New SQL Server Registration 1 Right click the Database Server node and click New SQL Server Registra tion Getting Started 5 Connecting to SQL Servers J Console Root Web Research Server Manager Mew SOL Server Registration WE Heu Window From Here New Taskpad View Export List Help The Connect to SQL Server dialog box appears New SQL Server Registration Enter the Following information to connect to Microsoft SQL Server 1 Type domain name iF available or select one From the list MACROPOOL 2 Type server name or select one From the list SERVER Refresh 3 Specify login information For this SQL Server f Use integrated security provided by Windows 2000 P Server 2003 f Use specific login name and password Login name Password Test Connection ce 2 If you are working on a Windows netwo
13. Web Research Network Add on User Guide For Version 2 7 Copyright macropool GmbH 2001 2007 Hin macropool General Information Table of Contents Table of Contents Introduction General Information System Requirements Microsoft SQL Server Express Edition Web Research Network Add on Web Research Installation Installing Microsoft SQL Server 2005 Express Edition Installing the Web Research Network Add on Firewall Configuration Getting Started Starting Web Research Server Manager Connecting to SQL Servers Creating a New Network Collection Adding Users Opening a Network Collection in Web Research Network Collections General Information about Network Collections Creating a New Network Collection Closing a Network Collection Opening an Existing Network Collection Renaming a Network Collection Deleting a Network Collection Moving a Network Collection Displaying Collection Properties Shrinking the Log File Changing the Database Owner Importing Local Collection files csa Enable Full Text Indexing Users and Rights General Information Server based Security Access Protection at Database Level Adding a New SQL Server User Account Changing the Password Adding Collection Users Change User Rights at Collection Level SQL Server Changing the Authentication Mode with SQL Server 2000 Remote Internet Access 1 Enabling SQL Server Authentication 2 Configuring Firewall and Proxy Server 3 Config
14. dows accounts 1s not possible by default Changing the Authentication Mode 1 Stop SQL Server and all related services from the Services applet in Con trol Panel 2 Click Start click Run type regedit exe and then click OK 3 Go to the following registry key for the default instance HKEY LOCAL MACHINE SOFTWARE Microsoft MSSQLServer MSSQLServer O x i Registry Editor Registry Edit View Favorites Help Fl MSE ngm MSFTPSYC lab Default REG 52 value not seb al MSM a8 duditLevel REG DWORD Ox00000000 0 EN Ma enter lab DefaultLagin REG 5 quest Hg Client ab istendn REG MULTI SZ SSMSSH70 SSNETLIE HE MSSQLServer y IRD OxO0000002 21 CN Replication ae Modify lab Maps Delete fee ab Map_ Rename ing SetHosth ORD Ox00000000 0 2 AY Tapeloadwaittime REG_DWORD OxFfffFfff 4294967295 Rg uptime_pid REG OWORO Gx00000294 660 A uptime_time_utc REG_BINARY dc 2b cd 90 a0 Sd c3 01 My Computer HKEY LOCAL MACHINE SOFTWARE Microsoft MS SOL Server MSSOLSer ver 4 On the right hand pane locate the value LoginMode right click it and click Modify In the dialog box that appears set the value to 2 6 Click OK and restart the SQL Server service SQL Server 24 Cannot Connect to SQL Server Collections Remote Internet Access If the SQL Server is installed on a workstation with direct Internet connection it would be possible to access the network collection over
15. e Date of last change 12 06 2006 11 30 14 Size of the index 24 MB Number of indexed items 125965 Location of the full text index C Programme Microsoft SQL Server MS5 Status Idle Name of the full text index Doc _Desc Note Creating a full text index can take some time You should not interrupt this process The index can be deleted anytime later Network Collections 17 Cannot Connect to SQL Server Collections Users and Rights General Information Access protection is provided by the security features of the SQL Server The ar chitecture of this security system is based on users and groups The permissions are assigned to local or global Windows security accounts or alternatively to SQL Server security accounts which can be administered independently from Windows NT 4 0 2000 and Server 2003 Server based Security At the server level you can administer the following rights Standard User Is able to connect to the SQL Server and use collections System Administrator sysadmin Has the permission to perform all actions on SQL Server and access any databases Security Administrator securityadmin Is able to add and administer SQL Server users and change their passwords Database Creator dbcreator Is able to create and delete collections da tabases e g for Web Research Access Protection at Database Level In addition every collection itself has access protection features and user roles T
16. e Licensee macropool GmbH Lx Fullest Index Data File Logical file name GhneInhalt af Logins Data file Physical file name D SQL Server CatenbankenmTestd Data file File size 871 8 ME Log file Logical File name OhneInhalk_log Log file Physical File name Ci SOL Server Datenbanken Testd Log file File Size 0 5 ME Shrinking the Log File Microsoft SQL Server has a system inherent characteristic to log database transac tions Thus log files of a database are growing continuously until you manually shrink the log file How to Shrink the Log File of a Network Collection 1 Right click the collection and click au Log file J Console Root ry Web Research Server Manager B 13 Database Servers if SERVER Windows NT B a Collections Properties ote Delete Server Collection Logi Close Server Collection Change Owner Shrink Log file 2 Click Yes Changing the Database Owner Every collection has its owner dbo which is displayed in the collection proper ties In most cases this is the user who originally created the collection The data base owner has the rights to perform any activities in that database How to Change the Owner of a Network Collection 1 Right click the collection and click ee Owner Console Root ee E da Web Research Server Manager if Database Servers ly SERVER Windows NT Js Collections Properties Delete Server Collection Close Server Collection Change Owner
17. entSaver server archives Introduction 3 Installing Microsoft SQL Server 2005 Express Edition Installation Installing Microsoft SQL Server 2005 Express Edition As described earlier the Web Research Network Add on requires Microsoft SQL Server If you are working in small work groups or you only want to evaluate Web Research Network Add on on a network you can use the free Microsoft SQL Serv er 2005 Express Edition You can also use SQL Server 2000 Desktop Engine MSDE Choose a Windows computer with enough performance this workstation should be ready for permanent operation so that users can reliably use the network collec tions SQL Server 2005 Express can run under Windows 2000 XP Server 2003 or Vista Note Administrator rights are required for the installation How to Install Microsoft SQL Server 2005 Express Edition 1 Before you install any member of the SQL Server 2005 Express Edition fami ly you must download and install the Microsoft NET Framework 2 0 1f it is not yet installed 2 Afterward download SQL Server 2005 Express Edition with Advanced Ser vices and run the file sq12005express_en exe 3 Microsoft SQL Server 2005 will be installed with best configuration settings for using Web Research Installing the Web Research Network Add on You can install the Web Research Network Add on on any Windows computer of your choice It is not required to run the actual SQL Server on the same machine
18. ew Login J Console Root a Web Research Server Manager 13 Database Servers El lg SERVER Windows MT a Collections iy Marketing The Add Login Wizard appears 2 Click Next and choose the authentication method Depending on how your SQL Server is configured you can choose between two methods a Windows Authentication The user does not need extra identification he automatically gets verified with his Login on the Windows network or on the workstation b SQL Server Authentication If the SQL Server is configured this way the SQL Server Authentication is also available 3 a If you chose Windows Authentication click Select to choose a user or a user group Do only select one name and click OK Getting Started 9 Adding Users Select Windows Account List Mames From E MAaCROPOOL Hames E IUSA_SERYER Internetgastkon Yordetiniertes Konto fur anonymen Zug E MM SERVER I5 FProzesskon Vordetinietes Konto fur Intemet Informa E krbtat Dienstkonto des Schlusselvertelungsce E Local Remote Local Remote Schnittstelle fur Wahlen bei Bedart Kor Lothar Lothar Scharnagl La Martin Martin Koppmann E NetShowservices Windows MecWindows Media Dienste werden unter c a Add Names MACAROPOOLS Ludwig b If you chose the SQL Server Authentication type the user name and the password and click Next 4 In the following step you must specify which collections the user can use if the
19. he access protection cannot be applied on a single folder and documents The permis sion is always applied to the entire collection You can use several collections and set the access protection to your needs The following collection roles are avail able Reader cs_reader Can read and search all documents Writer cs_writer Can save and work with documents in the collection Structurer cs_structurer Is allowed to create folders and categories Security Administrator db_securityadmin Can set the rights of the us ers within a certain collection Access Administrator db_accessadmin Can only add or delete a collec tion user within the actual collection Database Owner db_owner Has all rights within a collection Adding a New SQL Server User Account Please see the Adding Users section on page 8 Changing the Password If have a login name with SQL server authentication you can change the password Note It is not possible to change Windows NT user account passwords Users and Rights 18 Cannot Connect to SQL Server Collections Changing the Password of a SQL Server User Account 1 Click the Logins node right click a user and choose Properties im Console Root Web Research Server Manager Database Servers SERVER KBX 2 Console Root Name Type Access Web Research Server Manager Ifi Gast Standard Gai E4 Database Servers Af MACROPOOLILothar Windows User Grant ify SERVER Windows NT
20. lections are created and administered with Web Research Server Manager System Requirements The following information will give you an overview of requirements for using the Web Research Network Add on Microsoft SQL Server Express Edition To use the Web Research Network Add on you need MS SQL Server installed on one of your PC workstations or servers on your network There are various ver sions of SQL Server available and there is probably already one installed on your company network Web Research requires at least version 2000 If you do not yet have a MS SQL Server you can use the free Microsoft SOL Server 2005 Express Edition You find an explanation how to obtain and install it on page 4 Web Research Network Add on The Web Research Server Manager is the main administration tool for network col lections With this software you are able to create network collections on one or more SQL Servers and manage the users access to these collections This tool can be installed on any workstation on the network so that you are able to administer the network collections remotely from any workstation on your network The Web Research Server Manager can be installed on any computer where Web Research Professional can be installed Web Research To be able to work with network collections every user needs Web Research Pro fessional or its predecessor ContentSaver 2 x Web Research network collections are fully compatible with Cont
21. ming a Network Collection If necessary you can rename a network collection Note By changing the name of the collection the physical file name of the data base file does not change Clients that opened the collection under the old name have to reopen the collection because they can no longer connect under the old name How to Change a Collection Name 1 Click the collection that you want to rename and click the node a second time so that the name becomes editable Alternatively choose the Rename command from the shortcut menu J Console Root E web Research Server Manager 14 Database Servers Si Fly SERVER Windows NT EL Collections Marketing 2 Change the name and press ENTER Network Collections 14 Cannot Connect to SQL Server Collections Deleting a Network Collection If you want to delete a network collection that 1s currently opened in SQL Server you need to use the Server Manager because the database files are locked during use Note If a network collection is already closed disconnected from the SQL Server you are able to delete the data file manually in Explorer How to Delete a Network Collection 1 Right click the collection and click Delete Network Collection PA Console Root H a Web Research Server Manager B 13 Database Servers I fy SERVER Windows NT a Collections fa Marketing Delete Server Collection Close Server Collection Change Owner 2 Click Yes to confirm
22. ollections fn Marketing Properties Users Full Text Index af Logins After the collection is created you should specify the users who are allowed to access the collection Adding Users If you want a person or group to use server collections you must give them the permission to connect and access them To control this Web Research Network Add on uses the security features of MS SQL Server Getting Started 8 Adding Users A special role is given to the Windows user group Administrators All members of this group have by default full rights and are allowed to perform all activities on the SQL Server and its databases All further users must be explicitly granted access Click the Logins node to see all users who can already connect to the SQL Server imi Console Root Web Research Server Manager Database Servers SER Slee EI Console Root Name Type Access a Web Research Server Manager fc aet Sandan Grai H MACROPOOL Lothar Windows User Grant MPIMACROPOOL Ludwig Windows User Grant MPIMACROPOOL Martin Windows User Grant 14 Database Servers Biy SERVER Windows NT 1 Collections Marketin E i j H MACROPOOLI Roland Windows User Grant H Properties Users fi Markus Standard Grant Full Text Inde Af VORDEFINIERT Admin Windows Group Grant If you want to allow further users to access SQL Server proceed as follows How to Add a New Login 1 Right click the Logins node and click N
23. pen Server Collection VIE Mew Window From Here Mew Taskpad view Export List Help 2 The Create Collection Wizard appears Click Next to type a name for the network collection and click Next Create Collection Wizard Specify collection name Each Web Research server collection has unique name Type a name For the new collection Mame of the collection Marketing lt Back Cancel 3 Click Search to choose a folder on the SQL Server computer where the col lection should be stored Note Only the folders of the SQL Server computer are shown not those of your lo cal workstation on which you are using the Server Manager You can only Getting Started 7 Adding Users choose folders from fixed hard disk drives Select Folder Please choose folder on SERVER Ea C 8047 ME free E3 Or 2882 ME free _ Exchange Speicher RECYCLER SOL Server Datenbanken System Volume Information urlcache E3 E 1 30618 ME free Ea M 16047 ME free 4 After choosing the folder you can change the suggested database file name Note Do not change this file name unless it is absolutely necessary Click Next to create the collection The collection is now added to the console hierarchy iti Console Root Web Research Server Manager Database Se Seles Console Root Web Research Server Manager a Database Servers Properties Full Text S i SERVER Windows NT indes a C
24. re are already collections present Add Login Wizard Select server collections You musk specify which collections the new user is allowed to access Choose the collections which the user can access lt Back Cancel 5 Click Next to finish the wizard You will find more details about user rights later in this part the user guide Note If a user appears under Logins he already has access to the SQL Server Getting Started 10 Opening a Network Collection in Web Research Opening a Network Collection in Web Research After creating the collection with Web Research Server Manager you are now able to use it with Web Research Professional How to Open a Network Collection in Web Research 1 Start Web Research Professional 2 On the File menu point to Open and click Network Collection 3 Click Next and specify a SQL Server Open Network Collection Wizard Step 1 of 4 Specify Computer Where the Collection Is Stored Specify the computer where the collection you want to open is stored 1 Select the domain or workgroup in which the computer is located optional 2 Spedfy the computer where the network collection is stored Information about network collections 4 Click Next and choose the authentication method according to the configura tion of the SQL Server and the user type Choose a collection on the SQL Server and click Next 6 Type a display name which will be used to display that ne
25. rk with a domain please choose this domain or enter a new one 3 Enter the name or the IP address of the computer where MS SQL Server is in stalled and ready to use 4 Click Test Connection If the connection is successfully established click OK Otherwise note the given message and check the following potential problems Error 1 SOL Server doesn t exist or access denied Answer The SQL Server is not available because the service has to be started or it is not installed on that computer There can also be problems with firewalls and the network configuration Error 2 The user name is not available or the passwords incorrect Other possibility The access is explicitly denied Solution Let the SQL Server administrator grant you access Getting Started 6 Creating a New Network Collection Error 3 Login failed for user User name Cause Not associated with a trusted SOL Server connection Solution Change the authentication mode If necessary create a SQL Server user account with a user name and password Creating a New Network Collection After you have added a SQL Server registration you can create your first network collection on the SQL Server How to Create a Network Collection 1 Right click the Collection node and click Create New Network Collection Console Root da Web Research Server Manager 4 Database Servers Sy SERVER Windows NT a CE of Ml Create New Server Collection O
26. rver Collection 13 Rename 14 Shrinking the Log File 16 SQL Server 24 Change Authentication Mode 24 Remote Access 25 T Troubleshooting 26 U Users and Rights 18 Access Protection at Database Level 18 Add 8 Add a new SQL Server User Account 18 Adding Collection Users 21 Change at Collection Level 22 Change the Password 18 Customizing at Server Level 20 General Information 18 Server based Access Security 18 Index 28
27. sted under Logins If the user is listed there right click it and click Properties Afterward click the Collections tab and check if at least one collection is checked Troubleshooting 26 2 E 2 Contact Addresses The Web Research team would be glad to here from you Ask us questions share your experiences report problems or make suggestions e Send an e mail message to support macropool com e Fax Fax 49 9602 615411 e Postal address macropool GmbH Postfach 1052 D 92661 Altenstadt GERMANY Contact Addresses 27 o Index Note The page number used refers to the page number in this User Manual When opening the Man ual with Adobe Reader the page number will not be identical to this Index C Contact addresses 27 G Getting Started Adding Users 8 Connecting to SQL Servers 5 Creating a New Server Collection 7 Opening a Server Collection in Web Research 11 Getting Started 5 Starting Web Research Server Manager 5 Installation 4 Firewall Confiiguration 4 Microsoft SQL Server 2005 Express Edition 4 Web Research Network Add on 4 Introduction 3 General Information 3 System Requirements 3 P Password 18 S Server Collections 12 Change Database Owner 16 Closing a Server Collection 12 Creating a New Server Collection 12 Delete 15 Displaying Properties 15 Enable Full Text Indexing 17 General Information 12 Importing Local Collection files csa 17 Move 15 Opening an Existing Se
28. twork collection in the user s Web Research Folder List Getting Started 11 General Information about Network Collections Network Collections General Information about Network Collections Web Research network collections are MS SQL Server databases which have Web Research compatible data structures and procedures You can use more than one collection per SQL Server simultaneously All Web Research Professional clients create a direct connection to the databases on the MS SQL Server Access and transaction security are handled by MS SQL Server The performance and capacity are defined by the technical characteristics of the SQL Server the used hardware and the network connection and grade of concurrent use Network collections are stored on the hard disk of the workstation on which the SQL Server is installed A network collection consists of a database file with the file suffix mdf and the associated transaction log file with the suffix Idf By adding and deleting documents the database files grow and shrink automatically after some time Creating a New Network Collection The step by step instructions on how to create a new network collection are ex plained in the section on page 7 Closing a Network Collection Network collections are available for users as long as they are opened on the SQL Server You can remove a collection from the network without physically deleting it Reasons for doing so would be following
29. uring SQL Server for TCP IP Protocol o unun OFF AAA A WwWWwWwW Table of Contents i Table of Contents 4 Enable PING 25 Troubleshooting 26 Cannot Connect to SQL Server Collections 26 1 MS SQL Server Service must be available 26 2 Wrong autentication mode 26 3 Check access rights 26 Contact Addresses 27 Index 28 Table of Contents ii General Information Introduction This chapter is an introduction to the Web Research Network Add on General Information The Web Research Network Add on is a management tool to create and administer Web Research network collections in a network You can store gathered informa tion in a central database to be used by whole work groups like firms editorial and research departments and many more Many Web Research users can share save find and use documents stored in Network collections The technical base for this is Microsoft SQL Server the professional database sys tem from Microsoft or its free light version Microsoft SQL Server Express Edi tion MS SQL Server is a client server database system which manages concurrent multi user access within the network and provides security features In addition it also lets you handle databases with large amounts of data Web Research users can use local collection files csa and SQL Server based network collections simultaneously Documents and folders can be copied and moved between them Web Research network col
Download Pdf Manuals
Related Search