MSSQL Management Studio for SQL 2012 Error

Asked By 10 points N/A Posted on -
qa-featured

Hello Techyv buddies!

I am having some issue regarding Microsoft SQL server. We were notified recently about an error on MS SQL Server Management Studio.

They said that an error will occur when we try to connect to the MSSQL 2012 database externally.

The error seems to talk about permission in doing a certain action. The error is this:

This error is displayed when you right click on the MSSQL 2012 database and selecting its properties.

Can anyone help me figure this one out?

I can’t find any solution to the problem so I am bringing it to the public.

Any help will be much appreciated.

Thank you!

SHARE
Best Answer by Carl Jack
Best Answer
Best Answer
Answered By 10 points N/A #151930

MSSQL Management Studio for SQL 2012 Error

qa-featured

Hello Catherine,

Try the following workarounds:

Solution 1

First, you will need to move the mdf file to a different folder, and make sure that you do not work directly in the root of your disk. What you will need to do is create some folder and after that configure the security in the folder properties. That will enable the server account to be able to use the folder without any problems

After you have done the above, you will need to run SSMS and after that right click the databases, and the use attach database and after that locate the attach dialog to delete the log file entry.

Solution 2

The errors could be as a result of permissions problems.  You will need to make sure that you have got local administrative permissions in order to complete the task. 

Just check and see if you are already a member of the local administrators group, or you can as well log on as the local administrator.

Regards,

Carl

Answered By 5 points N/A #151931

MSSQL Management Studio for SQL 2012 Error

qa-featured

This error usually caused from a design change to SQL Server 2012, There is Hotfix recently released by Microsoft to overcome this problem.

Hotfix is about cumulative update package 2 for Microsoft SQL Server 2012.

 
Note:-
 
Don’t make any changes to the registry during installation of Hotfix cumulative update package.
 
After successful installation restart your system so that changes take effect.

Related Questions