My evaluation copy ran-out and I uninstlaled the previous and installed anothrer evaluation edition. The installation was successful. I created a SSIS package importing a tale from Oracle 10G XE to the SQL 2005 on my machine. I saved the package on the server. The SSIS service is working but when I try to refresh the node, I get this message. The help linl leads to no where:
--
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
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. (Microsoft SQL Native Client)
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. (Microsoft SQL Native Client)
My efforts so far:
I have verified the items in the Surface area screen, everythign looks good.
SSIS service has started.
Both teh Network Server TCP/IP dynmaic port and the SQL Client TCP/IP dynamic port are the same.
I have no problem logging in to any of the services. But I get this message.
I tried to create a package from Visual Studio, but that also did not succeed.
In my previous set up, I created perhaps 1/ 2 dozen different packages.
I am puzzzled.
I appreciate if some one could throw some light.
If you could get the function call stack when the error occurs, that would help diagnose the problem. At the bottom of the exception message box, there is a little icon with a tooltip like "technical details" which displays this information.
Also, if you could provide more specific steps to reproduce the problem, that would help too. Are you using SSIS when you get this problem, or some Management Studio UI that uses SSIS, like the Copy Database Wizard? You can get more specific SSIS configuration help in the SSIS forum here: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1
Thanks,
Steve
没有评论:
发表评论