Cannot Expanding MSDB in SSIS

Hi,
I am trying to expanding MSDB under SSIS and getting following error:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server on the computer. For more information, see the topic "Configuring the
Integration Services Service" in Server 2005 Books Online.
Login timeout expired
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
TCP Provider: No connection could be made because the target machine
actively refused it. (MsDtsSrvr)
My sql server is clustered and SSIS is clustered also.
Thanks in advance!
Yuhong
Is SSIS in the same resource group as the SQL Server? Is the SQL Server the
default instance or a named instance?
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)
"Yuhong" wrote:

> Hi,
> I am trying to expanding MSDB under SSIS and getting following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
> --
> ADDITIONAL INFORMATION:
> The SQL server specified in SSIS service configuration is not present or is
> not available. This might occur when there is no default instance of SQL
> Server on the computer. For more information, see the topic "Configuring the
> Integration Services Service" in Server 2005 Books Online.
> Login timeout expired
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> TCP Provider: No connection could be made because the target machine
> actively refused it. (MsDtsSrvr)
> --
> My sql server is clustered and SSIS is clustered also.
> Thanks in advance!
> --
> Yuhong
|||SSIS is in the same resource group as the SQL Server. I think it is a named
instance in the cluster. I don't think I have a default instance configured
in the cluster. Is there a work around so I can expand the msdb with out
reconfigure the servers?
Thanks for helping!
Yuhong
"mrdenny" wrote:
[vbcol=seagreen]
> Is SSIS in the same resource group as the SQL Server? Is the SQL Server the
> default instance or a named instance?
> --
> Denny
> MCSA (2003) / MCDBA (SQL 2000)
> MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
> Microsoft Office SharePoint Server 2007: Configuration)
> MCITP (dbadmin, dbdev)
>
> "Yuhong" wrote:
|||This is a fairly easy fix, I actually just posted a blog entry walking
through the fix. The problem is that SSIS is not clusterable, and the
config files on the active node are pointing MSDB to the node itself.
The config files need to point to the cluster name.
http://www.sqlstop.com/index.php/2007/07/16/clusters-last-stand/
That details exactly how to fix the problem.
Thanks,
Shawn
*** Sent via Developersdex http://www.codecomments.com ***
|||Shawn,
Thanks so much for the information. I got it working. I almost gave up and
decided to store everything in File System.
It is surprising that there are not much informaton about this online, at
least I did not find any. Thanks again!!!!
Yuhong
"Shawn m" wrote:

> This is a fairly easy fix, I actually just posted a blog entry walking
> through the fix. The problem is that SSIS is not clusterable, and the
> config files on the active node are pointing MSDB to the node itself.
> The config files need to point to the cluster name.
> http://www.sqlstop.com/index.php/2007/07/16/clusters-last-stand/
> That details exactly how to fix the problem.
> Thanks,
> Shawn
> *** Sent via Developersdex http://www.codecomments.com ***
>
|||*** Sent via Developersdex http://www.codecomments.com ***
sql

Cannot Connect to the Analysis Server

I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in
an ASP.NET page.
Here's my sample code:
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoCube As DSO.MDStore
dsoServer.Connect ("LocalHost")
For Each dsoDB In dsoServer.MDStores
If dsoDB.Name = "XXX" Then
For Each dsoCube In dsoDB.MDStores
Debug.Print dsoCube.Name
Next
End If
Next
Here's the message i got:
"System.Runtime.InteropServices.COMException: Cannot
connect to the Analysis server on computer 'J.B.'.
Connection to the server is lost"
I've tried to follow this technical article but still result the same.
http://support.microsoft.com/default.aspx?kbid=823066
Any idea? Or is there any other way i can get what i want, other that connec
ting to DSO? I've been stuck with this problem for days. hope i can find a n
ew way to solve this.
Thnx in advanced.
J.B.I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...

quote:

---

> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoServer As New DSO.Server
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> dsoServer.Connect ("LocalHost")
> For Each dsoDB In dsoServer.MDStores
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> Here's the message i got:
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> I've tried to follow this technical article but still result the same.
> http://support.microsoft.com/default.aspx?kbid=823066
> Any idea? Or is there any other way i can get what i want, other that conn
ecting to DSO? I've been stuck with this problem for days. hope i can find a
new way to solve this.
> Thnx in advanced.
> J.B.

---

