question

JonJacobs-9073 avatar image
1 Vote"
JonJacobs-9073 asked CarrinWu-MSFT commented

SQL Server Express - connect from another machine

I installed SQL Server Express v 2012 on one of our servers, whose OS is 2008 Server Standard.
Although the OS is 64 bit, I was only able to install the 32-bit version.
I used Default Instance, which was MSSQLServer. I turned on TCP/IP and that defaulted to port 1433 for all IPs, which is what I wanted anyway.
I stopped and started the instance so the change was made effective.

However, I still cannot access the instance from another computer. What am I missing?

sql-server-general
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JonJacobs-9073, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

Actually I did reply, but for some unknown reason it was not successfully posted. I am trying again. I did read the references and attempted the solutions offered and could not. I finally concluded there was something wrong with my installation of the SQL Server Express 2014 and uninstalled it. There was also a corrupted 2008 version I uncovered, but was unable to uninstall it. I removed the vestiges of that software manually and deleted the related services. With that cleaner environment, I will attempt to reinstall the 2014 version, and maybe this time I can get the SQL Server Browser running.

0 Votes 0 ·

Hi @JonJacobs-9073, thank you for your replying. If you try to reinstall SQL Server, you could refer to below steps to delete the left components:
1. Uninstall the existing SQL Server and all the components from the add remove program.
2. Backup the registry.
3. Delete the following keys using regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
6. Rename all the SQL Server folders in the computer.
7. Reboot the machine.

Waiting for your good news.

0 Votes 0 ·
Show more comments
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

In Express Edition remote connections are disabled by default, you have to enable them first: Configure the remote access Server Configuration Option

And if there is a Firewall runing on server and/or client side, you have to setup rules to allow access on Port 1433; see Configure a Windows Firewall for Database Engine Access


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered PratikThummar-7535 commented

Hi @JonJacobs-9073,

Welcome to Microsoft Q&A!

Please check below list:
1.SQL Server Browser service is running
95521-browser.png
2.Enable protocols: To connect to SQL Server from another computer, you normally use TCP/IP. If TCP/IP isn't enabled, right-click TCP/IP, and then click Enable.
3.Testing TCP/IP connectivity: In the command prompt window, type ping <ip address> and then the IP address of the computer that is running SQL Server.

Please get more information from Troubleshoot connecting to the SQL Server Database Engine


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




browser.png (23.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Also set SQL Browser on Automatic in Services.msc.

Also Check Firewall..

Antivirus...

0 Votes 0 ·
PratikThummar-7535 avatar image
0 Votes"
PratikThummar-7535 answered

Also set SQL Browser on Automatic in Services.msc.

Also Check Firewall..

Antivirus...

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.