On Fri, Sep 5, 2014 at 8:18 PM, Ted Roche <tedroche@gmail.com> wrote:

> On Fri, Sep 5, 2014 at 4:15 PM, Vince Teachout <teachv@taconic.net> wrote:

>

> >

> > I hate to mention something so obvious, as you've most likely done this,

> > but since it's the only trick I know, and since I've been bitten a few

> > times.... On studio manager, right-click sever, properties,

> connections -

> > is "allow remote connections" checked?

> >

>

> No, no, no, you're exactly right. We usually jump into the complicated

> stuff, skipping over the obvious:

>

> Is it turned on? Yes

> Is it plugged in? Yes

> Are the blinky lights blinking? Yes

> Have you turned it on and off? Yes

>

> (That usually solves 90% of my client support questions.)

>

> The server has been running for a couple of years, and we are able to

> connect from many machines around the office, including using the 32-bit

> ODBC Manager on this trouble-making laptop. It's only the SQL Server

> Management Studio that refuses to connect. I don't think it uses ODBC

> drivers; I think it connects to the SQL server using Named Pipes or TCP/IP.

> I need to check the connection configuration as Allen suggested.

>

> Other than that, I got nothing. Sorry, and good luck.

> >

>

> Well, you know, it's a bit of a relief that someone didn't point out

> something obvious I missed.

>

> ----------------------

Check the services on the server to verify that the SQL Server is running.

Verify what instance name it may be under?

--

Stephen Russell

Sr. Analyst

Ring Container Technology

Oakland TN

901.246-0159 cell

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/CAJidMYKqJTdaB65gFxPZMmmmcpsBKdUWp5B1-zP-5OytHpwXVA@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.