Turn off server state in Management Studio

23 Nov 2005 4:05 PM

Allan

Hi,

Does anyone know how I can prevent Management Studio from connecting to all
my "Registered Servers" to populate the server state (running or stopped). In
Enterprise Manager it was possible to uncheck the "Display SQL Server state
in console" under Properties for each server but I can't find the
corresponding option in Management Studio.

Regards, Allan

24 Nov 2005 7:12 AM

Sophie Guo [MSFT]

Hello,

I didn't find the option in the management studio, I will do more research
on it and let you know the update.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

29 Nov 2005 9:51 AM

Allan

Hi Sophie!

Any news on this subject? It would really be helpful if there was a way to
disable this since I have a lot of servers registered (100+) and it causes me
and my colleagues some trouble when Management Studio tries to connect to all
these servers.

Regards, Allan

Show quote

"Sophie Guo [MSFT]" wrote:

> Hello,
>
> I didn't find the option in the management studio, I will do more research
> on it and let you know the update.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

29 Nov 2005 12:40 PM

Sophie Guo [MSFT]

Hello Allan,

Based on my further test, to disconnect from a registered server, you can
perform the following steps:

In Object Explorer, right-click a server and click Disconnect or, on the
Object Explorer toolbar, click the Disconnect icon.

http://msdn2.microsoft.com/en-us/library/ms179570(en-US,SQL.90).aspx

I test the issue on my side by performing the following steps:

1. Register a SQL server instance from a client machine.
2. On the SQL server installed machine, right-click the Activity Monitor >
Click "View Processes". Find a process ID which the client machine used to
connect to SQL server.
3. Disconnect the connection from the client machine. Restart the SQL
management studio on the client machine.
4. Notice that SQL server instance is registered on the client machine. But
it is disconnected.
5. On the SQL server installed machine, refresh the connected processes.
The process which the client machine used to connect to SQL server doesn't
appear.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

29 Nov 2005 1:01 PM

Allan

Hi Sophie,

I think that you have misunderstood my question. I wasn't talking about the
Object Explorer but about the Registered Servers and I know it doesn't
connect to SQL Server but it does connect to Windows to check if the SQL
Server service is started or not and that is what I want to prevent.

In SQL Server 2000 Enterprise Manager it was possible to uncheck the
"Display SQL Server state in console" under Properties for each server to
prevent it from connecting to the server to check if the service is started.
Is it possible to do the exact same thing in Management Studio?

-Allan

Show quote

"Sophie Guo [MSFT]" wrote:

> Hello Allan,
>
> Based on my further test, to disconnect from a registered server, you can
> perform the following steps:
>
> In Object Explorer, right-click a server and click Disconnect or, on the
> Object Explorer toolbar, click the Disconnect icon.
>
> http://msdn2.microsoft.com/en-us/library/ms179570(en-US,SQL.90).aspx
>
> I test the issue on my side by performing the following steps:
>
> 1. Register a SQL server instance from a client machine.
> 2. On the SQL server installed machine, right-click the Activity Monitor >
> Click "View Processes". Find a process ID which the client machine used to
> connect to SQL server.
> 3. Disconnect the connection from the client machine. Restart the SQL
> management studio on the client machine.
> 4. Notice that SQL server instance is registered on the client machine. But
> it is disconnected.
> 5. On the SQL server installed machine, refresh the connected processes.
> The process which the client machine used to connect to SQL server doesn't
> appear.
>
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

30 Nov 2005 3:08 AM

Sophie Guo [MSFT]

Hello Allan,

I have searched it for a long time. But I didn't find a similar option as
the option "Display SQL Server state in console" in SQL 2000. It appears
that this option is not available in SQL server 2005.

You are welcome to send suggestions for product enhancements that you would
like to see in future versions of Microsoft products to us by submitting a
product feedback. To send a comment or suggestion via the Web, use one of
the following methods:

1. Access MSDN Product Feedback Center
(http://lab.msdn.microsoft.com/productfeedback/default.aspx ).
2. Use the Send Feedback option from the Community menu in Management
Studio.

By submitting your concern to Product Feedback Center, you can get your
voice into the design plans for upcoming versions. Microsoft takes customer
requests and suggestions very seriously. Product Feedback Center is your
voice to the development team. A significant number of the design change
requests come from our customers through the web site. I encourage you to
submit this request.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.