Linked server config prob

SQL 7.0
Trying to create a linked server, but I always get the
error message below. I've created a successful ODBC
connection to the remote server and I use that name in
the config process.
"Error 6: Specified SQL Server not found."
Any ideas?
Thanks,
Don"Don" <ddachner@.hotmail.com> wrote in message
news:a85701c3eb7e$01fc1450$a601280a@.phx.gbl...

quote:

---

> SQL 7.0
> Trying to create a linked server, but I always get the
> error message below. I've created a successful ODBC
> connection to the remote server and I use that name in
> the config process.
> "Error 6: Specified SQL Server not found."

---

Are you creating a linked server from SQL Server v7 to SQL Server v7? If so,
what security mode is in place and does the account have proper access?
Another possibility is name resolution -- try using the IP address instead
of the NetBIOS name.
Steve|||Yes, trying to link two v7 servers.
The security mode is SQL/Windows on both.
I'm using the sa account which is the same on both.
I've tried using the IP address, which didn't give an
error message, but when I tried a query using the 4 part
name, I get a syntax error on the dots of the servername,
i.e, 123.111.333.555.DBNAME.dbo.TABLENAME there's a
syntax error "near" where the "." is of the 123.111 part
of the name so i gave up on that approach.
Don

quote:

---

>--Original Message--
>"Don" <ddachner@.hotmail.com> wrote in message
>news:a85701c3eb7e$01fc1450$a601280a@.phx.gbl...
>Are you creating a linked server from SQL Server v7 to

---

SQL Server v7? If so,

quote:

---

>what security mode is in place and does the account have

---

proper access?

quote:

---

>Another possibility is name resolution -- try using the

---

IP address instead

quote:

---

>of the NetBIOS name.
>Steve
>
>.
>

---