0

I just created my Microsoft SQL Server Database on my own laptop and then made a backup file of it.

Then inside my Windows Host (Which I've bought from 1and1) I uploaded the .back file and then imported it to the newly made database.

Up to here everything was good. But when I try to connect to my database from my Visual Studio's ADO.NET Entity Data Model Wizard's Connection Settings window I get the following error:

The error message

I searched a lot online but unfortunately all solutions were for Windows Server or Local Computers While my Database is stored on a Windows host.

My connection settings can be seen in the image below:

Connection Settings

I also called 1and1 support to ask whether my database's remote port is open or not, but the client couldn't get what I mean.

Community
  • 1
  • 1
parisa
  • 91
  • 1
  • 13
  • try using the IP address and not the DNS name. – mvisser Aug 28 '18 at 08:43
  • First check your instance name you entered correctly or not? If yes, Open SQL Server Configuration Manager, choose protocols on the left and make sure that TCP/IP protocol is enabled (on the right). If you have a named instance (other than MSSQLSERVER and SQLEXPRESS) then double check that SQL Browser service is running as well. – CR241 Aug 28 '18 at 19:43

0 Answers0