Add a table in .dbml file in Visual Studio 2017

The name of the picture


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.





Windows authentication or user/password?
– schlonzo
Apr 24 at 14:08





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.

Popular posts from this blog

Arduino Mega cannot recieve any sketches, stk500_recv() programmer is not responding

Visual Studio Code: How to configure includePath for better IntelliSense results

C++ virtual function: Base class function is called instead of derived