Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Cant connect to SQL server, error 40


  • Please log in to reply
1 reply to this topic

#1 zzADRiANzz

zzADRiANzz

  • Members
  • 1 posts
  • OFFLINE
  •  

Posted 03 July 2016 - 02:43 PM

Forgive me if this post is in the wrong place. Yesterday I got on my pc and an error showed up saying "A network-related or instance specific error occurred while establishing a connection to SQL server" "(provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)." Along with other things but I think that is the most important part. I had never heard of these SQL servers but after doing some research the most common thing people would say is to make sure my SQL browser servers were running and to go through some steps to turn them one, one of which was through the command prompt which didn't work. Another was to just find it in my program files but the only things in there were 2 folders 1 titled "Microsoft SQL Server" and one titled "Microsoft SQL Server Compact Edition" and I couldn't find anything useful in there. I'm thinking somehow something got deleted on my computer so I don't have the SQL server browser anymore but I'm not sure. If anyone knows about the SQL servers and could maybe help that would be greatly appreciated. I should also add that my computer does say I am connected to my Internet and I am even able to open Steam and chat with friends but not able to open the steam store, and also I'm on Windows 10 and have been for a while now.

BC AdBot (Login to Remove)

 


#2 usasma

usasma

    Still visually handicapped (avatar is memory developed by my Dad


  • BSOD Kernel Dump Expert
  • 25,090 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Southeastern CT, USA
  • Local time:11:30 PM

Posted 04 July 2016 - 05:19 AM

I don't know much about SQL Server, but these are the most common repair steps:

 

- System Restore to a point before this started happening.

- DISM/SFC repair (DISM doesn't work with W7, although SFC does)
    

 

Then please run the following DISM commands to see if there's any problems with the system (from an elevated (Run as administrator) Command Prompt).  Press Enter after each one:
   
Dism /Online /Cleanup-Image /ScanHealth
   
Dism /Online /Cleanup-Image /CheckHealth
   
Dism /Online /Cleanup-Image /RestoreHealth
    FYI - I have repaired systems using the last command even though problems weren't found with the first 2 - so I suggest running them all.

    From this article: http://technet.microsoft.com/en-us/library/hh824869.aspx

    You can also run sfc.exe /scannow from an elevated (Run as administrator) Command Prompt to check for further corruption.


- RESET using the "Keep My Files" option (W8 calls this a REFRESH; W7 and earlier doesn't have this function)

- Repair install of the OS (Thanks to FreeBooter!):
   

 

"How To Perform a Repair Installation For Windows 8, 8.1 and 10"
    https://www.winhelp.us/non-destructive-reinstall-of-windows-8-and-8-1.html

    "How to Do a Repair Install to Fix Windows 7"
    http://www.sevenforums.com/tutorials/3413-repair-install.html

    "How To Perform a Repair Installation For Vista"
    http://www.vistax64.com/tutorials/88236-repair-install-vista.html

    "Non-destructive reinstall of Windows XP"
    https://www.winhelp.us/non-destructive-reinstall-of-windows-xp.html


- RESET using the "Remove Everything" option (W8 calls this a RESET; W7 and earlier doesn't have this function)

If using W7 or earlier, this can be accomplished by resetting the system by use of the recovery partition/recovery disks/recovery drive.
If you don't have them, you can usually order them from the OEM manufacturer of your system ( US points of contact here:  http://www.carrona.org/recdisc.html )

- Wipe and reinstall from the Recovery Partition (if so equipped)

- Wipe and reinstall from Recovery Media - to include deleting all partitions.
If you don't have them, you can usually order them from the OEM manufacturer of your system ( US points of contact here:  http://www.carrona.org/recdisc.html )

Edited by usasma, 04 July 2016 - 05:19 AM.

My browser caused a flood of traffic, sio my IP address was banned. Hope to fix it soon. Will get back to posting as soon as Im able.

- John  (my website: http://www.carrona.org/ )**If you need a more detailed explanation, please ask for it. I have the Knack. **  If I haven't replied in 48 hours, please send me a message. My eye problems have recently increased and I'm having difficult reading posts. (23 Nov 2017)FYI - I am completely blind in the right eye and ~30% blind in the left eye.<p>If the eye problems get worse suddenly, I may not be able to respond.If that's the case and help is needed, please PM a staff member for assistance.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users