Avatar of LJG
LJG
 asked on

Cannot connect - Windows Server 2008

I cannot connect to any instance of SQL Server on the Windows Server 2008 I installed on (in this case I'm logged in to the Server and SQL is on the computer I'm logged into).  I took over a job and the following is what I saw - See the graphic below for further info.

1) No one knows the facts for this customer - but when I logged into their server I could load SQL Tools for 2008 but when the screen came up to "Connect to Server"I couldn't connect to any instance (Server Name) - trying local.

2) Thought - no problem I reinstall SQL Server 2008 Express.  After reinstalling I still can't log in to any instance (Server Name) - trying
Server Type --> Database Engine
Server Name --> Tried all 3 -->  (local) / EXP2008 / SQLEXPRESS
Authentication: --> Windows Authentication

What do I need to do?

Thanks in advance for your help.
LJG



SQL-Problem.jpg
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Member_2_4226667

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
sammySeltzer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Member_2_4226667

Have you check the TCP/IP setting for the network service at "SQL server configuration manager"? You may have issue on networking. Check which protocol is enabled and what port is used for which instance. since you have 2 instances installed, you should check if the SQL server browser service is started.
LJG

ASKER
The way I solved the problem
Start/Administrative Tools / Services / SQL Server (My instance)
Right Click Properties
Log On tab
Check Allow service to interact with desktop
sammySeltzer

fantastic!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Member_2_4226667

OK. I haven't come across that before. thanks for sharing ^v^