Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Remotely Connect and Query a db. Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 6:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
Hello.

I have a SQL 2000 database used by a scheduling application on (we'll call it), Computer A . I also have a SQL 2008 db server (we'll call it) Server B. Computer A & Server B are in separate cities.

I need to create a job on server B that queries the data on Computer A every hour and sends a report. I've tried everything from opening ports 1433, enabling remote connections, enabling TCP/IP and I still can't connect. Can anyone get me some feedback?

Let's start with what should I be typing in the SERVER NAME field when I open up SSMS on Server B? I figure, if I can at least successfully establish a connection, I should be ok. I've tried typing the IP Address / instance name with no success.

Thanks
Post #1357354
Posted Tuesday, September 11, 2012 6:58 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:24 PM
Points: 3,342, Visits: 7,216
Is your instance on Computer A your default instance or is it a named instance?
Do you have a DNS that will solve Computer A name for your Server B?
Do you use the same network or your Computer A is in a different network than your Server B?
If different network, can you connect to your Computer A from Computer A using external IP?

Commonly you would use something like this:
ServerName\InstanceName
ServerName,9999 (ServerName,PortNumber)
192.168.0.5\InstanceName (IPAddress\InstanceName)
192.168.0.5\9999 (IPAddress\PortNumber)
www.ServerName.com\InstanceName(URL,InstanceName)
www.ServerName.com,9999 (URL,PortNumber)



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1357377
Posted Tuesday, September 11, 2012 8:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 7,128, Visits: 6,291
Did you create a Linked Server object for which to pass through credentials?

Are the credentials you are using for one server valid on another, or can those credentials at least impersonate the credentials on the other server?

Did you try tracert or ping from Server A to Server B?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357440
Posted Tuesday, September 11, 2012 9:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
On Computer A, the users can connect by using, "(local)\ABCPOS"

I have the IP Address of COmputer A, and I've tried, "x.x.x.x\ABCPOS" and still not able to connect.

I have no idea what the credential are, but I know that when on Computer A, I can connect using Windows Authentication.

Any other Help Ideas would be much appreciated.

thanks.
Post #1357498
Posted Tuesday, September 11, 2012 10:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
BTW, Computer A uses a default instance (local)

Any help please?
Post #1357557
Posted Tuesday, September 11, 2012 10:29 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
Actually, you failed to answer the most important question: Are they on the same network?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1357573
Posted Tuesday, September 11, 2012 10:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
They are not on the same network.
Post #1357582
Posted Tuesday, September 11, 2012 11:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 7,128, Visits: 6,291
mike 61998 (9/11/2012)
They are not on the same network.


This sounds like it's a Trust issue. Talk to your network / Active Directory admin and see if they can set up a trusted connection between the domains. That might be the main issue.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357612
Posted Tuesday, September 11, 2012 12:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 20, 2012 2:55 PM
Points: 11, Visits: 19
One is a workstation connected to the internet using Comcast (not on a windows domain), and the other is a workstation on a bellsouth connection (not on windows domain either)
Post #1357619
Posted Tuesday, September 11, 2012 12:11 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:23 PM
Points: 415, Visits: 2,333
Maybe you could look at your cable modem for the network with the 2000 server and see if it needs to forward ports. One hint would be if the 2000 computer has an ip address starting with numbers 192.168. ie., 192.168.x.x

Post #1357624
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse