Microsoft SQL Server Login: Connection Failed

I'm trying to set up a DSN to our SQL Server on a new Windows 7 Pro workstation (right out of the box) with all Windows Updates installed.  I am getting a connection failed error message even though I'm logged on as the Domain Administrator.  I have run into this in the past but it was so long ago I don't remember the resolution (if I did get it resolved).  :-)DSN setup error message
Kerry WilsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kerry WilsonAuthor Commented:
Thank you.  Sorry about.  I was in a hurry and didn't look at it close enough before posting.  I did the Alt-Print Screen method to capture only the active window so I had incorrectly assumed when I pasted it the active window would be all that would be seen.
0
Deepak ChauhanSQL Server DBACommented:
Are you able to connect this server using SSMS? Please check your domin account  is added in sql server logins.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check if SQL Server service is running in the server.
Check the same for SQL Browser service.
Both need to be started and running.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Kerry WilsonAuthor Commented:
I have no idea what SSMS is or the SQL Browser service.  I know it's running.  We are a manufacturing facility with a 24x6 production floor.  If it stops, I hear about it immediately...even if it's 3:00am.  :-)  And, I'm not doing anything any differently as I've done dozen of times over the last eight years or so.

BTW, this is MSDE 2000 running on a W2k Server DC.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
this is MSDE 2000 running on a W2k Server DC.
This justifies why you don't know SSMS or SQL Browser.
So, it's a very old and unsupported solution for a manufacturing facility. You should think in upgrading those versions asap.
0
Deepak ChauhanSQL Server DBACommented:
Yes plan this to upgrade and for now check this link might be helpful.

https://support2.microsoft.com/default.aspx?scid=kb;en-us;827204
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kerry WilsonAuthor Commented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.