| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2008-01-31 : 05:37:17
|
Hi all, My support team inform me that my servers have been updated and rebooted on monday. Now I need to run some cross db queries today and I dont seem to be able to connect anymore. I am getting the (dreaded apparant but not surprisingly) Msg 17, Level 16, State 1, Line 1[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Now first thing I did was try to drop both linked servers and add again. I am thinking that the particular server has a dynamic ip which I have determined. Ive noticed a work around on MSFT but it say about using a connection string with IP. Can anyone help me work this out? id appreciate it."Impossible is Nothing"  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-31 : 05:45:26
|
| Hi Peso, forgive me I dont understand. I know I can write a connection string. But I have never written one for a specific query? How would I code that in T-SQL? Am I to exec sp_addlinkedserver with this connection string? Does that mean I have to add one for every catalog I want to query? Sorry for all the questions."Impossible is Nothing" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-31 : 06:06:40
|
A connectionstring is used to create a "carrier" to the database.The "carrier" is then used as a communication link between your application and the database.SO you write your queries in your application, send them to the database over the communication link and have the database process the query.Eventually the database will return some data back to your application.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-31 : 06:32:15
|
Hi, I am running these queries through EM, I understand the string. I was wondering do I have to register a server with the string to hard code the IP? Im not sure if its just a red herring because whats strange is one server can see out and view the other yet the other server cant see the one that can see it.  "Impossible is Nothing" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-31 : 06:33:39
|
Register the server in "Registered Servers" window?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-31 : 06:49:54
|
| It wasnt in there. I added it, the test went fine, yet I still cant query from the EM of one server to get info out of the other. I can run the query from the one that can see and pull it in, im just wondering why I cant do it the other way."Impossible is Nothing" |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-31 : 07:59:27
|
| Fixed it. I deleted all linked servers on all box's, restarted the engines and linked them up again. All seems well. Thanks for your help Peso :)"Impossible is Nothing" |
|
|
|
|
cross server query