November 16, 2016 at 8:12 am
Has anyone any experience this SQL SERVER error: "Cannot connect to localhost"?
If so could you help point me in the right direction? How to repair sql?
Any help/advice would be appreciated,
Chris
November 16, 2016 at 8:23 am
You're probably going to need to expand on this (Cannot connect effectively tells us nothing). How are you trying to connect? SSMS, Excel, Other tool.
A couple of silly simple questions:
Is the SQL Server Service running?
Is it a named, or default named instance?
Is the SQL Service running on the default port? (1433)
SQL Server is running on the machine you are trying to connect from, not a remote computer.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 22, 2016 at 9:17 am
Hi,
Gollow these steps to connect with SQL Server 2008. Go to Control Panel - Administrator Tools - Services select SQL SERVER and double click on it- Click on start Service - Now login to SQL server with Windows authentication and use user name : (local). If it useless try this application https://www.repairtoolbox.com/sqlserverrepair.html
Good luck,
Leo Kidd
November 22, 2016 at 9:22 am
If the above advice doesn't work, then close SSMS, right click on SSMS shortcut, and then choose "Run as Administrator".
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 23, 2016 at 2:32 pm
I want to say thank you for taking the time to share how to go about fixing this.
November 23, 2016 at 2:33 pm
Leo it is a solution.Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply