I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,
If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some references
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabled
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Wednesday, March 28, 2012
Named Pipes
I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some reference
s
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabl
ed
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some reference
s
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabl
ed
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>
Named Pipes
I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some references
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabled
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some references
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabled
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>
Monday, March 26, 2012
named instance installed no access to perf. counters ?
Hi,
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
Friday, March 23, 2012
named instance installed no access to perf. counters ?
Hi,
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>> Hi,
>> on a server I have installed SQL 2005 Enterprise Edition x64
>> Its a named instance and there is no default instance deployed.
>> if I try to access some performance counters, I can't add them. the ADD
>> button is disabled.
>> some counters works fines, but others like "Active Transactions" can't be
>> added while the active temp tables counter can be added.
>> I think only counters where an instance (ie a database in the SQL Server
>> instance) option must be selected doesn't works.
>> I have installed the SP2 and this don't solve the issue.
>> any idea?
>> Thanks.
>> Jerome.
>|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>> Hi,
>> on a server I have installed SQL 2005 Enterprise Edition x64
>> Its a named instance and there is no default instance deployed.
>> if I try to access some performance counters, I can't add them. the ADD
>> button is disabled.
>> some counters works fines, but others like "Active Transactions" can't be
>> added while the active temp tables counter can be added.
>> I think only counters where an instance (ie a database in the SQL Server
>> instance) option must be selected doesn't works.
>> I have installed the SP2 and this don't solve the issue.
>> any idea?
>> Thanks.
>> Jerome.
>sql
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>> Hi,
>> on a server I have installed SQL 2005 Enterprise Edition x64
>> Its a named instance and there is no default instance deployed.
>> if I try to access some performance counters, I can't add them. the ADD
>> button is disabled.
>> some counters works fines, but others like "Active Transactions" can't be
>> added while the active temp tables counter can be added.
>> I think only counters where an instance (ie a database in the SQL Server
>> instance) option must be selected doesn't works.
>> I have installed the SP2 and this don't solve the issue.
>> any idea?
>> Thanks.
>> Jerome.
>|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>> Hi,
>> on a server I have installed SQL 2005 Enterprise Edition x64
>> Its a named instance and there is no default instance deployed.
>> if I try to access some performance counters, I can't add them. the ADD
>> button is disabled.
>> some counters works fines, but others like "Active Transactions" can't be
>> added while the active temp tables counter can be added.
>> I think only counters where an instance (ie a database in the SQL Server
>> instance) option must be selected doesn't works.
>> I have installed the SP2 and this don't solve the issue.
>> any idea?
>> Thanks.
>> Jerome.
>sql
named instance installed no access to perf. counters ?
Hi,
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.
Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>
|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.
Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>
|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>
Wednesday, March 21, 2012
Name Lookup of Enterprise Manager
Hello!
I have noticed a strange behaviour of Enterprise Manager (or every
program to connect to SQL Server; as in Visual Studio, Query Analyser
and ODBC-Connection Manager), which I cannot get sorted out.
I try to connect to an MSDE-Instance on a clients' Server. The Server
has, for our Maintenance, a dial-up connection with dynamic IP and
runs a service to keep the IP up-to-date, so we can access it by
servername.dyndns.org.
I can ping the server and I can connect to it in pcAnywhere (using the
dyndns.org lookup).
If I try to connect to the MSDE as servername.dyndns.org\Instance, I
get an error: Server not found: Connection.Open(Connect()).
Trying to make an ODBC-Connection gives some numbers on the error:
SQLState: 01000
Server Error: 11004
followed by
SQLState: 08001
Server Error: 6
I can connect to MSDE by using the IP a ping gave me,
1.2.3.4\Instance.
Username and Password must be correct, because a connection with
IP\Instance works fine for the IP looked up a second ago. So my
Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
but not for sql server?
I wonder if someone can give a hint on that on... looking Google
Groups and Knowledge base for the last 2 hours wasn't helpful...
Thanks!Sorry, but since nobody answered, and I really need a little help
here, I *bumped* this one up again.
> Hello!
> I have noticed a strange behaviour of Enterprise Manager (or every
> program to connect to SQL Server; as in Visual Studio, Query Analyser
> and ODBC-Connection Manager), which I cannot get sorted out.
> I try to connect to an MSDE-Instance on a clients' Server. The Server
> has, for our Maintenance, a dial-up connection with dynamic IP and
> runs a service to keep the IP up-to-date, so we can access it by
> servername.dyndns.org.
> I can ping the server and I can connect to it in pcAnywhere (using the
> dyndns.org lookup).
> If I try to connect to the MSDE as servername.dyndns.org\Instance, I
> get an error: Server not found: Connection.Open(Connect()).
> Trying to make an ODBC-Connection gives some numbers on the error:
> SQLState: 01000
> Server Error: 11004
> followed by
> SQLState: 08001
> Server Error: 6
> I can connect to MSDE by using the IP a ping gave me,
> 1.2.3.4\Instance.
> Username and Password must be correct, because a connection with
> IP\Instance works fine for the IP looked up a second ago. So my
> Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
> but not for sql server?
> I wonder if someone can give a hint on that on... looking Google
> Groups and Knowledge base for the last 2 hours wasn't helpful...
> Thanks!
I have noticed a strange behaviour of Enterprise Manager (or every
program to connect to SQL Server; as in Visual Studio, Query Analyser
and ODBC-Connection Manager), which I cannot get sorted out.
I try to connect to an MSDE-Instance on a clients' Server. The Server
has, for our Maintenance, a dial-up connection with dynamic IP and
runs a service to keep the IP up-to-date, so we can access it by
servername.dyndns.org.
I can ping the server and I can connect to it in pcAnywhere (using the
dyndns.org lookup).
If I try to connect to the MSDE as servername.dyndns.org\Instance, I
get an error: Server not found: Connection.Open(Connect()).
Trying to make an ODBC-Connection gives some numbers on the error:
SQLState: 01000
Server Error: 11004
followed by
SQLState: 08001
Server Error: 6
I can connect to MSDE by using the IP a ping gave me,
1.2.3.4\Instance.
Username and Password must be correct, because a connection with
IP\Instance works fine for the IP looked up a second ago. So my
Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
but not for sql server?
I wonder if someone can give a hint on that on... looking Google
Groups and Knowledge base for the last 2 hours wasn't helpful...
Thanks!Sorry, but since nobody answered, and I really need a little help
here, I *bumped* this one up again.
> Hello!
> I have noticed a strange behaviour of Enterprise Manager (or every
> program to connect to SQL Server; as in Visual Studio, Query Analyser
> and ODBC-Connection Manager), which I cannot get sorted out.
> I try to connect to an MSDE-Instance on a clients' Server. The Server
> has, for our Maintenance, a dial-up connection with dynamic IP and
> runs a service to keep the IP up-to-date, so we can access it by
> servername.dyndns.org.
> I can ping the server and I can connect to it in pcAnywhere (using the
> dyndns.org lookup).
> If I try to connect to the MSDE as servername.dyndns.org\Instance, I
> get an error: Server not found: Connection.Open(Connect()).
> Trying to make an ODBC-Connection gives some numbers on the error:
> SQLState: 01000
> Server Error: 11004
> followed by
> SQLState: 08001
> Server Error: 6
> I can connect to MSDE by using the IP a ping gave me,
> 1.2.3.4\Instance.
> Username and Password must be correct, because a connection with
> IP\Instance works fine for the IP looked up a second ago. So my
> Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
> but not for sql server?
> I wonder if someone can give a hint on that on... looking Google
> Groups and Knowledge base for the last 2 hours wasn't helpful...
> Thanks!
N Preceding Strings when Scripting Objects
When an Object is scripted in From Enterprise Manager it Precedes
Strings with an "N" however these scripts seem to still work if the N
is removed so I would assume that the "N" has something to do with
collation or the Encoding or something. I've tryed to find something
about it on the net but found nothing, can anyone tell me what it does?
Thanks in Advance.
Example :
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
1) drop table [dbo].[Options]
GON'my string'
The above is a unicode string
'my string'
The above isn't unicode.
Unicode basically stores 2 bytes per character to allow for asian character
sets.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<cameron.waldron@.gmail.com> wrote in message
news:1145530123.392023.62250@.z34g2000cwc.googlegroups.com...
> When an Object is scripted in From Enterprise Manager it Precedes
> Strings with an "N" however these scripts seem to still work if the N
> is removed so I would assume that the "N" has something to do with
> collation or the Encoding or something. I've tryed to find something
> about it on the net but found nothing, can anyone tell me what it does?
> Thanks in Advance.
> Example :
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
> 1) drop table [dbo].[Options]
> GO
>
Strings with an "N" however these scripts seem to still work if the N
is removed so I would assume that the "N" has something to do with
collation or the Encoding or something. I've tryed to find something
about it on the net but found nothing, can anyone tell me what it does?
Thanks in Advance.
Example :
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
1) drop table [dbo].[Options]
GON'my string'
The above is a unicode string
'my string'
The above isn't unicode.
Unicode basically stores 2 bytes per character to allow for asian character
sets.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<cameron.waldron@.gmail.com> wrote in message
news:1145530123.392023.62250@.z34g2000cwc.googlegroups.com...
> When an Object is scripted in From Enterprise Manager it Precedes
> Strings with an "N" however these scripts seem to still work if the N
> is removed so I would assume that the "N" has something to do with
> collation or the Encoding or something. I've tryed to find something
> about it on the net but found nothing, can anyone tell me what it does?
> Thanks in Advance.
> Example :
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
> 1) drop table [dbo].[Options]
> GO
>
Monday, March 19, 2012
N - curious?
Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!The N represents a Unicode string.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!|||See the Books Online topic 'Server-side Programming with Unicode'
(http://msdn2.microsoft.com/en-us/library/ms191313(SQL.90).aspx).
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Looking at an if exists statement created by SQL Enterprise Manager such
> as: if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure')
> = 1), what does the N do? I've seen cases where it is and isn't necessary,
> but I cannot find documentation telling what it does. "N" is a very
> ineffective search!!!
>
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!The N represents a Unicode string.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!|||See the Books Online topic 'Server-side Programming with Unicode'
(http://msdn2.microsoft.com/en-us/library/ms191313(SQL.90).aspx).
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Looking at an if exists statement created by SQL Enterprise Manager such
> as: if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure')
> = 1), what does the N do? I've seen cases where it is and isn't necessary,
> but I cannot find documentation telling what it does. "N" is a very
> ineffective search!!!
>
Subscribe to:
Posts (Atom)