http://sqlserver.ro/forums/22/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/265.aspxFri, 06 Oct 2006 17:16:33 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:265xmldeveloper0http://sqlserver.ro/forums/thread/265.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=265<P>Asa e, doar o DAC este disponibila si este ideal sa nu uitam sa o inchidem <img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" /></P> <P>&nbsp;</P>http://sqlserver.ro/forums/thread/263.aspxFri, 06 Oct 2006 10:44:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:263ggciubuc0http://sqlserver.ro/forums/thread/263.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=263Si cum bine spuneai candva aceasta(DAC) trebuie sa fie inchisa la terminare.http://sqlserver.ro/forums/thread/262.aspxFri, 06 Oct 2006 08:19:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:262xmldeveloper0http://sqlserver.ro/forums/thread/262.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=262<P><SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Arial;mso-fareast-font-family:'Times New Roman';mso-ansi-language:RO;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"><STRONG>Conexiune Dedicata pentru Administrator </STRONG></SPAN></P><SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Arial;mso-fareast-font-family:'Times New Roman';mso-ansi-language:RO;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;">In cazuri deosebite cand accesul la SQL Server nu mai este posibil datorita unor probleme sau unor erori, este disponibila o conexiune pentru membrii rolului <I style="mso-bidi-font-style:normal;"><STRONG>sysadmin</STRONG></I>, prin care se poate face diagnosticare si se pot executa interogari. Aceasta conexiune dedicata administratorului (DAC) se poate face folosind utilitarul din linie de comanda <I style="mso-bidi-font-style:normal;"><STRONG>sqlcmd</STRONG></I> in doua modalitati - cu parametrul de administrator <I style="mso-bidi-font-style:normal;"><STRONG>–A</STRONG></I>, sau folosind numele instantei si prefixul <I style="mso-bidi-font-style:normal;"><STRONG>admin:</STRONG></I> spre exemplu <I style="mso-bidi-font-style:normal;"><STRONG>sqlcmd –Sadmin:&lt;nume-instanta&gt;</STRONG></I>. Dealtfel se poate folosi pentru aceasta conexiune si SQL Server Management Studio Query Editor deschizand o conexiune la <I style="mso-bidi-font-style:normal;"><STRONG>admin:&lt;nume-instanta&gt;</STRONG></I>.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;">In mod implicit conexiunea se poate face doar de catre un client aflat pe server, dar se poate permite accesul din retea daca se configureaza optiunea <I style="mso-bidi-font-style:normal;"><STRONG>remote admin connections</STRONG> </I>cu procedura stocata <I style="mso-bidi-font-style:normal;"><STRONG>sp_configure</STRONG></I> sau aplicatia <STRONG>Surface Area Configuration</STRONG>. Poate exista numai o singura conexiune DAC. Este recomandata conectarea la baza de date <I style="mso-bidi-font-style:normal;"><STRONG>master</STRONG></I> folosind comanda <I style="mso-bidi-font-style:normal;"><STRONG>sqlcmd –A –d master</STRONG></I>, si nu este posibila executia interogarilor in paralel. Aceasta conexiune nu este disponibila implicit in SQL Server 2005 Express Edition insa poate fi activata prin folosirea unui trace flag.<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><B style="mso-bidi-font-weight:normal;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;"><o:p>&nbsp;</o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><B style="mso-bidi-font-weight:normal;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;">Exemple:<o:p></o:p></SPAN></B></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;">Pentru conectare local folosind portul standard:<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><I style="mso-bidi-font-style:normal;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;"><STRONG>sqlcmd –S 127.0.0.1,1434<o:p></o:p></STRONG></SPAN></I></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;">Pentru conectare prin retea:<o:p></o:p></SPAN></P> <P class=MsoNormal style="MARGIN:0in 0in 0pt;"><I style="mso-bidi-font-style:normal;"><SPAN style="FONT-SIZE:9pt;FONT-FAMILY:Arial;mso-ansi-language:RO;"><STRONG>sqlcmd –S server_name_or_ip –U sa –P password –A<o:p></o:p></STRONG></SPAN></I></P> <P>Detalii suplimentare: <A href="http://sqlserver.ro/forums/thread/91.aspx">http://sqlserver.ro/forums/thread/91.aspx</A></SPAN></P>