Is there access restriction to attached database?
Posted on 2014-11-09
I attached to a database that was sent to me in form of mdf and log files. I put these 2 files in the sql 2012 express' data folder. I then was able to attach to the file. It's just odd that the database would show up with name as c:\.....\its-database-name in Sql Management Studio. It doesn't just show the database name.
I am able to open the database tables in Management Studio.
In the Security, my login, User Mapping, I can't give my self any permission except fore "Connect Sql".
where can I enable remote connection? I am not able to use C# code to open this database.