Problem: User can not connect to SQL Server from a remote computer via SSMS. Ping returns unreachable. When user remote desktop on to server and use SSMS from the server, the user is able to connect to SQL Server. Note: Make sure SQL Server Instance is running on the server. If multiple instances installed, make... » read more
View SQL Server Logs SSMS -> Server -> Management -> SQL Server Logs Error Logs View the error logs if SQL Server is unable to start. C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\Log Sources: https://docs.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver15
Regression testing is re-running functional and non-functional tests to ensure that previously developed and tested software still performs after a change. REGRESSION TESTING is defined as a type of software testing to confirm that a recent program or code change has not adversely affected existing features. Regression Testing is nothing but a full or partial selection of already executed test cases which are re-executed to... » read more
Displaying the File Extension in Windows Vista and Windows 7 Click the Start menu. … Type “folder options” (without the quotes). … A dialog box with the title “Folder Options” will appear. … Click to uncheck the box for “Hide extensions for known file types”. Click the “OK” button at the bottom of the dialog box.
After you have installed SQL Server Reporting Services 2017, you will need to configure SSRS before you can use it. Go to Reporting Services Configuration Manger to configure SSRS. Reporting Services Configuration Manager Configure the Web Service URL tab and hit Apply to create directory in IIS. Configure the Web Portal URL tab and hit... » read more
Installing Note Requires at least Windows Server 2012 or above. Developer edition has all the features of the Enterprise edition. Standard edition do not have certain features. If you want to install Machine Learning Server, you might have to do an offline install. Otherwise do not select the Machine Learning Server feature from both the... » read more
Sources: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver15
Grant Stored Procedure to Role Grant Function to Role Grant Type to Role Grant Table to Role Grant View to Role
Get Data File Information from Backup File Drop Database Restore Database
This topic is relevant only for backup and restore of SQL Server databases that are using the full or bulk-logged recovery models. A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL... » read more