.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

Can not connect the services?

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
I have scenario like this:- I have 8 physical servers under same domain. I can connect all the database engines from any of the server which are running under local system. I have issue with integration service and analysis service. I can not connect those services from other servers. I can connect only from local machine. Do anyone has any idea about it?


View Complete Post


More Related Resource Links

SAAS: Connect Enterprise Apps with Hosted BizTalk Services

  

In this article we introduce you to BizTalk Services, new technology that offers the Enterprise Service Bus features of BizTalk Server as a hosted service.

Jon Flanders and Aaron Skonnard

MSDN Magazine June 2008


HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to

  

Greetings.

 

I am trying to install reporting services and join it into existing service farm.

Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

We are using same domain account to run sharepoint services and reporting services. 

I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

Either way, it wont work for me:

1)

If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.

2) 

If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

(moss2k7/ReportServer - /

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

  
Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Cannot connect to Reporting Services just after installation

  
OS Windows Vista Ultimate. SQL Server 2008 RTM, default instance. Reporting services installed in native mode. Control Panel/Services:Can start/stop Database Engine Instance as well as Reporting Services.============================SQL Server Management Studio:Can connect to Database Engine instanceCannot Connect to Reporting Services Error notification as follows: TITLE: Connect to Server------------------------------ Cannot connect to UNIVERSE. ------------------------------ADDITIONAL INFORMATION: Unable to connect to the server at SERV1. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------BUTTONS: OK------------------------------SQL Server Configuration Manager:Can stop and start instance of Reporting Services   Dump file after starting RS: resourceutilities!WindowsService_0!1024!08/29/2008-14:35:26:: i INFO: Running on 1 physical processors, 2 logical processorsrshost!rshost!1648!08/29/2008-14:35:26:: e ERROR: Failed to regi

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Reporting Services doesn't connect to database automatically

  
Hello. I use Windows 2003 R2 x64 and SQL Server 2005 x64.  The problem is: if the Reporting Services Service were doesn't start automatically, despite the set up parameter "Restart Automatically" every 1 minute in the service Recovery property. So every minute after Service stopped i recieve an error in Event Viewer: Report Server (MSSQLSERVER) cannot connect to the report server database However, after starting it manually from Computer Management->Services or Reporting Services Configuration Tool it starts normally without any error. I use local system admin account to start Services and to connect to Database. Both parameters are set using RS Configuration Tool. Will be thankful for any advice.

Can't connect to SQL Server 2008 Reporting Services

  
When attempting to connect to SQL Server 2008 (evaluation) on Windows XP SP3, using the following url, http://servername:8080/ReportServer I receive a popup dialog box asking me for a user name and password to connect to the server.  When I enter the domain\user and password that I think it should be, it pops up two more times and then displays a blank internet explorer web page.  It is a fresh install and I believe I have everything running correctly.   Any input or guidance would be extremely appreciated.   Thank you in advance.

Cannot connect to Reporting Services

  
I cannot connect to Reporting Services from Management Studio. The error message I get is:   TITLE: Connect to Server ------------------------------   Cannot connect to <SERVERNAME>\ReportServer.   ------------------------------ ADDITIONAL INFORMATION:   Report Server WMI Provider error:   Invalid namespace  (Microsoft.SqlServer.Management.UI.RSClient)   ------------------------------   Invalid namespace  (System.Management)   ------------------------------ BUTTONS:   OK   This appears to be a WMI issue, but when I checked on the SQL server machine, the WMI service is running and the firewall is turned off.   I ran a few tests and found that the WMI has its ReportServer WMI data at \\<SERVERNAME>\root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin:MSReportServer_ConfigurationSetting" (I can find this info using a small console app I had to write). Is this the correct place for the WMI info?   Version info: Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.1600.22 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 6.0 Microsoft Internet Explorer    &n

Unable to connect to local host service when a splash screen is show before start the services

  
Hi all:


I want to show a splash screen before start the local host services, the host can be open without error, however the client (Form1) is not able to connect to the service. Without the splash screen, every thing work fine. Any idea why ?

Here is the code.



Imports System.ServiceModel


<ServiceContract()> _
Public Interface IHelloWorldService
   <OperationContract()> _
   Function SayHello(ByVal name As String) As String
End Interface

Public Class HelloWorldService
   Implements IHelloWorldService

   Public Function SayHello(ByVal name As String) As String Implements IHelloWorldService.SayHello
      Return String.Format("Hello, {0}", name)
   End Function
End Class

Module Module1
   Private host As ServiceHost
   Private frmSplash As Form

   Sub Main()
      AddHandler AppDomain.CurrentDomain.AssemblyLoad, Addres

reporting services is running but cannot connect

  

Infrastructure people did some maintenance on my SQL Server machine, although I am not sure if that has anything to do with my problem. The problem is, I have the Database Engine and Reporting Services turned on, but I cannot connect to Reporting Services.

Here are the symtoms.

From another client machine, I can connect to the database engine using Mgmt Studio. But using the same server name, I am not able to connect to the reporting services. The error I get back says

TITLE: Connect to Server

------------------------------



Cannot connect to nysrv126,2433.



------------------------------

ADDITIONAL INFORMATION:



The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)



