RE: connect to remote sql server in business Intelligence Developm

Hi Betty,

Have you got any progress on this issue or have you checked those things I
mentioned in previous reply?

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

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng [MSFT])
Organization: Microsoft
Date: Tue, 01 Apr 2008 03:07:21 GMT
Subject: RE: connect to remote sql server in business Intelligence Developm


Thanks for your reply Betty,

Seems the condition does be a bit complex.

Let's summarize something you can check on your side:

** make sure that this is the only remote SQL Server instance you can not
access from the machine, try some other remote SQL Server instances.

** As you said that

=======
When I got into sql server 2005 Surface Area Configuration, the service
name
is
MSSQL$SQLEXPRESS and it seems installing sql server standard edition
doesn't
change this instance name or create another instance server name? will
this
cause problem?
========

are you sure current only SQL Express is existed on that remote machine?
if
so, SQL Express is not allowed for remote connection by default. I
suggest
you install a standard or server edition instance(be sure to choose an
instance name) and turn on remote connection

#How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/kb/914277

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

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#noti
f
ications.

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


--------------------
Thread-Topic: connect to remote sql server in business Intelligence
Developm
References: <3A71714D-B332-4245-B9F7-10B2D15B0B81@xxxxxxxxxxxxx>
<VKqEKdtkIHA.6264@xxxxxxxxxxxxxxxxxxxxxx>
Subject: RE: connect to remote sql server in business Intelligence
Developm
Date: Sun, 30 Mar 2008 20:13:00 -0700


Hi Steven,

My situation is kind of odd. I installed visual studio 2005 and sql
expression quite a while ago. a month ago, when my boss wants me to
upgrade
our sql server 2000 to sql server 2005 and I noticed I need BI
development
stdio and better sql server 2005 edition. I installed sql server 2005
standard edition without removing sql server express edition. After
installing sql 2005 standard edition, I saw sql server management studio
icon
and I believe it is Ok.
so i searched a bit and find that the following link is quite helpful to
enable remote connection in BI:
http://businessintelligence.ittoolbox.com/groups/technical-functional/cogno
s
-reportnet-l/error-testing-the-sql-server-2005-content-store-connection-in-
c
ognos-configuration-1440715

after set up, I got into BI and data connection-->add connection, I only
see
local server and there is no place I can add a remote server!!!
--

When I got into sql server 2005 Surface Area Configuration, the service
name
is
MSSQL$SQLEXPRESS and it seems installing sql server standard edition
doesn't
change this instance name or create another instance server name? will
this
cause problem?

Yes, I was able to connect to a remote server on our instranet before
through visual studio 2005 professional edition on my local computer when
I
was on our intranet. but now when I open visual studio 2005 professional,
I
cannot make remote connection either.
but the BI just installed a couple weeks ago through this link:
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
and just cannot connect.
does that make any difference? it seems that this is for sql server 2005
express.

does BI has different version because of sql server edition version, I am
really lost.



I was able to
Betty


"Steven Cheng [MSFT]" wrote:

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