When you create a database on the server (using SQL Server Management Studio), you don't have to (and should not!) fiddle around with the database file(s) anymore - let the server handle that for you. How can I get a copy of my database file with all the permissions I need to use it in visual Studio? When I created my database I right-clicked on databases in SQL Server Management Studio and said new database, then I added columns with a query. I really need to move forward from this problem. if that's the case please tel me how to make a backup and so on. I think my problem is i saved my database wrong, I need to make a back up or something like that. You don not have permission to open this file.Ĭontact file owner or an administrator to obtain permission. So I select Attach Database File and click browse and follow local C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA In the Connect to section at the bottom, the dropdown displays: Master, Model, msdb and tempdb and does not display my emailDatabase. Under server name I use the dropdown box and select DEV-5\SQLEXPRESS. In Visual Studio, I use the Server Explorer, click the add new connection button. I have created a database emailDatabase, its stored in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
0 kommentar(er)
