Add a table in .dbml file in Visual Studio 2017
Add a table in .dbml file in Visual Studio 2017
Adding a table in the .dbml file by drag and drop in Visual Studio 2017 community edition generates this error.
Failed to retrieve data for this request.
Failed to connect to server 10.1.2.3.
Login failed for user 'user'.
I am able to log in and view the tables and views in the SQL Server Object Explorer.
NB: It was working on VS 2015 before updating. Adding SP still works.
user/password. When I use Windows authentication, it's working, but I need to use user/password.
– FLash
Apr 25 at 5:18
Then it must be something with the authentication. Have you double checked, if the connectionstring in dbml designer file is correct and if the user (still) has rights to access the database?
– schlonzo
Apr 25 at 5:25
Able to login in SQL Server Management Studio with the same credentials. Even able to view tables in VS SQL Server Object Explorer.
– FLash
Apr 25 at 5:31
Uhm, that's really kind of weird then? Is your application working? Is it just a problem with adding a new table to dbml file?
– schlonzo
Apr 25 at 5:44
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Windows authentication or user/password?
– schlonzo
Apr 24 at 14:08