Error: At the time of installing SQL Server 2008 or SQL Server 2012 with Reporting Service

Error message is:
Rule “Reporting Services Catalog Database File Existence” failed. The Reporting Services catalog database file exists. Select a Reporting Services files-only mode installation.

Solution: 

This issue occurs because the databases for the SQL Server 2008 Reporting Services instance that you want to install already exist on the computer.
To resolve this issue, move, rename, or delete the existing Report Server databases. Or, use a different instance name here %ProgramFiles%\Microsoft SQL Server\MSSQL10.Instance Name\MSSQL\DATA

Read Full Post »

Error: In SQL Server – access database under the current security context.

Error message is:
The server principal “<username>” is not able to access the database “<database>” under the current security context.
Solution:
That error can happen due to attach a copied database from a different source.  When we attach a copy of database it will have the user account attached from is previous server and created server. If these two SID does not match the error will occur.

Read Full Post »

Error: At the time of installing SQL Server 2008 R2 in Windows Server 2008

The error is:

Rule “Windows Firewall” generated a warning. The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature.

Solution:

Turn off firewall or allow ports rules. Follow the link to setup MSSQL 2008 Firewall Rules. (http://www.coverboy.co.kr/plugin/print/?id=263)

Read Full Post »

Windows 8 installation problem – black screen in dell inspiron N5110

I was having trouble to install windows 8 in my dell inspiron n5110.

At the end of the installation is tries to boot up and display black screen.

After googling, I understood that the problem is happening due to the graphics card.  Following steps solved the problem:
1. I connected the computer to another monitor, So the black screen is not coming anymore in the extended monitor.

2. Then update the BIOS, I restart the computer 2-3 times and fixed the problem.
Hope that will help you too.

Read Full Post »