RE: connect to remote sql server in business Intelligence Development

Hi Betty,

From your description, you're encountering some problem connect to a remote
server in SQL Server BI Studio (in server explorer), correct?

As you said that connecting through SQL management studio works, is the
management studio installed on the same machine with the BI studio? Based
on my test , BI Studio or VS 2005 should be able to connect remote SQL
Server instance. I suggest you also try connecting other remote SQL Server
instances to see whether the same behaviors remain. BTW, have you also
installed Visual Studio 2005 on that machine? So far I only know that
Visual Studo 2005 Express edition will have limitation on Local Database
access.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@xxxxxxxxxxxxxx

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
From: =?Utf-8?B?YzY3NjIyOA==?= <betty@xxxxxxxxxxxxxxxx>
Subject: connect to remote sql server in business Intelligence Development
Date: Sun, 30 Mar 2008 10:52:00 -0700




Hi all,

I can add a remote server connection in SQL Management Studio. But it
seems
that I cannot successfully add a remote server connection to SQL server
in Business Intelligence Development Studio on my local computer.

In Intelligence Studio, in server explorer I click server -->add server
and
type the server IP address and hit connect and then it gives me the
message
"could not reconnect to "66" (which is part of the server IP), make sure
that
the machine name and path are valid"

Does that mean I have to install Business Intelligence Development Studio
on
the remote server in order to develop a SSIS package, if I cannot be
remotely
connected to a remote server through Business Intelligence on a local
machine? I just don't get it.

Can you shed light on me?

Thank you

--
Betty


.

Relevant Pages