how to access 2000 and 2005 from clint m/c | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to access 2000 and 2005 from clint m/c

how can i access remote m/c where i have both sql server 2000 and 2005 fom the client m/c?
m/c? Michael
MCDBA "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends — if they’re okay, then it’s you!"
Surely not a motorcycle. Uh, probably old-school shorthand for "machine".
then 12345 can use SS Management studio??? Michael
MCDBA "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends — if they’re okay, then it’s you!"
On SQL Server 2005 you have to enable "Local and remote connections" via the Surface Area Configuration, methinks. —
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de
You cannot access any machine using SQL Server tools, you need to have corresponding SQL 2000 and/or 2005 server instance to connect provided you have privilege to connect with relevant client ALIAS declared. KBAshttp://support.microsoft.com/kb/265808 &http://support.microsoft.com/kb/827422 fyi in addition to read the books online too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Hi Frank, i hve enabled "Local and remote connections" (for sql server 2005) on remote computer. BUt facing the same problem.
let me explain what i did, i have installed sql server 2005 first and then sql servr 2000 with named instance in the remote computer . Now, they are working fine on the remote computer. Now in the client computer i hve registered successfully with 2005 but failed to register with sql server 2000. During registering with sql server 2000 on the client computer, the error displaying is access denied or no server exists. i am using tcp/ip channel fro sql server 2005 and named piped for sql server 2000.
Please help me out.

May be your client may not be able resolve the port number…
Try to pass the port number along with instance name… ex: ServerNameInstanceName,PortNumber MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

By all means refer to KBAhttp://support.microsoft.com/kb/328306 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>