Skip to main content

Posts

Showing posts with the label dba

Dedicated admin account in SQL

Dac means dedicared admin account, which is used to access sql server at .by default 1433 is sql server port , 1434 ia dac account. Starting the server in single user mode will use DAC (Dedicated Administrative Connection) connection. DAC Connection will use If the number of connections are limited for the instance and all are connected and if some one wants to connect and fails to troubleshoot if DBA want to connect he will also be restricted then he can use DAC connection to connect to the instance. When ever the SQL Server standard connection not establish the connection then we go with DAC connection . only sys admin can use this DAC to connect the server and troubleshoot the problems.

Popular SQL subjects topics,keywords

sql aptitude questions and answers sqlauthority sql aggregat functions sql basic sql books sql commands sql cursor sql certification sql developer sql download sql dba sql express 2008 r2 sql examples sql formatter sql functions sql full form sql fiddle sql group by having sql get date sql guide sql helper class sql history sql interview questions and answers sql injection sql join sql keys sql keywords sql kill porcess sql knowledge sql loader sql like sql language sql managment stuido 2008,2012 sql means sql notes sql not in sql netowrk interfaces error 26 sql notes pdf sql online test sql order by sql operators sql plus download sql pdf sql profiler sql queries pdf,examples sql rowcount sql replace sql reporting services sql rank sql server 2008 sql tutorial pdf sql update sql union query sql unique sql version sql views sql vulnerable sites sql vs mysql sql w3schools sql wiki sql where sql workbench sql xml path,query,x