Date parsed: 03/04/2008 10:49:48
Date: Thu, 03 Apr 2008 10:49:48 GMT
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@microsoft.com.
==================================================
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@online.microsoft.com (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@microsoft.com.
>
>==================================================
>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@microsoft.com>
><VKqEKdtkIHA.6264@TK2MSFTNGHUB02.phx.gbl>
>>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@microsoft.com.
>>>
>>> This posting is provided "AS IS" with no warranties, and confers no
>rights.
>>>
>>> --------------------
>>> >From: =?Utf-8?B?YzY3NjIyOA==?= <betty@newsgroup.nospam>
>>> >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
>>> >
>>>
>>>
>>
>
>
