Unable to connect sql server remotely

Unable to connect sql server remotely. And restart the sql service, then try SSMS to connect the sql service by private ip address. From there I used the named ODBC connection in access to link the tables I needed. The name of the SQL Server looks like this when i access it locally on the VM. somedomain. Try pinging the SQL Server IP address from the Aug 24, 2015 · 5. The login failed. sql server auth on. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine. If it on the other hand is a named instance, you login with localhost\<INSTANCE_NAME>, instance name normally being SQLEXPRESS. 89. Sep 1, 2016 · How to connect to a MSSQL database on a remote (windows) server from python? Hot Network Questions Does using electricity from the grid in the U. 123. It has 2016 SQL Server installed as MSSQLSERVER (default instance). Open Port in Windows Firewall 1433. cpl, and select the Remote tab. Toubleshooting: Solving Connectivity errors to SQL Server. Verify that the SQL Azure firewall is configured to allow remote connections from the IP address (es) that you will be connecting from: When a computer attempts to connect to Sep 19, 2019 · Option 1: Select Start > Run, type sysdm. Option 2: Select Start > Run, type regedit, navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > Terminal Server, and set the value for the key fDenyTSConnections to 0 (0 = Enable; 1 = Disable). exe, and then click Open. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "databasename" requested by the login. If you open SQL Server Configuration Manager and browse to SQL Server Network Configuration > Protocols for <NAMED INSTANCE> you will see three protocols enabled. For more information see SQL Server Books Online. 1 is an internal address. From the MySQL virtual server open a command prompt and type netstat –ano, this will show you a list of processes and what IP's / ports they are listening on. TIP: You can edit this rule to add specific Apr 30, 2024 · Test the connectivity between the application server and the Azure SQL Database by using SQL Server Management Studio (SSMS), a UDL file, ping, or telnet. We can connect to SQL Server remotely over the internet if the Server has a static public IP address and port forwarding is configured on the router to allow remote connection requests through the router firewall. 122. Check and make sure the SQL Server drivers on the machines that don't work are up to date. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Jul 13, 2012 · 6. Ideally I will run MS Access as clients into Nov 29, 2012 · I reset my SQL Server 2008 R2 sa password: sp_password @new = 'joomlacmssenha', @loginame = 'sa' But when I try to access using SQL Server Authentication with these credentials, I get the following Jul 18, 2021 · remote connection on. 2) Click on Protocols for SQLEXPRESS from left hand side pane, from right hand side pane, double click on TCP/IP . ), SqlErrorNumber=11001,Class=20,State=0, Jan 5, 2022 · I want to connect to Remote Sql server using powershell with username and prompt for password and when connected i need to to run a query to retrieve data from the sql server and display as output when we run the powershell script. How can I check if a firewall is making me not able to connect on that Aug 2, 2015 · This line should connect us to the default instance of remote SQL Server: osql -S ServerIP -d MyDatabase /U sa -P MyPassword. I'm trying to connect to it through SQL Server Management Studio setup on another computer on my home network. 91 1 5. Make sure TCP/IP is enabled. com Check if your server allows connections via "Allow remote connections to this server" in the database properties page -> Connections. I have installed SQL Server 2014 Express on Windows 10. 1 with SQL Server 2022, I am not able to remotely connect via SSMS to a networked computer. Let's call it computer B. answered Jul 18, 2013 at 9:58. In the router firewall settings, there is normally a games and application section, in there add SQL application and give the Oct 22, 2022 · Please refer to MS document Lesson 1: Connecting to the Database Engine to get detail steps. 1. Inside I open SQL Server Management Studio 18 and connect to the server using Windows Authentication. To verify network connectivity, run the command below from a command-prompt on the remote machine, replacing "127. This resolution. 148 listed in that box as listening on 1433 - either that or the Sep 11, 2019 · Ensure TCP/IP Protocol is enable. Have a cup of coffee. The first time you run SSMS, the Connect to Server window opens. The router has set as below: Archer C2>forwarding>Virtual Server: Service Port=1433,1434,49172. Enable TCP/IP. If multiple SQL Server instances in your environment are impacted, or the issue is intermittent, it usually indicates Windows policy or networking issues. Connect('your-database-server', 1433)) 'success' Verified user created is able to access the desired databases by logging in locally with Sql Server Management Studio. If I understand correctly, you are running a SQL Server instance on your local home network and you cannot connect remotely from the internet. If you create alias with MachineName\InstanceAliasName you can connect by MachineName\InstanceAliasName. Sqlcmd: Error: Microsoft SQL Server Native Client 10. Mar 30, 2012 · Restart the server SQL Config Manager --> SQL Server Services --> SQL Server (SQLEXPRESS) --> Right-click --> Restart Use proper server and instance names (both are needed!) Typically this would be . Oct 25, 2010 · Server is not found or not accessible. need to use the SQL Browser service, also open port 1434. I have installed a Windows Server 2022 with SQL Server 2019 on it. firewall on. Tick "Allow remote connections to this server". Under IP All set the TCP Port to 1433 if it hasn't been already. I spent half a day troubleshooting but had no luck. localhost\SERVER_NAME or; hostname\SERVER_NAME; From a Jan 28, 2022 · It worked! I noticed in SQL Server Configuration Manager, under SQL Server Network Configuration->Protocols for MSSQLSERVER, that TCP/IP was Disabled. Andrew_F: Your screenshot of the TCP/IP Properties doesn’t show that port 1433 is open on the servers outward facing IP address - 127. I installed SQL Server 2022 and SSMS . Windows firewall. SQL Server Management studio is also setup on my machine. Nov 3, 2017 · SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER > enabled TCP/IP. and it does the trick, however the next one: osql -S ServerIP\MyInstance -d MyDatabase /U sa -P MyPassword. 127. Or if you have installed as a named instance. S. Ip address=192. When I try to connect sql express through public ip, it never connects. SQL Browser Service is only needed if you have more instances on one server. Check IP address under TCP/IP: Make sure that the IP address you are using is enabled. Using SQL Server Configuration Manager I went to SQL Server Browser Properties and changed to Start Mode to Automatic on the Service tab. - In IP Address Tab, Set Port 1433 in the last option (IPAll) Mar 23, 2022 · Step 4 Tools – Login with Azure Data Studio. MSSQLSERVER\MSSQL , there you will find a folder ” Template Data ” , copy the master. Dec 3, 2021 · Step one: confirm the service is running. Use a network load balancer with a DNS alias to repoint. Nov 17, 2019 · Assuming the remote SQL Server is a default instance listening on port 1433, check remote port connectivity from inside the container with powershell -Command echo ((new-object Net. Jan 11, 2024 · Feedback. Make sure you can ping the server from the machine you are trying to connect from to ensure the SQL Server is reachable. It may be that there is a VPN seetup that you can connect through. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) Open up the "SQL Server Configuration Manager" locate: SQL Server Network Configuration - Protocols for SQLEXPRESS (or equivalent) - TCP/IP. Feb 23, 2021 · I am trying to remotely connect to a SQL Server 2019 database running on an Azure VM on Windows Server 2019 with SQL Server Management Studio 18. The SQL Service Browser is probably Disabled. My idea is to setup a new instance for every project I make. make sure you have allow network connection from sql server configuration tool. Best regards, Seeya Jan 25, 2021 · 1. TcpClient). Change the port to 1433 and use only the machine name. Repeat steps 1 through 3 on the other server of the remote server pair. Check for an alias on the machine that can't connect. Check if instance name is correct and i f SQL Server is configured to allow remote connections. tcp ip on3. Connect to your server instance. xxx\SQLSERVER I get an error: The server was not found or was not accessible. (period) LAPTOP-JDRDGF9T (the name of your PC) localhost. Client. Check SQL Server configuration Manager, Enable the tcp/ip protocol. Under IP1 set the TCP Port to 1433 if it hasn't been already. Under the SQL Server 2005 Network Configuration, you will see 4 protocols. This is under Properties for TCP/IP settings. If I connec May 5, 2023 · By default SQLExpress 2022 has TCP and Named Pipes disabled as protocols for the instance. Most likely it's not set to Auto Start. Feb 20, 2022 · I'm trying to setup a new dev environment. \SQLEXPRESS , for example see the screenshot from QueryExpress connection dialog. Then go to the TCP/IP protocols in SQL SERVER CONFIGURATION MANAGER and enable the IP ADDRESS. You can only omit the instance-name for default instances. http site in the same sql server machine is reachable. Allow remote connections to this server. Check firewall settings: It might be possible that server that hosts SQL Server has firewall Aug 30, 2015 · Most probably, your MS SQL server is not configured for Remote Access. FFirst launch Azure Data Studio. Run the SQL Server Configuration Manager. I setup and installed SQL Server 2019 on one of my computers on my home network. I have a local version of the remote database with the same users. Jun 3, 2016 · Apply the changes and exit. When I try to connect to the server using public ipadress . When I checked 1435 is open or not, it is closed. <instance_name>\MSSQL\Binn, select sqlservr. Aug 20, 2012 · A client of mine gave me a server name which is fully qualified [servername]. In the Connect to Server dialog box, confirm Database Engine in the Server type box. Aug 2, 2021 · SQL Server Configuration Manager - SQL Server (mssqlserver), SQL Server Browser, SQL Server Agent are running Allow remote connections to this server is checked How I try to connect to the instance: Aug 15, 2019 · Make sure TCP/IP protocol enabled via SQL Server configuration manager. microsoft. Normally the option is already Nov 1, 2017 · All that the network library needs to connect to SQL Server instance is it's IP + port. -- Expand SQL Server Network Configuration. Try following: 1) Open SQL Server Configuration Manager. Configure TCP/IP connection enabled and on IP Address tab specific to Ip Address change to Active -> Yes, Enabled -> Yes. Nov 16, 2022 · 1 answer. Change the Startup type to Automatic (Delayed Start) Click to Start button to start the service. activate sql browser service. I enabled it, restarted the instance, and "'any' <ipv6> 1433" appeared on SQL Server Log. I finally realized that the SQL Server Browser service was not running. After enabling TCP/IP and ensuring that the server was listening on the proper ports, I was stumped. See here and here for some more information. Jul 18, 2021 · remote connection on. in MS SQL, go to Configuration tools -> SQL Server Configuration Manager Select SQL Server Network Configuration -> Select protocol in the right side window enable tcp/ip and restart the services in services. On the Connections page, review the Remote server connections settings, and modify them if necessary. let's confirm that the issue related to the SSMS or to connection in general. 1" with the actual IP public address you are trying to connect to. Now start the MS SQL service and you are done . I renamed the remote server's SQL Server to XXXXAT01 using this procedure: I made remote desktop connection to it. The ports seem to be op…. If you have chosen to install Express Edition as a default instance you can omit the SQLEXPRESS part aswell, so your Server name would look like. ZZZZZ. Dec 14, 2018 · 0. Shared memory is the only one enabled. Dec 19, 2021 · How to configure remote access and connect to a remote SQL Server instance with ApexSQL tools Enable Remote Connections to SQL Server using IP address Tutorial: Getting Started with the Database Engine--which is an official document. On a second computer that contains the SQL Server client tools, log in with an account authorized to connect to SQL Server, and open Management Studio. When changing this configuration, an automatic firewall rule is added for the Azure VM for this SQL Server instance. The server where the SQL Server is hosted is a VPS (Arvixe). C:\Program Files\Microsoft SQL Server\MSSQL10_50. I was able to connect via ODBC. Aug 6, 2019 · I'm trying to connect to a remote instance of SQLServer using a connection string for a Go program that I'm writing. Sep 5, 2018 · The server was not found or was not accessible. You might want to look in it's properties to verify it's listening on correct network interface. (b) try to connect using sqlcmd. PC1 has the latest SQL Server Express 2022. Sep 20, 2016 · On my server I have two SQL Servers, a production server and a testing server. Check for firewall rules. I can connect to server locally by entering: computername\SQLEXPRESS or 192. So I tried, using the username and password the May 9, 2017 · It may be that you cannot access the SQL Server directly at all, in which case you'll need to use tools installed on the VM (s) rather than local copies. xxx. cliconfig, and make sure to enable the TCP/IP protocol if it isn't. xxx\SQLEXPRESS. Check also the port setting. I can connect to a remote sql server at home but not in the office. You have a named instance of SQL Server named SQLEXPRESS (this is shown in parentheses within the SQL Server service name " SQL Server (SQLEXPRESS) " in the Windows Services MMC snap-in. I believe you should see your ?. Inform us i this solve your issue and if not then report the result and if you hav more information May 11, 2023 · I am new to SQL and database and trying to learn. Check if the SQL Browser service is running: Control Panel. Use a SQL Alias on each machine. Click on the IP Addresses tab. result in more greenhouse gas emissions than using propane? Dec 13, 2013 · @Danny The actual server address needs to be set in the port forwarding on the modem/router. tcp ip on2. Services. make sure port is listen as the the service provide. Sep 26, 2019 · If SQL is running and you are not able to connect then first stop SQL Service. Not sure why this happens? I can connect to the sql server from within my asp Had to go in to SQL configuration manager on my server, locate SQL Server Services and then Server Browser within that selection and restart Server Browser (it was already running and set to automatic by the way) and then I was able to refresh in Visual Studio 2017 on my remote workstation (running Windows 7) and it connected to database on server ok. Then go to properties for TCP/IP. . For more information, see Troubleshooting connectivity issues and Diagnostics for connectivity issues. This is a sql server user and not a computer account; I am able to telnet and nc to the port. - Enable TCP/IP. You need to specify the instance-name in the Server name: field. Administrative Tools. Mar 3, 2016 · 1. This will open TCP/IP properties. May 23, 2017 · If the port number is bothering you and the reason why the alias is being made then there are a few things you can do. Mar 23, 2019 · 1) Network issue, 2) SQL Server configuration issue. ping from the internet is successful. If you. Then: Open SQL Server Management Studio on the computer hosting the instance. Add/Check Firewall policy is open for port 1433 (Default) or specific port according to your sql server listner port. If the SQL server is in standard configuration it will be port 1433. applies to SQL Server® versions 2005, 2008, 2008 R2, and 2012. The Sql server configuration manager setting: TCP IP Properties>IP Address> IP1: Active:yes. Open the Run window by pressing the keys Windows + R, type. . You can see that in the Azure VM Networking configuration. Strangely, I was able to remote connect to another network computer, let's call it computer A. Thank you, Gui LeFlea. 137. If yes, then step 2: (a) try to connect using PowerShell using the command Invoke-Sqlcmd. 2. I am sorry if I did not clarify this earlier, but I am attempting to connect through SQL Server Management studio. See full list on learn. You should create Alias just for instance, It means you can connect only by InstanceAliasName, You can not combine again MachineName and AliasName. So you do not have to open dynamic port number at windows firewall. 1. Usually, customers see connectivity issue in their applications, but it would be great if you can follow the steps below to eliminate issues one by one and post a question on SQL Mar 27, 2019 · 31. Make sure that you have enabled TCP/IP for the SQL Server. Aug 18, 2023 · I am trying to set up a test bed in my office with two PCs both running Win 11 Home. Also, ensure the custom port not configured, for detailed info. The default port for SQL Server remote connections is 1433, you usually need to provide this along with the connection string. Make sure that port 1433 is open on your SQL Server. tcp ip on. 4. Verify that you have installed the remote debugger on the remote machine. net to try to connect to their SQL Server instance over VPN. Try connecting with servername:port rather than just servername. Then create an ODBC connection from your local computer. I'm using SQL Server 2008 R2 and Microsoft Excel. 3) Firewall issue, 4) Client driver issue, 5) Application configuration issue. So I do not have a connection string exactly but am using the following: MIDAM\MIDAM,5046. In your information, the port is set to 1433 even though it is a named instance Sep 7, 2015 · 8. Unfortunately I can't proceed because of the information. The MySQL server should be listed here and should be listening on the same port and IP as the config file defines. 123\SQLEXPRESS:12345 Login: sqlUser Password: pass123 I get the following error: Jun 10, 2014 · Once you are sure you have the right FQDN (make sure you can ping it by name, or better yet, telnet to the server name on the SQL Server port (usually 1433)), go to Control Panel > Credential Manager, choose Windows Credentials, and Add a Windows Credential: Then specify the specific server name (potentially you may need server:port notation Feb 15, 2016 · First you should determine the activated protocols (TCP/IP, NetBios) and ports on the remote server with the SQL Configuration Manager / Network Services. Right click on the server and click Properties. Unable to connect to SQL Server remotely. From the client's perspective the server is at the public address, not the private address. (provider: TCP Provider, error: 0 - No such host is known. The connection string tells the SQL client to connect to the modem, which then forwards the connection to the internal server. 12. You can do it via command prompt, services applet or SQL Server Configuration Manager. In the Protocol Tab, set Listen All to Yes Aug 26, 2011 · Click on Protocols for. I have the server set up to be logged in via Windows user or database user I can log into the database fine with the database user I can connect t Nov 25, 2012 · by sql management studio on the sql server, i only can connect by using server name as localhost but failed when use 192. But I'm having trouble Aug 2, 2021 · If you install the sql server 2019 manually in a windows VM in Azure. – Open up the "SQL Server Configuration Manager" locate: SQL Server Network Configuration - Protocols for SQLEXPRESS (or equivalent) - TCP/IP. Jun 10, 2013 · On the Exceptions tab of the Windows Firewall item in Control Panel, click Add a program. Jan 15, 2014 · Check enabled protocols: Go to SQL Server configuration manager and check if both TCP/IP and Shared Memory are enabled. ?. For example: Machine Name: DBSERVER Instance Name: SQL2008R2. i have the query ready but unable to connect to remote server with the entered username and password, any one can Nov 18, 2022 · In Object Explorer, right-click a server, and then click Properties. msc then try to connect to localhost\sqlexpress. Oct 20, 2021 · microsoft-sql-server, question. I have gone through the process of making sure that the Allow remote connection is tick for both servers. The Connect to Server dialog box appears. Feb 29, 2024 · New connections in SQL Server Management Studio 20 and later versions. 100 (Permanent) And I have closed the firewall in windows. Nov 25, 2012 · I got conclusion from that site and i must make sure that: 1. Remote computer RDP settings. 4, so what should i do to connect from remote client? Jan 4, 2016 · The server was not found or was not accessible. When you are using default instance , IP address is sufficient as the default port is known, it's 1433 , so when you pass IP only, or PC name only, and your instance is listening on 1433 (even if it is named, but still configured to listen 1433 ), the Jun 17, 2015 · Here are some of the things from my connection issue checklist. In ADS, on the Welcome screen click Create a Connection. Check your TCP/IP Port is enabled or not. Jonnadula Sasikumar. 5 . -- Click on Protocols for XXXX. If the remote server is not configured for TCP/IP and you're on a different network subnet with your dev machine, it is Feb 29, 2024 · To connect to your SQL Server instance, follow these steps: Start SQL Server Management Studio. 3. But if I try to connect to my SQL server from SQL server management studio on the host machine everything works properly. Start the 'SQL Server Browser'. – Apr 16, 2013 · 2. Sep 21, 2023 · This article series helps you troubleshoot the most common SQL Server connectivity issues and describes the tools and methods you can use for troubleshooting. Here is what I have done on the Remote Azure VM: Enabled TCP/IP Protocol in SQL Server Config Manager . I also I configure the port number in Sql Server Configuration Manager. WIN-NVAAFR9N703,1433. I also have done port fowarding too. Verify that the SQL Browser service is running. ldf and replace it in. Browse to the location of the instance of SQL Server that you want to allow through the firewall, for example C:\Program Files\Microsoft SQL Server\MSSQL11. ends up with the following error: Mar 22, 2010 · Section 1: Verify Azure Firewall Settings and Service Availability. In the Server name box, type tcp: to specify the Jan 15, 2022 · The SQL Server Browser service must be running on the server; TCP IP protocol must be enabled on the server (in SQL Server Configuration Manager, SQL Server Network Configuration, enable TCP IP for the current instance) Allowed remote connections in the properties of the SQL Server instance (doable from SSMS. May 30, 2020 · It is part of a Domain ISYYYY. I can see all other instances which are placed on other PCs. Enable the sql port 1433 from your external ip address in Azure vm network security group. The full step by step guide for enabling is here. If the answer is helpful, please click "Accept Answer" and kindly upvote it. Choose the SQL server instance that you want to connect. Click on Connections. To check it: -- Open SQL Server Configuration Manager from start program. Thats it . MSSQLSERVER\MSSQL\DATA folder . (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] If I use the server's IP address, this: [Win32Exception (0x80004005): The network path was not found] Feb 4, 2021 · The server was not found or was not accessible. I tried everything to fix it: disabled firewall; turned off Anti-Virus; enabled remote connections to this server Feb 22, 2023 · Using SSMS 18. Sep 17, 2015 · I have a fully funtional WPF application running on my local machine with SQL Server 2008 as database. Do telnet HC-SERVER-04 1433 from command prompt of the remote host (from where you tried to connect SQL server) If Step 2 fails: Create rule in Firewall of the SQL Server with port# 1433 and 1434 to accept May 14, 2018 · Check if instance name is correct and i f SQL Server is configured to allow remote connections. TO avoid having to install the ALIAS on every client machine you can created a computer object in Active Directory and assign it the IP address of the server where SQL is installed. Set the TCP Dynamic ports to 0 and leave TCP PORT blank. In the firewall I created an inbound rule to allow all TCP traffic on 1433. I have an instance of SQL Server 2012 and when I try to connect with it from other PC through SQL Server Management Studio it's not even visible. 0 : Login timeout expired. Access denied. TThe connection dialogue box pops up. Jun 24, 2011 · C:\Program Files\Microsoft SQL Server\MSSQL10_50. Since we need to connect to it remotely from another network, we’ll need to change this configuration to Public (internet). Server ports. From 'SQL Server Network Configuration' -> 'Protocols for [your server name]', then enable TCP/IP. Jan 8, 2024 · Connect to the Database Engine from another computer. It has been installed as 'Disabled'. Use SSMS connect to SQL server. If the remote machine is not on a domain, or if Visual Studio is running as a local account, the remote machine must have an account with the same user name and password as the local account. Turning on TCP/IP solved it for me. allow connection for this port in firewall. (I believe) all of the configuration parameters are the same; that is, TCP/IP Port 1433 and UPD Port 1434 allowed. From the Windows Start menu, click and type "Azure Data Studio" in the dialog box, then click to launch. But when I want to access sql server instance from an internet machine using SSMS and sql server authentication: Server: 123. Now the code works if I run it from WAMP server on my localhost and run the database also on my localhost via Microsoft SQL Management Studio Oct 20, 2016 · Thanks for the assistance. RDP and everything else works fine but just can’t reach the SQL remotely. Sockets. 3) Under TCP/IP properties page, enter public IP address of SQL server Nov 18, 2020 · I did these steps on the server where the application is located as: 1. For workstations with a new installation of SSMS, or when adding a new connection: Select Connect in Object Explorer, or File > New > Query with Current Connection. 0. May 11, 2011 · Did you check the following? Configure SQL Server to allow remote connections. My mysql remote access works perfectly though Jan 11, 2014 · 1. tcp ip on4. mdf and mastlog. In the SQL Server Properties - <server_name> dialog box, click Connections. Make sure SQL Browser is running: this manages your inbound connections on port 1433 and recognize the name of the instance then eventually re-directed to dynamic port that's where Named Instance listening on. Enable TCP / IP in SQL Server Configuration. Unable to connect to SQL Server on remote machine name. Login to your SQL Azure portal, Select your project and then switch to the Firewall setting tab. 6) Authentication and logon issue. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) The network path was not found Oct 19, 2021 · Suddenly my remote connection to SQL server stopped working. If your SQL server instance is a default instance, you can login with the following as the Server name: . (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Oct 21, 2016 · But connecting remotely to your database server usually entails configuring MySQL to listen on every interface, restricting access to port 3306 with your firewall, and configuring user and host permissions for authentication. Double click on TCP/IP. 168. nhnm (nhnm) October 20, 2021, 11:16am 11. PC2 has SSMS installed. Within the Connect to Server dialog, set the connection details for your server. Now I want my application to be accessible over the company network so that other users can use my app. -- Right Click on TCP/IP and open properties. My mysql remote access works perfectly though Nov 11, 2011 · The server was not found or was not accessible. I did remember to restart the service by going to SQL Server Services and restarting SQL Server (MSSQLSERVER). Right click and select Properties. To troubleshoot this issue, open TCP port 1433 for the service itself. mj at mx ke tx cr eh ks ib ff