|||Thanks for your advice.
It works now.
~~
J.B.
-- bmal wrote: --
I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...[QUOTE]
> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> http://support.microsoft.com/default.aspx?kbid=823066
> Thnx in advanced.

Cannot connect to FTP Site (Merge replication)

Hi;
We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber
are able to retrieve the subscription and replication. The error message on
the failing subscriber is "The computer is disconnected from the network".
The computer runs XP Pro like most of the others and is connected via a VPN
like the others.
The schema script '' could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not connect to FTP site 'PL000' using port 21.
(Source: lachlan (Agent); Error number: 0)
The computer is disconnected from the network
(Source: (OS); Error number: 12163)
Any ideas what can cause this? The subscriber that fails was infected with a
virus earlier, but it is now clean the the virus software does not detect
any new or existing virus.
Thomas Born
there are many possibilities
1) the ftp server/site is not active
2) you have specified anonymous only in your ftp server and are trying to
connect using an NT account
3) the ftp server is listening on a different port
4) the snapshot folder does not have read rights for the NT account you are
using or if you are using anonymous authentication to the IUSER_MachineName
account
5) You are using an NT account that does not exist on the machine hosting
the FTP server.
6) your subscriber is on the deny acccess IP address list
Return to your publisher and confirm that all of the above is correctly set
up
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> Hi;
> We have mulitple clients (subscribers) with MSDE SP3. All but one
subsriber
> are able to retrieve the subscription and replication. The error message
on
> the failing subscriber is "The computer is disconnected from the network".
> The computer runs XP Pro like most of the others and is connected via a
VPN
> like the others.
>
> The schema script '' could not be propagated to the subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
--
> --
> The process could not connect to FTP site 'PL000' using port 21.
> (Source: lachlan (Agent); Error number: 0)
> ----
--
> --
> The computer is disconnected from the network
> (Source: (OS); Error number: 12163)
> ----
--
> --
> Any ideas what can cause this? The subscriber that fails was infected with
a
> virus earlier, but it is now clean the the virus software does not detect
> any new or existing virus.
> Thomas Born
>
|||Thanks for the respone,
I am using anonymous authentication from all the other subscribers as well
and they are working. Also very sure that the server listens on 21. Need to
check 6) but I don't think it is a problem.
I have tested it with having two different machines as the subscriber on my
network at home. One is working and the other one gets the computer
disconnected message. I am getting close to reinstall the operating system
on the failing subscriber, will see if that fixes the problem.
Thomas
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
> there are many possibilities
> 1) the ftp server/site is not active
> 2) you have specified anonymous only in your ftp server and are trying to
> connect using an NT account
> 3) the ftp server is listening on a different port
> 4) the snapshot folder does not have read rights for the NT account you
are
> using or if you are using anonymous authentication to the
IUSER_MachineName
> account
> 5) You are using an NT account that does not exist on the machine hosting
> the FTP server.
> 6) your subscriber is on the deny acccess IP address list
> Return to your publisher and confirm that all of the above is correctly
set[vbcol=seagreen]
> up
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Thomas Born" <tborn_news@.hotmail.com> wrote in message
> news:u2gIGJYZEHA.3564@.TK2MSFTNGP11.phx.gbl...
> subsriber
> on
network".[vbcol=seagreen]
> VPN
> ----
> --
> ----
> --
> ----
> --
with[vbcol=seagreen]
> a
detect
>
|||Re-installing the operating system to fix ftp is radical.
Can you open up IE, and in the address bar connect to the ftp site on the
publisher. What do the ftp logs on the publisher reveal?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Born" <tborn_news@.hotmail.com> wrote in message
news:eWZ00$%23ZEHA.3708@.TK2MSFTNGP10.phx.gbl...
> Thanks for the respone,
> I am using anonymous authentication from all the other subscribers as well
> and they are working. Also very sure that the server listens on 21. Need
to
> check 6) but I don't think it is a problem.
> I have tested it with having two different machines as the subscriber on
my[vbcol=seagreen]
> network at home. One is working and the other one gets the computer
> disconnected message. I am getting close to reinstall the operating system
> on the failing subscriber, will see if that fixes the problem.
> Thomas
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OFyXETaZEHA.3012@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> are
> IUSER_MachineName
hosting[vbcol=seagreen]
> set
message[vbcol=seagreen]
> network".
a[vbcol=seagreen]
number: -2147201001)
> ----
> ----
> ----
> with
> detect
>