------------------------------

BUTTONS:



OK

------------------------------

"nysrv126,2433" is the server name and it is the same server name I was able to use to connect to the database engine.

 

Next, on the server machine itself, I get the same symtoms as above in Mgmt Studio. That is, I can connect to the database engine but not the reporting services. However, I am able to open up Reporting Services Configuration Manager (which means I connected to reporting services).


unable to connect Reporting Services

  

Hi All,

I have configured Reporting Services in SQL Server 2005 steps.

1) Installed Service pack2 for SQL Server 2005
2) Installed Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft Sharepoint Technologies.
3) From Reporting Services Configuration Manager configured the below list
 -- Report Server Virtual Directory (Configured and icon display green colour )
 -- Report manager Virtual Directory(not configured when i click it shows a message (Report Manger is not     available when the report server is integrated with Windows Sharepoint Services))
 -- Windows Service Identity(Configured and icon display green colour )
 -- Web Service Identity(Configured and icon display green colour )
 -- Database Setup(Configured and icon display green colour )
 -- Sharepoint Integration(Configured and icon display green colour )

4) When iam trying to connect Reporting Services through SQL Server management studio it gives me error
Error:
===================================

Cannot connect to LHI-TEST.

===================================

The operation  is not supported on a report server that is configured to run in SharePoint integrated mode. ---> The operation  is not supported on a report server that is configured to run

Cannot connect to Reporting Services in SSMS using Servername

  

Hi,

Kindly help me as i can't connect to Reporting Services in SSMS using SERVERNAME but using URL(http://localhost/ReportServer) I can connect. Here is the error I received. Please advice.

TITLE: Connect to Server
------------------------------

Cannot connect to PERRYDUNDOC-W7.

------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the server at SERVERNAME. The specified URL might not be valid or there might be a problem with the report server version or configuration. Specify a different URL, or contact your server administrator to verify that the report server runs SQL Server 2008 or later. Additionally, if you are trying to connect to a SharePoint-integrated report server, verify that SharePoint is installed on the server and that the report server uses SharePoint integrated mode. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
BUTTONS:

OK
------------------------------

Thanks,
Perry


"Cannot Connect to Performance Point Services"

  
When attempting to create my first data source in Performance Point Services Dashboard Designer, I get the above error.  I am owner on the Sharepoint Farm and the PPS site.
Steve Walker

Unable to Connect to Analysis Services from other machine

  
I installed Analysis services 2008 on a xp machine at home. 
I can connect from this machine via the data mining add-in to analysis services.
From my laptop I can connect to the normal sql server but I i'm not aible to make a connection in the data mining add-in to the analysis services. The error message I get is: 

Test Connection Failed.
A connection cannot be made. Ensure that the server is running.
Unable to read data from the transport connection: an existing connection was forcibly closed by the remote host
an existing connection was forcibly closed by the remote host.

I opened port 2383 in the firewall and made an exception for msmdsrv.exe

I tried to add every user I can think of but no luck

Can someone please help me

p.s. no domain

Management Studio won't let me connect to Integration Services. What's wrong?

  

I'm trying to connect to Integration Services on a our SQL Server 2008 database server, so I can set up an SSIS package to run as a job.

But when I start SQL Server Management Studio and click on the Server type list, Integration Services is not one of the choices available (the only choices are Database Engine and SQL Server Compact.

When this happens, the documentation suggests going to the SQL Server Configuration Manager and starting the Integration Services service.  But this service is already running on my computer.  I tried restarting it, but that doesn't make a difference.

Any suggestions?


How to connect Oracle Database in Microsoft Analysis Services

  
Hi All,

I am not able to connect oracle database from MS-Analysis Services.


All my Fact tables and Dimension tables are residing on Oracle
database.Both the Oracle database and MS Analysis Services are on the
same server.


I am working on the node and I was able to create the datasource using
"Microsoft OLE DB Provider for Oracle " and the test connection also
succedded but while creating the cubes using the cube wizard it throws
error saying " Connection to the data source Failed".

Any one could help me in this regards.

What are the ways to connect the oracle DB from MS Analysis Services.

Is this problem becoz of any permission settings, how do I give permissions for the users.

Regards
Saravanavel


Where you can connect using Business Connectivity Services (BCS)?

  

Hi,

Where exactly you can connect using BCS? MSDN is too general to undestand, I need some life - examples.

For example, is it for integrating Sharpoint with external web sevices written in Java?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend