![visual studio server explorer add connection visual studio server explorer add connection](https://i.ytimg.com/vi/V9r-Gp3uNCE/maxresdefault.jpg)
Strangely, I created the file under the same login as I am trying to connect and potentially relocate with. If I right-click the mdf file and select Properties / Security, I am told that I must have read permissions to view the properties of this object. I have tried to move this file over to a local C-drive folder, and this too fails, saying I need permission to perform this action, that I require permission from the computers administrator to make changes to this file. I also have the correct local administration rights on my user account.
#Visual studio server explorer add connection full#
This path has full permissions, as does the PC. As I said, I placed the database file on a network path called \\w2012\Users\Steve A\MSSQL\DATA. SQL Server is installed on the same PC as Visual Studio. The problem is, I am the owner, and everything was created locally on my PC. Contact the owner or an administrator to obtain permission. The error I am continually getting is: You don't have permission to open the file. I have chosen both Windows Authentication and SQL Server Authentication options. Then selecting Microsoft SQL Server Database File / Continue and selecting the actual file via Browse. I am going to Server Explorer and Right-clicking Data Connections / Add Connection. I am trying to add the database (ResourcePlanning.mdf) to Visual Studio. It is located on a network drive so that it is properly backed up, rather than storing on my local hard drive. I have a database that I created in SQL Server, with a few tables. I am using SQL Server Express 2017 with Visual Studio Professional 2017.