MSSQL Management Studio for SQL 2012 Error

Asked By Catherine Brewer 10 points N/A Posted on - 08/15/2012

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!

• Status: Open
• Question Views: 1339
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Carl Jack

Go To Solution

Best Answer

Best Answer

Answered By Carl Jack 10 points N/A #151930

MSSQL Management Studio for SQL 2012 Error

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

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/16/2012
• Question Category: MS SQL Server

Answered By Kumay Edwards 5 points N/A #151931

MSSQL Management Studio for SQL 2012 Error

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.

Hotfix from this link.

 

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.

About Kumay Edwards

Questions
2

Answers
212

Best Answers
57

• Vote Up 0 Vote Down

• Posted on - 08/17/2012
• Question Category: MS SQL Server