I am creating a database from within my application using this sqlconnection:
SqlConnection("Server=.\SQLEXPRESS; user id= 'AucMaster'; password='auctionit';User Instance=False")
and this string:
str = "CREATE DATABASE [" & NewAuctionName & "] ON PRIMARY (NAME = [" & NewAuctionName & "], " & _
" FILENAME = 'C:\AuctionITData\Auctions\" & NewAuctionName & ".mdf') "
This appears to create the database successfully and from within SSMS I can view the tables etc. However when I try to select this file from within the application using Windows .Form.OpenFileDialog it tells me: "You do not have permission to
open this file" Can you tell me what I am doing wrong, as it appears that Windows has restricted the access when it was created. Do I have to provide Windows security from within vb.net and sql when I create it ...
Go to the complete details ...