-
May 26th, 2021, 11:34 AM
#1
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:
You can see on the server that the box allows remote connection to the server is activated:
I also show the Sql Server Configuration manager with the name of the instance and the TCP / IP protocol enabled:
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.
-
May 27th, 2021, 01:14 AM
#2
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
-
May 27th, 2021, 08:43 PM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|