If you look at the connection string created by your VS 2011, you should find user instance = true ( default value, you may change it if you click on the button Advanced Properties in the form related to the connection string ). Usually, this kind of problem is treated in the SQL Server Express Forum where i might move your thread, but i prefer to have your agreement ( simple question of politeness ) and you will have the "risk" to find me again on this forum With your Visual Studio, you have created an user instance.It is why you have a database per user ( the data and log files are in the folder Documents of the connected user ).Īre you sure that you need to use the user-instance feature ( specific to the Express edition, not supported by not-free editions )?You will multiply your databases, an user cannot access to the database of another user ( you separate the workĪnd data of the users of the computer but you will have difficulties for backup/restore of your databases,no SQ Server authentification, no remote connection.) . Then itself the message box "the database file e:\Users\xxxxxxxxxx\Documents\srini.mdf" does not exist. Rather when the user changes the drive letter in AttachDbFileName,
My question to the users is that why am i forced to create new folders of type "Users", "xxxxxxxxxx", "Documents" and then only the Add Connection succeeds. Then i get another message box saying "the database file e:\users\xxxxxxx\documents\srini.mdf" does not exist. On the other hand, if i create a folder Users and xxxxxx and Documents and then point to the new path in AttachDbFileName and then click Ok
If I rename C: to another drive letter then I get an error message "attempted to access a path that is not on the disk". In the Add Connection Dialog Box I entered "srini.mdf" in the Edit Box titled Database File Name ( new or existing ) and selected Advanced and the path for AttachDbFileName is initialized to the default path C:\Users\xxxxxxx\Documents\srini.mdf. I tried to create a DB connection, when adding ADO.NET Entity Data Model -> EF Designer from database -> New Connection -> Microsoft SQL Server Database File (the SchoolDB.mdf wasn't attached to SQL Server.In Visual Studio 2011 Developer Preview, in Server Explorer I did right click on Data Connections and selected Add Connection.
#Connection visual studio and sql server on seperate drives password#
The attempt to attach to the database failed with the followingġ) The sa user's password hasn't expired or isn't different than what I have specified.Ģ) The sa user has not been disabled, either by being denied permission to connect to the database engine nor having the login disabled.ģ) My instance of SQL Server 2016 (Developer Edition) is configured for SQL authentication.Ĥ) SQL Server is running and I also can connect to it by SQL Server Management Studio (v17.1) via sa and Windows Authentication as well. Microsoft Visual Studio (2017) pops up this error when I try to create a DB connection for my Entity Data Model I know there are similar questions, but I have a specific problem.
0 kommentar(er)
