Object reference not set to an instance of an object. (SqlPackageBase)
All required parameters are set. We were able to access the server without any issues. But, suddenly we got the error while we all are working over the network on the server. the Error is -
Solutions: When finding the error and looking unhealthy network component then we found that, the storage 2 drives are going to bad and that we need to replace it. RAID rebuild is the process of reconstructing RAID array in the event that a hard disk drive dies. RAID rebuild puts every data into its proper order keeping a copy of the data in the event that a hard drive mechanical failure happens. Once RAID rebuild takes place, data is reformatted with parity data & RAID algorithm. The intelligence of RAID algorithms and parity data comes into place when an unexpected hard drive failure has occurred.
After started storage normally, we have restarted the SQL server then it’s working without any error. restart domain controller also. Might be this also creates an issue because sometimes error would occur if accessing SQL by domain user account.
This is one which I have face the scenario but this is what I face the problem and resolved it.
I am sharing with you because what possibilities can be done if this problem occurs?
- The few more things are possibilities of taking care -
1. Make sure the required SQL services are running properly. keep it on automatic mode (SQL instance, agent, etc).
2. Try to open SSMS as an administrator.
3. Repair the SQL Server if necessary. [Go to Add/Remove Programs Microsoft SQL Server 2012 (x64) -> Uninstall/Change ->Repair . Select the SQL instance that you want to repair]
I think this is good to read all.
Enjoy!
“Progress can change a life. Be happy and enjoy life.”