Category Archives: Uncategorized
cmd command: C:\Users\user_name>wmic bios get serialnumber
Error: User ‘DOMAIN/Login_name’ does not have required Permissions. Verify that sufficient permissions have been granted and windows account control (UAC) restrictions have been addressed.
Problem Description: User is suddenly unable to access the SSRS Report Link or URL. User gets below error as shown in screen shot. Error: User ‘DOMAIN/Login_name’ does not have required Permissions. Verify that sufficient permissions have been granted and windows … Continue reading
methods to grant access on SSIS ——————————- https://www.mssqltips.com/sqlservertip/3086/how-to-resolve-ssis-access-denied-error-in-sql-server-management-studio/ https://sysbadmin.wordpress.com/2012/09/04/how-to-grant-access-permission-for-ssis/ http://mssqltrek.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/ https://msdn.microsoft.com/en-us/library/hh213130.aspx below roles need to be granted to user depending on type of access -db_ssisadmin – db_ssisltduser -db_ssisoperator
–Memory metrics to check Pages/sec, Page Faults/sec, Pages Input/sec, Pages Output/sec, Page Reads/sec, Page Writes/sec, Available Memory, Non-pageable memory pool bytes, Pageable memory pool bytes, and Committed Bytes pages/sec (in perfmon) ——————————- ref : http://www.sqlshack.com/sql-server-memory-performance-metrics-part-1-memory- pagessec-memory-page-faultssec/ – it is rate at … Continue reading
T-SQL to check what access user has on db & its objects ————————————————————————- http://www.pythian.com/blog/httpconsultingblogs-emc-comjamiethomsonarchive20070209sql-server-2005_3a00_-view-all-permissions-_2800_2_2900_-aspx/
when there is a need to drop the default constraint on a column in MSSQL code, please check whether you have created a name for Default constraint. please not that i had not created a name for default constraint, instead … Continue reading
use below command in CMD prompt to get the list of MSSQL instances in server. Servers: test_User1 test_User1\MSSQLSERVER1 Note – ‘L’ is capital letter in above Command.
— to start/stop service using SSMS –See below example to check non-SQL Service excellent article by author here!! http://www.mssqltips.com/sqlservertip/2036/monitor-start-and-stop-sql-server-services-using-xpservicecontrol/