Home » DAC
Category Archives: DAC
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition !
Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15 sold-out performances for that many people to see it.
Microsoft SQL Server License Helpline
Microsoft SQL Server license has lots of flavors in terms of user based \ CAL or processor based license, license based on versions or license based on environment (physical or virtual).
Although, Microsoft release license guidelines for each & every SQL server version. But there are more complex scenarios for licensing then we think.
Best person to answer your all queries over licensing is MICROSOFT itself.
You can call Microsoft Licensing at 1-800-426-9400, Monday to Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist.
If you liked this post, do like on Facebook at https://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm that SQL Server really Reserve 1 user connection for DAC (Dedicated Administrator Connection).
So I decide to show a demo for the same. I have changed the no. of User Connections to 1 & then try to login. So below is the PROOF.
Steps Performed for Demo
1. User Connections Current settings
2. User Connections New settings. You need to restart SQL Services after this.
3. I Try to Login to SQL Server by SSMS & got Error. But Why ?
4. I Try to Login to SQL Server by SQLCMD & got Error. But Why ?
5. Reason of getting error at step 3 & 4 is DAC (Dedicated Administrator Connection). SQL Server reserve one user connection for DAC.
6. Rollback the changes using DAC & come back to previous settings. You need to restart SQL Services after this.
7. User Connections After Rollback
If you liked this post, do like on Facebook at https://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)