ࡱ> JLI  "bjbj 82^2 2 uu8$5(fQQ:> (((((((N*,(!!!(uu4(!^uu8(!('h(PɈ^'w((0((-- ((-'(P!!!!!!!((!!!(!!!!-!!!!!!!!!2 ;: You must have a UTAD domain account to access SQL Server data (also known as Data Warehouse). If you need a domain account, please contact the HYPERLINK "http://www.utoledo.edu/depts/it/Service_and_Support/O&I/Help_Desk.html"IT Help Desk at 419.530.2400. There are three basic steps to installing the software needed to access the data from your PC. The steps have all been automated and all you need do is press a few buttons. If you have any problems with the installation or have questions contact your Desktop Support Specialist. If you have not received a notification from us that you have access to the Data Warehouse you may still be able to install this software but you will not be able to access the tables. Instructions  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\install\\current\\mdac_typ.exe" Microsoft Data Access Component (MDAC) installation. This will install the Microsoft SQL Server driver needed to access the Data Warehouse. This is version 2.8 SP1 and comes straight from Microsoft. Click on the link and run the executable file. If you like you can download the file first and then execute it. This is a standard Microsoft install; you need to accept the license agreement and hit the 'Next' button to proceed. After the software is installed you will get a message indicating the Setup is Complete. Click the Close button and proceed to step 2. If you already have Windows XP, you may already have the needed software. If you get an error stating "This setup does not support installing on this operating system" you can skip this step and proceed to step 2. Now that software is installed your computer needs to be configured to access the Data Warehouse. This means the computer's registry must be updated. The registry entries can be updated by clicking on this link:  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\install\\current\\SQLServer.reg" SQL Server Data Warehouse Configuration You can run the file from this web server or download it from the server and run it from your hard drive. When you run the file you will be asked if you are sure you want to add the information to your registry. Click the Yes button. If the registry addition worked you will receive a message indicating it worked. Hit the OK button. Your computer is now configured to access the Data Warehouse. If you want to use the HRS, SAM, or SIS report libraries proceed to step 3. The report libraries utilize Microsoft Access. You will need Access (the 2000 or XP versions) installed to use the libraries. The links below will take you to the report libraries. You can save the links to your desktop and/or copy the files to your PC. The only reason you should copy the files to your PC is to modify the reports for your specific needs. Most users should just place a shortcut on their desktops. Using Microsoft Internet Explorer is the easiest way to create the links or copy the files, but Netscape instructions are also included below. There IS NOT a report library for the ADM, GRD, & BRS databases. The ADM and GRD links below only contain links to the tables in their respective databases. These databases were only created to get you started faster by not having to link to the tables yourself. Microsoft Access 2000 report library links:  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\HRS_FRS\\Hrrpt00.mdb"  HRS & FRS report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\SIS\\sisrpt00.mdb" SIS report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\Sam\\samrpt00.mdb" SAM report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\adm\\admshell00.mdb" ADM   HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\grd\\grdshell00.mdb" GRD Microsoft Access XP report library links:  HYPERLINK "http://utdata.utoledo.edu/EIT.Adm.Wareport/RPT_LIBS/HRS_FRS/Hrrpt_xp.mdb"   HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\HRS_FRS\\Hrrpt_xp.mdb" HRS & FRS report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\SIS\\sisrpt_xp.mdb" SIS report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\Sam\\samrpt_xp.mdb" SAM report library  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\adm\\admshell_xp.mdb" ADM  HYPERLINK "file:///\\\\utad.utoledo.edu\\dfs$\\DepartmentalShares\\EIT.Adm.Wareport\\RPT_LIBS\\grd\\grdshell_xp.mdb" GRD The XP version was created with Service Pack 2. If you are having problems accessing the XP report library, installing the latest service packs for Office XP could solve your problem. NOTE: You can only access the data for the specific Data Warehouse you have been granted access to. You may copy all the report libraries if you wish, but you will not be able to view the data unless you have been granted permissions to do so. Microsoft Internet Explorer instructions To place a shortcut on your desktop: Right-click on one of the links above and then choose Copy Shortcut from the pop-up menu. On a blank area on your Windows desktop, right-click and then choose Paste Shortcut from the pop-up menu. To download the file: Right-click on one of the links above and then choose Save Target As from the pop-up menu. In the Save As dialog box, select a location, and then click Save. Netscape Navigator instructions To place a shortcut on your desktop: Right-click on one of the links above and then choose Copy Link Location from the pop-up menu. On a blank area on your Windows desktop, right-click and then choose New Shortcut from the pop-up menu. Windows will ask you for the location of the item. Right-click in the text box and choose Paste from the pop-up menu. Click the Next button, type a name for the shortcut (you should use the names listed above), and then press Finish. To download the file: Right-click on one of the links above and then choose Save Link Target As from the pop-up menu. In the Save As dialog box, select a location, and then click Save.     SQL Server Client Installation Instructions Revised  SAVEDATE \@ "M/d/yyyy" \* MERGEFORMAT 3/25/2009 Page  PAGE 1 of  NUMPAGES 2 .LMNRS[\{ e f ӦӄpXDX&hvChvC5CJOJPJQJ\aJ/jhvChvC5CJOJPJQJU\aJ&hvChvC5CJOJPJQJ\aJhyM,CJOJPJQJaJ&h>**䴳ʴϴ/䴳ʴϴ)䴳ʴϴ䴳ʴϴ**䴳ʴϴ)䴳ʴϴ*B*CJOJPJQJ\aJph+#$%{|},-45-.124 ]!^!_!ïÛÇÇÃ{jh$Uh_B&hvChvC5CJOJPJQJ\aJ&hvChvC6CJOJPJQJ]aJ&hvChvC5CJOJPJQJ\aJ hvChvCCJOJPJQJaJ)jhvChvCCJOJPJQJUaJ,hvChvC>*B*CJOJPJQJaJph/iQ/ !]!^!`!a!c!d!f!g! dgdf & Fddd[$\$gdvC & Fddd[$\$gdvCddd[$\$gdvCddd@&[$\$gdvC & Fddd[$\$gdvC_!a!b!d!e!g!h!j!!!!!!!!!!!!!!!!!!!!!"""""" " " "ǾӺh_BjhUhh4mHnHujhzOnUhfhzOnh5CJOJQJaJhfhf5CJOJQJaJjh$Uh$$g!i!j!!!!""" " " "gd $0*&dPgd &dPgd dgdf 6&P1h:pf/ =!"#$% DyK yK http://www.utoledo.edu/depts/it/Service_and_Support/O&I/Help_Desk.htmlj 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~ OJPJQJ_HmH nH sH tH J`J _BNormal dCJ_HaJmH sH tH d2d vC Heading 3ddd@&[$\$5CJOJPJQJ\^JaJDA D Default Paragraph FontRiR 0 Table Normal4 l4a (k ( 0No List RR vCHeading 3 Char5CJOJPJQJ\^JaJXX vCrheadingddd[$\$CJOJPJQJ^JaJPP vCbodyddd[$\$CJOJPJQJ^JaJ4U!4 vC0 Hyperlink >*ph(1( vCbluetext*WA* vC`Strong5\.XQ. vC@Emphasis6]4@b4 f0Header  H$6/q6 f0 Header CharCJaJ4 @4 f0Footer  H$6/6 f0 Footer CharCJaJRR zOn0 Balloon Text dCJOJQJ^JaJN/N zOn0Balloon Text CharCJOJQJ^JaJPK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]   2 <<f _! "g! "eRH Tfmqv|${}~,4-1 XXXXXXXXXXXXXXEoyt!@  @ 0(  B S  ?H0(   _Hlt225675550 _Hlt225675551 @@ ^^``aacdfgij ^^``aacdfgij .LMNRS[\{ # # ]^^``aacdfgi .LMNRS[\ # # ^^``aacdfgij ?%^)<~4,B78Vf*;xB<%^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.^`.^`.pp^p`.@ @ ^@ `.^`.^`.^`.^`.PP^P`.;xB78?%^)~4,VS{ $?@BCDEFGHKRoot Entry FizɈMData 1Table"-WordDocument82SummaryInformation(9DocumentSummaryInformation8ACompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q