Posts

Showing posts with the label dbml

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. 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...