Cant see database in SSE after importing with SSMA[solved]
-
I'm trying to import an Access 2007 db using the SQl Sever Migration Assistant into a SQL Sever 2008 Express database. All the steps work fine in the migration assistant, and in the pane on the lower left I can even see the db in the target server, but when I open the SQL Sever Express db with SQL Sever Management Studio, the db is not there? I can browse the following folder from windows and I can see the MDF file, but if I try to attach the db, I can browse as far as the DATA folder, but I cant open it to select the actual db. C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\simmstock.mdf Also if I try to move the mdf file, Windows wont allow it because it is being used by SQL Server??? Solved: I had another instance of SQL server installed on the machine that I was not even aware of :) (probably from a Visual Studio Installation) and I had migrated the Access database to the wrong server instance