""Brad Syputa - MS"" wrote:

> With the June CTP comes the Surface Area Configuration tool. Launch the
> tool and makes sure that remote connections are enabled for your SQL
> Server. By default, SQL is much tighter on security and remote connections
> are off after initial install.
>
> --------------------
> | Thread-Topic: Cannot create a connection to data source
> | thread-index: AcWsvM7xh3SUrYS9QcCFLHwzj12wwg==
> | X-WBNR-Posting-Host: 65.118.63.88
> | From: =?Utf-8?B?Um95?= <Roy@discussions.microsoft.com>
> | Subject: Cannot create a connection to data source
> | Date: Mon, 29 Aug 2005 10:12:17 -0700
> | Lines: 12
> | Message-ID: <EB5CC7FC-F898-48AC-A8CD-E9B6668EF797@microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51349
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
> | I created a report on data from another server. I can run the report just
> | fine on the server with Reporting Services.
> | When I try to run the report from my computer I get the cannot create
> | connection error. I have full rights to the server and sa privilages to
> SQL
> | Server on the RS server and the remote server on which the data is
> located.
> | I have checked with the Network administrator and kerberos is enabled.
> | I really need to get this working and prove to management that RS will do
> | all we need in the way of a reporting tool.
> | Your help will be apprecited.
> | Roy
> |
> |
>