Extended Events (XEvent) in Katmai

In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.

Thanks.

This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.

|||

Thanks for moving the post - I didn't know there were dedicated Katmai forums.

I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.

I would appreciate any other pointers.

Thanks again.

|||

I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.

Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.

Regards,

Gail

|||

Check out the Books Online for the examples...

http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460

Extended Events (XEvent) in Katmai

In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.

Thanks.

This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.

|||

Thanks for moving the post - I didn't know there were dedicated Katmai forums.

I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.

I would appreciate any other pointers.

Thanks again.

|||

I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.

Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.

Regards,

Gail

|||

Check out the Books Online for the examples...

http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460

Expressions still get evaluated even though the task isn't executed

Whilst investigating the problem talked about here: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=118141
I noticed something quite strange.

The symptom of whatever problem we are having (we don't know yet) is that some property expressions fail to get evaluated and cause the package to fail. ALL of these property expressions are in package-scoped eventhandlers.

Now, if I set DisableEventHandlers=TRUE on the package container the problems still occur. If I completely delete the eventhandlers the problem goes away.

So, it seems to me that even though DisableEventHandlers=TRUE, the property expressions within those eventhandlers are still evaluated.

Why is that? Its pointless to evaluate property expressions if they are not going to be used - it means the package is doing unnecassary work.

-JamieAny comments?|||Jamie! So sorry - I review every couple days and just found this. Let me see what I can find out for you.

hold tight.
Andrea|||cool. Thanks Andrea.

Express Manager / Management Studio Express

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express and Reporting Services

Hi,

This thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=179557&SiteID=1 says that Express will have Reporting Services enabled such that reports can be created in Express edition. I have just downloaded Express Edition with Advanced Services but i dont appear to have any of the tools neccessary to create a report using reporting services. ( I do have VS 2005)

Also this URL http://msdn.microsoft.com/vstudio/express/ promotes Express as having Reporting Services and yet this table http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx says just the server is installed.

Can anyone please clarify if I just haven't installed or activated the required functionality to build reports using Express edition or whether there is no such capability with Express edition.

If the latter is the case does this mean that I can still run applications and reporting services reports with Express edition? In other words if I buy standard edition to develop reports, can my customers run my application (i.e reports) with Express edition or do they have to purchase standard edition as well?

Richard

Hi S-Bob

You can dowload the report designer and management studio express with the express edition toolkit:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

You can create reports using standard edition or the toolkit and consumers using express advanced can view them. Note that express has some limitations such as supporting local data sources only.

-JonHP

Exporting SQL 2005 Maintenance Plans on SQL Cluster

I'm trying to export Microsoft SQL 2005 Maintenance plans per the following
article on the MSDN Forums:
http://forums.microsoft.com/MSDN/sh...389484&siteid=1
However I'm 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?Prod...er&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)
BUTTONS:
OK
--
Searching on google I found the following links which explain how to setup
SSIS as a clustered SQL service (which I did):
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
I've also tried the steps outlined in:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx
I'm at a loss... what am I doing wrong?
Thanks
BradI figured out my own problem. It turns out even though I made the registry
change mentioned in this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
The change I originally made didn't take effect - when I refreshed the
registry I noticed the key had reverted back to the original value.
Resetting the key and restarting the Integration Services cluster service
fixed the problem.
Thanks!
Brad
"Brad Baker" <brad@.nospam.nospam> wrote in message
news:u7RdSS16GHA.4404@.TK2MSFTNGP04.phx.gbl...
> I'm trying to export Microsoft SQL 2005 Maintenance plans per the
> following article on the MSDN Forums:
> http://forums.microsoft.com/MSDN/sh...389484&siteid=1
> However I'm 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?Prod...er&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)
> --
> BUTTONS:
> OK
> --
> Searching on google I found the following links which explain how to setup
> SSIS as a clustered SQL service (which I did):
> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
> I've also tried the steps outlined in:
> http://msdn2.microsoft.com/en-us/library/aa337083.aspx
> I'm at a loss... what am I doing wrong?
> Thanks
> Brad
>|||Hi,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============

Exporting SQL 2005 Maintenance Plans on SQL Cluster

I'm trying to export Microsoft SQL 2005 Maintenance plans per the following
article on the MSDN Forums:
http://forums.microsoft.com/MSDN/sho...89484&siteid=1
However I'm 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?ProdN...r&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)
BUTTONS:
OK
Searching on google I found the following links which explain how to setup
SSIS as a clustered SQL service (which I did):
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
I've also tried the steps outlined in:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx
I'm at a loss... what am I doing wrong?
Thanks
Brad
I figured out my own problem. It turns out even though I made the registry
change mentioned in this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
The change I originally made didn't take effect - when I refreshed the
registry I noticed the key had reverted back to the original value.
Resetting the key and restarting the Integration Services cluster service
fixed the problem.
Thanks!
Brad
"Brad Baker" <brad@.nospam.nospam> wrote in message
news:u7RdSS16GHA.4404@.TK2MSFTNGP04.phx.gbl...
> I'm trying to export Microsoft SQL 2005 Maintenance plans per the
> following article on the MSDN Forums:
> http://forums.microsoft.com/MSDN/sho...89484&siteid=1
> However I'm 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?ProdN...r&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)
> --
> BUTTONS:
> OK
> --
> Searching on google I found the following links which explain how to setup
> SSIS as a clustered SQL service (which I did):
> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
> I've also tried the steps outlined in:
> http://msdn2.microsoft.com/en-us/library/aa337083.aspx
> I'm at a loss... what am I doing wrong?
> Thanks
> Brad
>
|||Hi,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Exporting SQL 2005 Maintenance Plans on SQL Cluster

I'm trying to export Microsoft SQL 2005 Maintenance plans per the following
article on the MSDN Forums:
http://forums.microsoft.com/MSDN/showpost.aspx?postid=389484&siteid=1
However I'm 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)
--
BUTTONS:
OK
--
Searching on google I found the following links which explain how to setup
SSIS as a clustered SQL service (which I did):
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
I've also tried the steps outlined in:
http://msdn2.microsoft.com/en-us/library/aa337083.aspx
I'm at a loss... what am I doing wrong?
Thanks
BradI figured out my own problem. It turns out even though I made the registry
change mentioned in this article:
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
The change I originally made didn't take effect - when I refreshed the
registry I noticed the key had reverted back to the original value.
Resetting the key and restarting the Integration Services cluster service
fixed the problem.
Thanks!
Brad
"Brad Baker" <brad@.nospam.nospam> wrote in message
news:u7RdSS16GHA.4404@.TK2MSFTNGP04.phx.gbl...
> I'm trying to export Microsoft SQL 2005 Maintenance plans per the
> following article on the MSDN Forums:
> http://forums.microsoft.com/MSDN/showpost.aspx?postid=389484&siteid=1
> However I'm 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)
> --
> BUTTONS:
> OK
> --
> Searching on google I found the following links which explain how to setup
> SSIS as a clustered SQL service (which I did):
> http://msdn2.microsoft.com/en-us/library/ms345193.aspx
> I've also tried the steps outlined in:
> http://msdn2.microsoft.com/en-us/library/aa337083.aspx
> I'm at a loss... what am I doing wrong?
> Thanks
> Brad
>|||Hi,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================