The Young DBA

I n SQL Server, much like other services with users, login accounts can be enabled or disabled. An enabled login can be authenticated and allowed access to database resources. A disabled login is not allowed to establish a connection to the SQL Server instance. For example, let's create a login called  sumank . CREATE LOGIN sumank WITH PASSWORD = 'ipl5@2012' ,DEFAULT_DATABASE = AdventureWorks USE AdventureWorks; CREATE USER sumank In the first statement, the sumank login was created with a fairly complex password and a default database of AdventureWorks. Afterward, we switch to the AdventureWorks database and create a new user for the database. If we attempt to login to SQL Server using these credentials, we can. Next let's disable the login with the following statement. ALTER LOGIN sumank DISABLE If someone attempts to login to SQL Server using the  sumank    login, the connection attempt is rejected and Error 18470 is returned - &q

SQL Server Versions and Code Names :- Version Year Release Name Codename 1.0 ( OS/2 ) 1989 SQL Server 1.0 (16bit) - 1.1 ( OS/2 ) 1991 SQL Server 1.1 (16bit) - 4.21 ( WinNT ) 1993 SQL Server 4.21 SQLNT 6.0 1995 SQL Server 6.0 SQL95 6.5 1996 SQL Server 6.5 Hydra 7.0 1998 SQL Server 7.0 Sphinx - 1999 SQL Server 7.0 OLAP  Tools Plato 8.0 2000 SQL Server 2000 Shiloh 8.0 2003 SQL Server 2000 64-bit Edition Liberty 9.0 2005 SQL Server 2005 Yukon 10.0 2008 SQL Server 2008 Katmai 10.25 2010 SQL Azure DB CloudDB 10.5 2010 SQL Server 2008 R2 Kilimanjaro (aka KJ) 11.0 2012 SQL Server 2012 Denali Version with Service Packs... SQL Server 2012 11.0.2316 SQL Server 2012 CU1 12 Apr 2012 11.0.2100.6 SQL Server 2012 RTM 7 Mar 2012 SQL Server 2008 R2 10.50.2811 SQL Server 2008 R2 SP1 CU6 16 Apr 2012 10.50.2806 SQL Server 2008 R2 SP1 CU5 22 Feb 2012 10.50.2796 SQL Server 2008 R2 SP1 CU4 9 Jan 2012 10.50.2789.0 SQL Server 2008 R2 SP1 CU3 17 Oct 2011 10.50.2772.0 SQL

Dear Friends ,  This is my all time confusion about Built In account of Sql Server Instance. Today i deeply examine about these.. So i would like to share.. When we right click on any instance of SQL Server from configuration manager, we will get below window... Local System : Completely trusted account, like the administrator account. There is nothing on a single box that this account cannot do and it has the right to access the network as the machine (this requires Active Directory and granting the machine account permissions to perform something) Network Service : Limited service account that is meant to run standard least-privileged services. This account is far more limited than Local System (or even Administrator) but still has the right to access the network as the machine Local Service : A limited service account that is very similar to Network Service and meant to run standard least-privileged services. However unlike Network Service it has no ability to ac

Windows Perfmon,Task Manager, Resource Monitor, Event-Viewer SSMS DMV, Activity-Monitor, Profiler, Audits, Standard-Reports 3rd Party AdeptSQL SQL Diagnostic Manager SQLBackupAndFTP SyncBackPro SMSgee Toad Data Modeler 4.1 Microsoft Visio MySQL Tool Workbench MySQL Backup FTP Old Tools Edit Plus Dreamever Smsgee SyncBack Pro Jmail Process Explorer v16.02 SQL and Query Load Tester SQLQueryStress Statistics io parser. IIS Logs Monitoring Http Watch Basics Log Parser Log Parser Lizard GUI - FREE Query Software Mobile View Simulator MongoDB GUI Tools Robomongo Mongo VUE Rockmongo online mongostat, mongotop Jason Tools Jasonformatter Jason Editor Online More ......