0

I have installed two SQL Server instances, one is SQL Server 2012 and the other is SQL Server 2014.

I connected to the SQL Server 2014 instance using Management Studio and clicked "Attach", while clicking add "Locate Database Files" window is opened and I am not able to see the SQL Server 2012 instance databases.

Is it possible to attach other instance's databases without moving databases to another location?

Improve this question

2 Answers 2

Reset to default
1

Is the database you are trying to attach still being used by the 2012 instance? A database cannot be attached to two instances simultaneously. As long as SQL Server can see a drive (or a share) it can attach a database to it (as long as the database being attached is the same or lower version.)

Improve this answer
Sign up to request clarification or add additional context in comments.

6 Comments

Ya I detached 2012 database after that also i cannot attach.The 2012 instance of "DATA" folder cannot expanded in management studio .
It sounds like the user you are running under in 2014 does not have the necessary permissions on the 2012 data folder.
Ya that's correct.There is any way to grant permission to 2012 data folder?.
Not from within SQL Server. You, or the owner of the folder, at the file system level (Windows/DOS/Windows Explorer...) has to grant read/write permission on the folder ,or files (mdf/ndf/ldf), to the SQL Server 2014 ( target) sysadmin user.
ya ok.Thank you .I will check with that.
|
0

Have you tried to add a Linked Server?
See e.g. https://msdn.microsoft.com/en-us/library/ff772782.aspx

Improve this answer

1 Comment

ya i tried linked server .But after that also the databases are not listed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.