Report 87510 Create SQL Users 12-01-12 17:17:31 12360 ACA-TOOL /r€ KsA  {¥B }r ÿÙØ +~aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZš‚ƒÜ„Ž…Ú†‡€ˆà‰âŠß‹çŒåã‘’“ë”™•é–ò—ï˜Ï Û¡ä¢ê£ð¤¥ÊºÌ¼Î¾õÞ÷èùìûîüóþô + Òž©°'-ÆÇÿ !"#$%&()*,./:;?@[\]^¸_`{|}~­ÝÐÔÖרÈÁ³ÃÄ´»Ë›œ±+<=>ñ®¯íöѪÓøæúµ¶·Å¹²½¿ÀÍ0¬«1Ø2ý3ÕÙ456789Aa¦Û Ú…܃Ž„Þõ†’‘BbCc€‡Ddè÷Ee‚ߊàˆâ‰FfŸGgHhIiä¡ãåŒç‹JjKkLlMmNn¥¤Oo§ê¢é•ë“™”ìùîû¼ÌPpQqRrSsºÊáTtôþÉUuð£ï—ò–šVvWwXxYyóüϘZz¾ÎÒ Ò!"#$%&'()*+,-./0ØýÙ456789:;<=>?@†b‡÷‰Ÿgh‹jklm¤ûpqrÊtvwx˜Î[\]¸_`†b‡÷‰Ÿgh‹jklm¤ûpqrÊtvwx˜Î{|}~‡‰††††‡‰‰‰‹‹‹††‰‘‘ûûû˜û›œžŸ†‹û¤¤†û¨©ª««­®¯°±Í³´µ¶·¸¹Ê»ÌÍÎÍÍÁÂÃÄÅÆÇÈÉÊËÌÍΘÐÑÒÓÔÙÖ×Øن††Ý†‰‰á‰‹‹‹æ‹÷ûûûûíûñ˜þ†ö÷øûúû˜ýþÿ +&!³´¹º»¼¿ÀÁÂÃÄÅÈÉÊËÌÍÎÙÚÛÜß+%" ÿ~5~5Ó hÖUCreate SQL Users ?m Êãµ ACA-TOOLH0à°0ÿÿÿÿÓ hÖUCreate SQL Users ?m Êãµ ACA-TOOLH0@ÞH0$0 dd ddddd%HQHRHL dd)H”5wTH)H6”5wTH4 d?@ef  ef ef ef  ef  efefefefefefefefefefefefefefef ef!"ef$$ef%%ef&&ef''ef((ef))ef++ef,,ef--ef//ef00ef12ef44ef55ef66ef78ef9:ef;;ef<=ef>?ef?@ef@AŒ B$ fþÿÿf”5w f6”5w,fÿÿÿ,fûÿÿf-û -3$f--……-‡‡……………-- f f- f f f- f f f…- f ff f f f- f f f- f f f…- f f f f…-‡‡………………f    CurrReport5f   User   Windows Login  RequestOptionsForm5f ú RequestOptionsPage5f c˜A Script ‘c˜A ScriptName ’c˜A DatabaseName c˜A CreateUser3f URL5f URL5f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f ʚ;4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f Which5f Steps5f BelowxRec5f BelowxRec5f CloseAction5f ü df dþÿÿ f d”5wfd6”5wfdÿÿÿf dûÿÿfždfdfdÄ#¨g df  ,‰ User IDLfÑÿÿÿ - CALCFIELDS ID  ´føÿÿÿfõÿÿÿfôÿÿÿfþÿÿÿfýÿÿÿ WRITE WRITEMODE TEXTMODE CREATE CLOSE 0f½ ˜Á SelectFile ìÿÿÿÿ ü\ ðeGeÔT-û`-ûh-ûp-ûx ‘c˜A pDatabaseName c˜A pUserName ’c˜A pPassword “c˜A _tempstrIeÿÿJeüÿEe¸e ee-USE [eÿÿ'ee -]at'eee ee -GOTee eeL-DDIF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'eþÿ'ee -')e'eee ee- DROP USER [eþÿ'ee -]se'eee ee -GOTee ee-use [master]ELEee ee -GOTee eeH-@@IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'eþÿ'ee -')e'eee ee-DROP LOGIN [ELEeþÿ'ee -]se'eee ee -GOTeeýÿe -Pas3ee¸eüÿe-CREATE LOGIN [Eeþÿ'ee -] FROM WINDOWS WITH FRO'ee$-DEFAULT_DATABASE=[master],y'ee(- DEFAULT_LANGUAGE=[us_english]se'e?ee eüÿe-CREATE LOGIN [Eeþÿ'ee-] with password='us'eeýÿ'ee -',s'ee$-DEFAULT_DATABASE=[master],h'ee(- DEFAULT_LANGUAGE=[us_english],e'ee -CHECK_EXPIRATION=OFF,ng'ee-CHECK_POLICY=OFFOFF'e?ee eeüÿee ee -GOTee ee4-,,EXEC sys.sp_addsrvrolemember @loginame = N'eþÿ'ee$-', @rolename = N'sysadmin'r'eee ee -GOTee ee-ALTER LOGIN [ Neþÿ'ee- ] ENABLEN 'eee ee -GOTee ee-USE [Eeÿÿ'ee -]at'eee ee -GOTeeýÿe -Pas3ee´e ee-CREATE USER [ Neþÿ'ee-] FOR LOGIN [ N'eeþÿ'ee -] WITH DEFAULT_SCHEMA=['eeþÿ'ee -]se'eee”e ee-CREATE USER [_Seþÿ'ee-] FOR LOGIN [_S'eeþÿ'ee$-] WITH DEFAULT_SCHEMA=[dbo]'eee ee -GOTee{eP$0$€H$0$|L$ ¨  $€$T$D$ ¤”peeWeeTePe USE [!eeÿÿ!ePe]atUeZeeeWeeTePeGOTUeZeeeWeeTePeHIF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'!eeþÿ!ePe')eUeZeeeWeeTePeDROP USER [!eeþÿ!ePe]seUeZeeeWeeTePeGOTUeZeeeeWeeTePeuse [master]ELEUeZeeeWeeTePeGOTUeZeeeWeeTePeDIF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'!eeþÿ!ePe')eUeZeeeWeeTePeDROP LOGIN [ELE!eeþÿ!ePe]seUeZeeeWeeTePeGOTUeZeeedereeýÿre3erePePasreheeqeeüÿre?erePeCREATE LOGIN [E!eeþÿ!ePe] FROM WINDOWS WITH FROre!eeqePe DEFAULT_DATABASE=[master],y!eeqePe$DEFAULT_LANGUAGE=[us_english]seeaeeqeeüÿre?erePeCREATE LOGIN [E!eeþÿ!ePe] with password='us!eeýÿ!ePe',s!eeqePe DEFAULT_DATABASE=[master],h!eeqePe$DEFAULT_LANGUAGE=[us_english],e!eeqePeCHECK_EXPIRATION=OFF,ng!eeqePeCHECK_POLICY=OFFOFFZeeeWeeTeeüÿUeZeeeWeeTePeGOTUeZeeeWeeTePe0EXEC sys.sp_addsrvrolemember @loginame = N'!eeþÿ!ePe ', @rolename = N'sysadmin'rUeZeeeWeeTePeGOTUeZeeeWeeTePeALTER LOGIN [ N!eeþÿ!ePe] ENABLEN UeZeeeWeeTePeGOTUeZeeeeWeeTePe USE [E!eeÿÿ!ePe]atUeZeeeWeeTePeGOTUeZeedereeýÿre3erePePasreheeqeeWeeTePeCREATE USER [ N!eeþÿ!ePe] FOR LOGIN [ N!eeþÿ!ePe] WITH DEFAULT_SCHEMA=[!eeþÿ!ePe]seUeeaeeqeeWeeTePeCREATE USER [_S!eeþÿ!ePe] FOR LOGIN [_S!eeþÿ!ePe ] WITH DEFAULT_SCHEMA=[dbo]UeZeeeeWeeTePeGOTUeZeeEede eeee eeee eeee{e $oeOnPreReporteWeeTeeUeZeeeWeeTeeUeZeeeWeeTeeUeZeeEe$e eee{eoeOnPostReporteeWeeZeeEe4eeeeee{eoeOnAfterGetRecordeeTeeVeƒeeVereƒeeUeZeeEe\e ee ÿÿÿÿeeeee -Daee{e ,oeOnAfterGetRecordeƒeeTeƒeeUeZeeeTeeVeƒeeVePeDaUeZeeGe<gÄ#¨ c˜A _UtilsFeJeÿÿEeXee-—eÿÿ ee-Script Filenameee?ee{eoeOnAssistEditeere?ereeÿÿWeeTePeScript FilenameVereeUeZeeH þÿÿÿüÿÿüÿÿ0øÿÿ /øÿÿÿÿÿÿc˜A‘c˜A’c˜A“c˜A Report User User, Body (1) Windows Login Windows Login, Body (1) Form ScriptName  DatabaseName h\d| Xdd  YRƒkÒÒÊ×( ÌË×$ d   e–õÀU­ ªDUMToq¤y+î –ëÖU6´k—­¶Ý¯šà7yǝēqÝ :j9˜ Ë4nM@¢p‘Ž%âKͱ†ñ»ÿ)&r;-¼3ŽP7%«vá‡~åÚ8um¦æ‡Õªy‰ûlB“`à|¤:dT¨Nh‹Ñ—Ž"‘2e4ÊIâ*T_U߿ùÔ¶‡—¢1ÝâümÀü/¡å4ç»}g3NLŸž"t0$¼äâÁ|ÙÚüxžw¾NÕiæZ܍3t2ì½½³„œÿ¶.qbÛíJܚØÓÎçc®ëîcïH-<ËT‡c¿ìLÚÆàˆYxÒn¹Ç¨Ri°ÎlÇ`ľj+qüµç:æB{¶¶íIã¼Æ~¹‘òmX2,«2XiœeÞŒò…_åV%IÜszñsŒÍ6?­~ÙDvËôþ³ Ýê·6áL§KDà‰ÌØͨ¬Ã6MÈ7B:L·_áÀªá•&s[­(Ø,=‘¦DÃñJ%—½å¯èÏo‡ÿ3þˆLªÒÂbVd'ý8{è;ÌûL(<£?b 7E,¹©ˆˆ½­n{=§Nž 6¸¼ÏïnМЁÒð!™ŠRL/:èA'{uI ÎNî÷K¯7žÓo"õs`z o0bî :¯Z;Фšä‚'ßâº$È `[0„IÊÕ@¾XŸK½­6yÆèw €çÊ3 ümÚfÒÅk§³¹íƒ‰$%8@–E¾¨¨Ä~ôH°™ôŽ$„­Éx¯½ïÂô&€B˜”Û¿-ìSˆçŒþNŽL¾y9C‚b<a‚11–…ä2Fe9d:Jµoó8ËW#q¾“ã×؍Ìkë©Ý³—ª`RLøzSLi¶P}ü¾|Jìd.51¨ÆCŽé_ˆ<ì xõv8“Œ wç”þB'Dµgr»¦yÞhHàsù(Pc¾°Õ·<ÍËÍ­ãR5Â/‚Ó|Žþy×[Ç¢M]9>ÕÊé')N;9ÞAõå̝úNý¯³Î=ñ …2’û‚î`ÈßÖûØæX³+éì‚cIò¦÷Nö v]ÙI´u‰Ê>uCâ8mÎ1æ<ò˜òÛv BlÇt»Cr Òt«ŠF“-Äړ®©Š^L¥àw«oçc$jê6þ6èï ½IX{"å·Mî OgT˜ƒà³´cïðxHSàF‰$Ɋ%„ÎÜpf¤—¯>g þV7lŠ®Å NgŽÔ Çiv7«-’S+ê½®¹‚á59||õ#µ0×R.lOQÁ¦–óÉs ­LÏ٘’B86š&¦ È¶ŸÚí“?q £ƒ„uèSRj¸A8~¾¿ež N1xèÑ:ýÐ|j.…bÕ Ï­û6s˜ìHÝìS®-`IÛ)d³~‘ðEˆiڌ˜ã±±BAMO”SWÃƯoùžW~ାçKwöüðEñހf¦[MŽ[<¸D/oN t½¸“ªCXZQ$ʨÙS$”Ⱦð?$è¥ìƒ—æ/ÇâÓx¡N<Š©dែ¬R1ÍìE~Ó㦚?âA,‘µc´3kpÑÀoÅ ÇUµPŽT%iXçé¡)’©:3G²ê…±AT¼¿ÚÕ(OT|Л6pSw]òšº3t hZeUVœ\-ðcRŠïP;"4°üÙÓfœ×˽sñ!Ê¢9ï¿éEÖ1ãEùäšIýMyrY‚›àSðå±J½Ìh#{å;ÅÜ|YŠÁÕy†´h)7/ñ<ÿ‡aï›BÎ=—¸Íg9vª†¤ÈmœÊÏÅh¨Fò±ÅýøpÍu~\8å>^éÛèk³Ôó"`"¹=Ú3¯_Çî´d]%/§˜J¦w“›ƒÊ5Øì=¼šÛ·Zëliw®6O—_1 ¯¥áҜTb]"̱5J¾ÙÞCG\kQ’¨‘C‹¸ÃWpœÛËóSgYr‡sb‡†‡•Ù³ôvlùŒõªŽs^Õk—n‹×nÒ}‚U·ghˆÇ–J¯Ӑ8ô%}Ûî·m²A$žii 6•×uÇٟ¡7ýh½ ‘mŠLù˜5Kvm]EµÀ.U?Õ3³¢ÿT-ÉàÄQ«‘ýK„åý¢äÒÿö8þWåŽövkXþ±Å!êŽ1kÓÚKH—{­ØÊ;nä××Ø¡Až|W™’à±$Ó¶Ý+­ó4ÈÝþÝk,íÜ ½Òi¯9:k¥Éy•]‰VŸ]äs8Ov€ôTn­.õ{·ªR»K¹JãzòËÕû«Ò±³Þ¥²=Ñ"ðÜM÷‘‡;›åÔ@|ì`sÂHemë•[ê¥FŽ—îd¼ªFI¨þ¦d°*}ÖéýÛÍûV«[¥vµ›öj՛¦Õšõ©ýårü-ƒDˆJÔ¼’)èéH”rItx†ªÈ·í7N:sÃx®ºƒîœÏ† V̤Ø}ZYôUôd¡A™@ŽWq=«3ûh—øѾ ÁèF²#?MÁ)Wº8@óLûv)w+·ô ùŒú&v3GÒÃÿþ~?ÂáyÓ9+əÉ*Ùè†åÚîZ³ÜšíR×áÂVsÇÌÂó#ü7N³Óü©“ –çŸÑ¤»¸lñþÚ‘Ïqç"ÙQøIïô'2Aă¤0çwn™çIf G a Ž–$‰ÜN$ F  N;qÃB½yó8WæÃï`À˜„áy Gæ/Pg$~M’,2®ûFuVdIâ n@UbaÌ •°Æ÷˜ÙQøÏ).˜¶ñÁי¬£Œwôµã!?Ù¯ä/ó6 ˜½{7æaO™ÇåZV°*‡V`¥|rfÙB\µÿ%£ÏÒ¸FöT&Äö©¢²1+T¡D™<灹†œc‹:Ʀӈeˆ„A«¥>KBŽUxw¾Wâ …¾ jQXÖ8A¥‡²FYþ%Ðî¶ÞÓo"õucóýÞ‡rœó„@ñ~î>8†Ø{±h¸µ õL|\»¬pÀñ %ƒAë*#ÈâªæÅ@ʑë¦àÿ aIŽ>à ЁÒð#%!ºÏ½ κKÉ ÞÝRS,ý_µ©¦Jqñð*b}ýlë^E"dí‰È0”áhí/nÕ«8%R°È¬jzk•á3ˆ8ÀhÑ“Ø ,|ñBX1µs’³¹í@ªYœtfTjµ™8ÖéjDöÌ+gëIµÖ 0¥hKÅ}ïxŠ)rV_+EÊòÔj_\1 ύÁ1.i|øaïèr±½÷Bùb!ƒ¬;êƒÞB7’´1Õӗ•¨ñ².G§øÄìVØ¢J†+†ˆî~(N@¤ŒlPU+$1iÝ.ãáßx7¨*p9yÒ3îkìw1¤<ŸõÐ^Qª"Ø_ Â¥Ÿ~W\4ç9çÕbƒ m.‹,M œCÈ~a‘Qæ‘Î\l*Ç[ó¥% R¿}þr­Éʪ¥¬¾­IŠ´¤%ÔqDfߑ§ês4ýOðÓú+­êk¥ïØØwø¤g‡*8ôe éD“*¯Pþ°