SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Remotely Connect and Query a db.


Remotely Connect and Query a db.

Author
Message
mike 61998
mike 61998
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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
Luis Cazares
Luis Cazares
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42632 Visits: 19847
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.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
Brandie Tarvin
Brandie Tarvin
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38619 Visits: 9283
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
mike 61998
mike 61998
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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.
mike 61998
mike 61998
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 19
BTW, Computer A uses a default instance (local)

Any help please?
RBarryYoung
RBarryYoung
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35640 Visits: 9518
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."
mike 61998
mike 61998
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 19
They are not on the same network.
Brandie Tarvin
Brandie Tarvin
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38619 Visits: 9283
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
mike 61998
mike 61998
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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)
patrickmcginnis59
patrickmcginnis59
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1575 Visits: 2333
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search