Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

"Sql server error 5120" while attaching database Expand / Collapse
Author
Message
Posted Saturday, July 21, 2012 6:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 21, 2012 6:57 PM
Points: 1, Visits: 9
Moving the mdf/ldf files worked for me (Nutshell.mdf for LinqPad examples).

C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA

Note I do have a MSSQL11.SQLEXPRESS folder but no MSSQL\DATA in it.

Gary Davis
Post #1333418
Posted Monday, May 06, 2013 8:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:01 AM
Points: 1, Visits: 0
It worked out for me when i logged in using Windows Authentication, too

With that Administrators run it was not working for me.


Thank you

One more advice > If you can not connect to your database through network - check, that you have IIS installed + enable TCP/IP through "SQL server configuration manager" - SQL server 2005 Network configuration - Protocols for MSSQLSERVER.

Have a nice day
Post #1449730
Posted Wednesday, May 29, 2013 7:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 7:56 AM
Points: 1, Visits: 0
thats true thanks cuz I try anything but dosen't work but ur solution is great !
Post #1457739
Posted Sunday, June 09, 2013 5:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 3:39 PM
Points: 1, Visits: 13
I had this error when trying to attach a db on my SQL Server 2012 instance connected using Windows credentials. What fixed the problem was giving full control of the mdf and ldf files to this user.

Right click the folder containing mdf and ldf files, Go to Properties --> Security tab --> Edit --> Scroll down to the user and select Allow under full control permissions --> Click Apply.
Post #1461362
Posted Tuesday, June 25, 2013 12:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 12:14 AM
Points: 1, Visits: 0
Worked like a charm.

Thanks for the post mate, Had seen lot of websites for the solution and I'm done with quite number of RnD attempts but never thought the solution would be so simple. Will remember you
Post #1466991
Posted Thursday, November 14, 2013 7:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:01 AM
Points: 1, Visits: 0
Thank you Sqlash...
Post #1514262
Posted Sunday, March 16, 2014 5:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 16, 2014 6:01 AM
Points: 1, Visits: 3
Just Go to SQL-Server Configuration
Change SQL Service Browser Service type to Localservice
will be done
Post #1551556
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse