Not able to connect MSDB database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Not able to connect MSDB database

Author

Topic

satishvsh
Starting Member

41 Posts

Posted - 2008-06-19 : 11:06:13

Friends -

I am not able to connect to MSDB database under SQL Server 2005 Integration services. i am getting the following error.

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:

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.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (MsDtsSrvr)

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

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.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)

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

OK

Please advise on this.

cheers :)
Satish

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 11:11:13

SSIS 2005 services works on Default instances .Also enable connections in SQL surface 2005 area Config.

satishvsh
Starting Member

41 Posts

Posted - 2008-06-19 : 11:47:59

quote:
Originally posted by sodeep

SSIS 2005 services works on Default instances .Also enable connections in SQL surface 2005 area Config.

How to enable integration services connections if it is on cluster environment.

cheers:)
satish

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-19 : 11:56:15

[/quote]
How to enable integration services connections if it is on cluster environment.
cheers:)
satish
[/quote]

Please go thru this link. http://blog.sqlauthority.com/2007/10/13/sql-server-2005-sql-server-surface-area-configuration-tool-examples-and-explanation/

Manoj
MCP, MCTS

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-21 : 17:03:42

The link is nothing to do with this issue.

>> How to enable integration services connections if it is on cluster environment.

You can modify C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml to specify correct sql instence name on all nodes in the cluster.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources