Author: Ted Roche
Posted: 2014-09-05 14:55:52 Link
Folks:
This has me stumped. Installed SS 2008 R2 management Studio from the same
DVD I've used before (burned from MS Action Pack) onto a shiny new Dell
Win7-64 bit. Trying to connect to our networked machine using the same
settings as our previous Win7 32-bit machine never successfully connects,
and I'm stumped as to why.
The connect dialog sees and displays the server name. We use SQL Server
authentication and the identical user name and password we used on the
other machine.
I have, separately, set up 32-bit ODBC connections and 64-bit ODBC
connections to access the data from our Foxpro apps, and that seems to work
okay.
Dropped the Windows Firewall. No change.
Drawing a blank. Suggestions?
--
Ted Roche
Ted Roche & Associates, LLC
--- 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/CACW6n4sHa9DgT8d2OVK0NSmEVSKyWX-fdi9+XFqfSrATvm0H5g@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.
Author: Vince Teachout
Posted: 2014-09-05 15:15:01 Link
Ted Roche wrote:
>
> Dropped the Windows Firewall. No change.
>
> Drawing a blank. Suggestions?
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?
Other than that, I got nothing. Sorry, and good luck.
---
This email is free from viruses and malware because avast! Antivirus protection is active.
_______________________________________________
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/540A19C5.7040600@taconic.net
** 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.
Author: Allen
Posted: 2014-09-05 15:31:10 Link
My limited knowledge...
Not server manager but the other one, I think configuration. Are the
protocols set up?
Al
-----Original Message-----
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?
Other than that, I got nothing. Sorry, and good luck.
---
This email is free from viruses and malware because avast! Antivirus protection is active.
_______________________________________________
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/017c01cfc948$56709200$0351b600$@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.
Author: Ted Roche
Posted: 2014-09-05 20:18:52 Link
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.
--
Ted Roche
Ted Roche & Associates, LLC
--- 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/CACW6n4se4pCJ_u_B_cg8vk-J=4EAi0+nDDmG0vqUWWvo54zP_w@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.
Author: Stephen Russell
Posted: 2014-09-06 22:12:28 Link
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.