Showing posts with label ent. Show all posts
Showing posts with label ent. Show all posts

Monday, March 26, 2012

Is this possible

Hi,
Is it possible to hide an instance of SQL Server so that it doesn't show up
when you open Ent Manager or SQL Query Analyser?
Thanks
Using the Server Network Utility, you can check the 'hide server' box under
the network protocol properties.
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
> up
> when you open Ent Manager or SQL Query Analyser?
> Thanks
|||Why do you want to do that? You could stop the service if you would like to.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
up
> when you open Ent Manager or SQL Query Analyser?
> Thanks

Friday, March 23, 2012

Is this possible

Hi,
Is it possible to hide an instance of SQL Server so that it doesn't show up
when you open Ent Manager or SQL Query Analyser?
ThanksUsing the Server Network Utility, you can check the 'hide server' box under
the network protocol properties.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
> up
> when you open Ent Manager or SQL Query Analyser?
> Thanks|||Why do you want to do that? You could stop the service if you would like to.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
up
> when you open Ent Manager or SQL Query Analyser?
> Thanks

Is this possible

Hi,
Is it possible to hide an instance of SQL Server so that it doesn't show up
when you open Ent Manager or SQL Query Analyser?
ThanksUsing the Server Network Utility, you can check the 'hide server' box under
the network protocol properties.
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
> up
> when you open Ent Manager or SQL Query Analyser?
> Thanks|||Why do you want to do that? You could stop the service if you would like to.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4B7E30BD-A02B-42A1-8B97-03EC5C70A584@.microsoft.com...
> Hi,
> Is it possible to hide an instance of SQL Server so that it doesn't show
up
> when you open Ent Manager or SQL Query Analyser?
> Thanks

Friday, February 24, 2012

Is there any reported issues running SQL Server 2005 Enterprise 64bit Management Studio version?

At the moment I'm trying to find out if there are any reported issues with Management Studio running on a SQL Server 2005 Ent 64bit edition?

Can anyone help?

My reason for asking is really one of curiosity, one of my colleagues has said it doesn't work, I'm trying to research this claim as I do not have access to a 64 bit machine to try it on but would like to move my future project in this direction hence why I'm asking.

Many Thanks.

Dave

Hi Dave,

Technically, there aren't different versions of Management Studio, only 1 (client tools are distributed with all editions, except Express)...though, there are different platform builds (i.e. IA64,x64,x86)...

Management studio with Sql2k5 is fully 64bit compatible, and will run natively on an IA64 or x64 box...

HTH

|||There are issuses with SQL Server 2005 64 bit and the Management Studio that are explained here http://support.microsoft.com/default.aspx/kb/906892.
The Management Studio will run on the 64 bit platform but it will be slow and tend to freeze, the reason being it's still a 32 bit application. MS solution is to run the Management Studio on a 32 bit computer and connect to the SQL server that way. Why they don't have a 64 bit version of the Management Studio is anyone's guess.
RLB

Is there any reported issues running SQL Server 2005 Enterprise 64bit Management Studio version?

At the moment I'm trying to find out if there are any reported issues with Management Studio running on a SQL Server 2005 Ent 64bit edition?

Can anyone help?

My reason for asking is really one of curiosity, one of my colleagues has said it doesn't work, I'm trying to research this claim as I do not have access to a 64 bit machine to try it on but would like to move my future project in this direction hence why I'm asking.

Many Thanks.

Dave

Hi Dave,

Technically, there aren't different versions of Management Studio, only 1 (client tools are distributed with all editions, except Express)...though, there are different platform builds (i.e. IA64,x64,x86)...

Management studio with Sql2k5 is fully 64bit compatible, and will run natively on an IA64 or x64 box...

HTH

|||There are issuses with SQL Server 2005 64 bit and the Management Studio that are explained here http://support.microsoft.com/default.aspx/kb/906892.
The Management Studio will run on the 64 bit platform but it will be slow and tend to freeze, the reason being it's still a 32 bit application. MS solution is to run the Management Studio on a 32 bit computer and connect to the SQL server that way. Why they don't have a 64 bit version of the Management Studio is anyone's guess.
RLB