CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2021
    Posts
    1

    Unhappy Error updating an ADO MODEL from a remote server

    Hello

    I am trying to update an Ado Model with the changes I made to the view of a sql server database. The method to update is the Database-First. The issue is that when I want to connect remotely to update the model with the database changes it does not connect me and I get an error message. Below I show the message:

    Name:  iK8lY.jpg
Views: 376
Size:  31.0 KB

    You can see on the server that the box allows remote connection to the server is activated:

    Name:  V69df.jpg
Views: 559
Size:  24.7 KB

    I also show the Sql Server Configuration manager with the name of the instance and the TCP / IP protocol enabled:

    Name:  I9m8N.jpg
Views: 341
Size:  21.8 KB
    Name:  9V7GQ.jpg
Views: 406
Size:  14.5 KB

    If you can help me to connect remotely and update the AdoModelGP.edmx Model with the changes I made in the database. Thanks in advance as always.

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,395

    Re: Error updating an ADO MODEL from a remote server

    The resolution of the images you have attached is very poor, so it is impossible to read/understand what is shown there.
    So, please, make the screenshots not from the whole screen but rather from the window that makes sense. Also post the text of error message, not the screenshot of it!
    Victor Nijegorodov

  3. #3
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Error updating an ADO MODEL from a remote server

    Try connecting to the database from your local machine using SQL Server Management Studio. Once you can connect with SSMS then try again with the database wizard using the same credentials as SSMS.

    Btw, you need to enable remote acess and named pipes to connect with SSMS. I believe the db wizard requires named pipes as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured