As I understand it, the slammer virus took advantage of port 1434 which is e
nabled over udp for sql clients to find out the ports named instances are us
ing. If applying sp3a disables listening on port 1434, can named instances s
till be used? Do the ports
need to be known and hardcoded in advance?
TIA,
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||Thanks Wayne,
so if I enable 1434, does this open me up to the slammer virus still?
TIA,
John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown
Showing posts with label access. Show all posts
Showing posts with label access. Show all posts
Monday, March 26, 2012
named instances and sp3a - how to enable access?
As I understand it, the slammer virus took advantage of port 1434 which is enabled over udp for sql clients to find out the ports named instances are using. If applying sp3a disables listening on port 1434, can named instances still be used? Do the ports need to be known and hardcoded in advance
TIA
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown
TIA
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown
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...
>
Named Instance
I couldn't connect to named instance in my client machine... I recieved the
error messange.. SQL Server Doesn't exist or Access denied. Can any one
guide me...
Thanks
See if this helps?
http://support.microsoft.com/default...265808&sd=tech
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Roy" <roy@.hotmail.com> wrote in message
news:eVq00F$hFHA.500@.TK2MSFTNGP09.phx.gbl...
>I couldn't connect to named instance in my client machine... I recieved the
> error messange.. SQL Server Doesn't exist or Access denied. Can any one
> guide me...
> Thanks
>
>
sql
error messange.. SQL Server Doesn't exist or Access denied. Can any one
guide me...
Thanks
See if this helps?
http://support.microsoft.com/default...265808&sd=tech
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Roy" <roy@.hotmail.com> wrote in message
news:eVq00F$hFHA.500@.TK2MSFTNGP09.phx.gbl...
>I couldn't connect to named instance in my client machine... I recieved the
> error messange.. SQL Server Doesn't exist or Access denied. Can any one
> guide me...
> Thanks
>
>
sql
Wednesday, March 21, 2012
n00b question: Connecting to SQL Server at ISP?
Hey all, sorry for asking such a grunt question, and thanks in advance
for any help...
for any help...
My hosting ISP offers access to their MS-SQL database, and my
understanding is that it's generally simplest to use some sort of
client app to do stuff like adding tables and whatnot.
SQL Server includes Enterprise Manager, but since my ISP is running the
server, I don't need my own copy of SQL Server, just the client.
Any tips? I couldn't seem to find an appropriate download on the
Microsoft site...
thanks again, -Scottturnstyle (scott@.turnstyle.com) writes:
> Hey all, sorry for asking such a grunt question, and thanks in advance
> for any help...
> My hosting ISP offers access to their MS-SQL database, and my
> understanding is that it's generally simplest to use some sort of
> client app to do stuff like adding tables and whatnot.
> SQL Server includes Enterprise Manager, but since my ISP is running the
> server, I don't need my own copy of SQL Server, just the client.
> Any tips? I couldn't seem to find an appropriate download on the
> Microsoft site...
You could download Evaluation Edition. I believe that the tools don't
expire. But you may violate some license that way.
Developer Edition is 49 dollars only. Then again, if this is a production
database, I don't know if the license permits use.
As for creating tables, the best is to run T-SQL script. Then
again, the best tool for this is Query Analyzer, which is among
the SQL Server Tools you are looking for.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||So there isn't an authorized way to simply download the client tools in
order to connect to a properly licensed server?
1) Does anybody here know if Evaluation Edition tools expire?
2) Another option seems to be Aqua Data Studio
(http://www.aquafold.com) -- should I use something like that, or stick
with Enterprise Manager and its Query Tool?
3) I think I have a copy of SQL-7 somewhere, I suppose I could use that
client, but are the client tools now much better with 2000?
4) Sorry, one last question -- I actually *tried* to purchase an
upgrade from SQL-7 to SQL-2000 but I couldn't figure out what I was
supposed to get -- any tips on how to actually do that?
thanks again & sorry for so many questions...
-Scott|||turnstyle (scott@.turnstyle.com) writes:
> So there isn't an authorized way to simply download the client tools in
> order to connect to a properly licensed server?
No, I don't think so. But I've directed a question on my Microsoft contacts
to see what the exact status is.
> 2) Another option seems to be Aqua Data Studio
> (http://www.aquafold.com) -- should I use something like that, or stick
> with Enterprise Manager and its Query Tool?
I can comment on any third party tools, as I have not use them. But
indeed that may be the only option.
> 3) I think I have a copy of SQL-7 somewhere, I suppose I could use that
> client, but are the client tools now much better with 2000?
I would expect Query Analyzer from SQL 7 to be able to connect, although
it would be able to handle bigint and sql_variant columns correctly. As
I recall QA in SQL 7 was quite a bleak tool; had I at the time had reason to
work with SQL 7, I would probably have stuck to the 6.5 tools. (As it
turned out, we went directly to SQL 2000.)
EM 7 may be barred from access altogether, but you could always try.
Again, bigint and sql_variant, will not make a huge success. I
can't comment on how much better EM 2000 is than EM 7, but I can't
say I'm overly excited over EM 2000.
> 4) Sorry, one last question -- I actually *tried* to purchase an
> upgrade from SQL-7 to SQL-2000 but I couldn't figure out what I was
> supposed to get -- any tips on how to actually do that?
I guess you would get the edition of SQL 2000 that matches your SQL 7
license. If that's a developer license, I would not expect that there
are any special upgrades available today, since DevEdition been slashed
to 50 USD.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Am 29 Jul 2005 03:28:11 -0700 schrieb turnstyle:
> So there isn't an authorized way to simply download the client tools in
> order to connect to a properly licensed server?
> 1) Does anybody here know if Evaluation Edition tools expire?
> 2) Another option seems to be Aqua Data Studio
> (http://www.aquafold.com) -- should I use something like that, or stick
> with Enterprise Manager and its Query Tool?
For managing SQL-Server there is a nice free Tool here:
http://sqlmanager.net/products/mssql/manager/
look for the Lite version.
bye,
Helmut
N' in criteria ?
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
GinolaThe N denotes that the string is Unicode.
Andrew J. Kelly SQL MVP
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
when comparing a value against a Unicode column, otherwise you will see
performance degradation, as an index may not be used.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
Ginola|||thanks all for helping.
On Mon, 12 Jan 2004 10:52:06 -0000, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
Ginola
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
GinolaThe N denotes that the string is Unicode.
Andrew J. Kelly SQL MVP
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
quote:|||N indicates that the string after it is a Unicode string. Use N prefix, only
> Hi,
> I have new in SQL server. I am using Access for quite a bit. When I
> put the value under Criteria column, in query, It puts N' before the
> value, what's that mean ' Why they have to do it ?
> Thanks
>
> --
> Ginola
when comparing a value against a Unicode column, otherwise you will see
performance degradation, as an index may not be used.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
Ginola|||thanks all for helping.
On Mon, 12 Jan 2004 10:52:06 -0000, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
quote:
>N indicates that the string after it is a Unicode string. Use N prefix, onl
y
>when comparing a value against a Unicode column, otherwise you will see
>performance degradation, as an index may not be used.
Ginola
Monday, March 19, 2012
N' in criteria ?
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
--
GinolaThe N denotes that the string is Unicode.
--
Andrew J. Kelly SQL MVP
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
> Hi,
> I have new in SQL server. I am using Access for quite a bit. When I
> put the value under Criteria column, in query, It puts N' before the
> value, what's that mean ' Why they have to do it ?
> Thanks
>
> --
> Ginola|||N indicates that the string after it is a Unicode string. Use N prefix, only
when comparing a value against a Unicode column, otherwise you will see
performance degradation, as an index may not be used.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
Ginola|||thanks all for helping.
On Mon, 12 Jan 2004 10:52:06 -0000, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>N indicates that the string after it is a Unicode string. Use N prefix, only
>when comparing a value against a Unicode column, otherwise you will see
>performance degradation, as an index may not be used.
--
Ginola
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
--
GinolaThe N denotes that the string is Unicode.
--
Andrew J. Kelly SQL MVP
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
> Hi,
> I have new in SQL server. I am using Access for quite a bit. When I
> put the value under Criteria column, in query, It puts N' before the
> value, what's that mean ' Why they have to do it ?
> Thanks
>
> --
> Ginola|||N indicates that the string after it is a Unicode string. Use N prefix, only
when comparing a value against a Unicode column, otherwise you will see
performance degradation, as an index may not be used.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Ginola" <ginola@.mailcity.om> wrote in message
news:40020c51.6962015@.msnews.microsoft.com...
Hi,
I have new in SQL server. I am using Access for quite a bit. When I
put the value under Criteria column, in query, It puts N' before the
value, what's that mean ' Why they have to do it ?
Thanks
Ginola|||thanks all for helping.
On Mon, 12 Jan 2004 10:52:06 -0000, "Narayana Vyas Kondreddi"
<answer_me@.hotmail.com> wrote:
>N indicates that the string after it is a Unicode string. Use N prefix, only
>when comparing a value against a Unicode column, otherwise you will see
>performance degradation, as an index may not be used.
--
Ginola
Monday, March 12, 2012
Mysterious Access Denied Error
Yesterday afternoon I lost access to my local MSDE 2000 sp3(a?)
instance. Usinig NT or SQL authentication I get an 'access denied'
error when I try to connect. This happened suddenly with no changes
to the server on my part. I've tinkered with the Client Network
Utility settings, from Multiprotocol only, every combination of Multi
protocol, TCP/IP, and named pipes. I've tried connecting with my
network machine name, using (local), and using my IP address (both
127.0.0.1 and my network IP). I've tried connecting from Query
Analyzer on other computers. Of course I've rebooted as well, all to
no avail.
instance. Usinig NT or SQL authentication I get an 'access denied'
error when I try to connect. This happened suddenly with no changes
to the server on my part. I've tinkered with the Client Network
Utility settings, from Multiprotocol only, every combination of Multi
protocol, TCP/IP, and named pipes. I've tried connecting with my
network machine name, using (local), and using my IP address (both
127.0.0.1 and my network IP). I've tried connecting from Query
Analyzer on other computers. Of course I've rebooted as well, all to
no avail.
I know that there were network changes being made, but my domain login
(which I normally use to connec to my SQL Server as a sysadmin) is
still in the local administrators group on my machine and I haven't
noticed any problems accessing anything else.
Any ideas?MarcosECasa@.yahoo.com (Marcos) wrote in message news:<cf4137bb.0402100934.3c1cc6de@.posting.google.com>...
> Yesterday afternoon I lost access to my local MSDE 2000 sp3(a?)
> instance. Usinig NT or SQL authentication I get an 'access denied'
> error when I try to connect. This happened suddenly with no changes
> to the server on my part. I've tinkered with the Client Network
> Utility settings, from Multiprotocol only, every combination of Multi
> protocol, TCP/IP, and named pipes. I've tried connecting with my
> network machine name, using (local), and using my IP address (both
> 127.0.0.1 and my network IP). I've tried connecting from Query
> Analyzer on other computers. Of course I've rebooted as well, all to
> no avail.
> I know that there were network changes being made, but my domain login
> (which I normally use to connec to my SQL Server as a sysadmin) is
> still in the local administrators group on my machine and I haven't
> noticed any problems accessing anything else.
> Any ideas?
At the risk of asking a silly question, have you checked that the
service is actually running, using NET START for example? If the
service is stopped, then you get the error "SQL Server does not exist
or access denied", whereas if your login is incorrect (security
issue), you would normally get a "Login failed" error instead.
Simon
Friday, March 9, 2012
MYSQL error
While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RB
This is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/d...displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RB
This is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/d...displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
MYSQL error
While installing mysql server on a Windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/...&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/...&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
MYSQL error
While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
MySQL 5.0 Views wont work with crystal reports
I can access my view data through the application, but when i try to create the report in crytal reports and set up the database through an odbc driver 3.51.
If i click on a normal table its fine, but with the views it says
"Error Opening File: There are no fields in the file: "[View name]".Hi,
I've got a similar problem but using a stored proc. (See earlier posting for more info)
After much hair-pulling and soul searching i think that their might be a compatibility problem with MySQL5, MyODBC 3.51 and Crystal.
Have you tried MyODBC 5.0 yet? If it installs and works on yr side that might take yr problem away. And if it does, please let us know what you did cause it dont wanna install here.
Thanks and good luck|||Thanks
I have tried the 5.0 ODBC Connector, but unfortunatly i had no joy. Still the same error.
If i click on a normal table its fine, but with the views it says
"Error Opening File: There are no fields in the file: "[View name]".Hi,
I've got a similar problem but using a stored proc. (See earlier posting for more info)
After much hair-pulling and soul searching i think that their might be a compatibility problem with MySQL5, MyODBC 3.51 and Crystal.
Have you tried MyODBC 5.0 yet? If it installs and works on yr side that might take yr problem away. And if it does, please let us know what you did cause it dont wanna install here.
Thanks and good luck|||Thanks
I have tried the 5.0 ODBC Connector, but unfortunatly i had no joy. Still the same error.
Wednesday, March 7, 2012
My XP Client doesn't access SQL Server 2000
Hi,
I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don’t connect to database thru my application. It gives error as follows.
Runtime error
Login Failed for user ‘(null)’ . Reason: Not associated with a trusted SQL Connection.
Can anyone help me?
Regards
Ahmed Sahib
the server needs an nt login
you are connecting with an expectation to connect to a server in mixed server mode
to do:
1. configure the system to use mixed authentication
right click the server in the enterprise manager>click on properties> security
in the authentication option choose sql server and windows
or
2. change your connection string to use an nt login
|||
What kind of login is used by your application to connect to the database? Are all your clients within the same domain?
Thanks
Laurentiu
Thanks Mr.Joe for your promp reply. My Server has mixed authentication.
I can ping; browse the server from my XP client. So there is no trouble in my network connection settings.
|||
Thanks Mr. Laurentiu Cristofor
Yes, My All clients are in the same domain. Kindly read my previous post.
Thanks
Ahmed Sahib
|||Are your clients in the same domain as the server? Are you sure that they are attempting to connect using SQL Authentication and not using Windows authentication?
Thanks
Laurentiu
My store procedure returns 2 grids HELP
How do I access the 2nd grid/table in my report?
Basically I have a SP that has a SUM in one grid. The second grid
cotains the data I want to display in RS. Is there a way to get to the
2nd grid without altering the store procedure(Its being used on another
report)?
regards,
Stas K.I just found a similar topic where it says I cannot do this.
Any ideas?|||No, RS can only take a single resultset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136923749.664965.81380@.z14g2000cwz.googlegroups.com...
> How do I access the 2nd grid/table in my report?
> Basically I have a SP that has a SUM in one grid. The second grid
> cotains the data I want to display in RS. Is there a way to get to the
> 2nd grid without altering the store procedure(Its being used on another
> report)?
> regards,
> Stas K.
>
Basically I have a SP that has a SUM in one grid. The second grid
cotains the data I want to display in RS. Is there a way to get to the
2nd grid without altering the store procedure(Its being used on another
report)?
regards,
Stas K.I just found a similar topic where it says I cannot do this.
Any ideas?|||No, RS can only take a single resultset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136923749.664965.81380@.z14g2000cwz.googlegroups.com...
> How do I access the 2nd grid/table in my report?
> Basically I have a SP that has a SUM in one grid. The second grid
> cotains the data I want to display in RS. Is there a way to get to the
> 2nd grid without altering the store procedure(Its being used on another
> report)?
> regards,
> Stas K.
>
Saturday, February 25, 2012
My SQL application on Windows Mobile 5
Hi
Ok Darren
My application :
On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB
I synchronise my DBs through ActivSync.
It runs good before Windows Mobile 5.
My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.
So what are my solutions ?
My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....
Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?
Jo?l
Joel,
You're at the end of the road with eVB. You are going to need to move your mobile application's code either to the .NET Compact Framework or use Visual C++ for Mobile Devices (in VS2005) to achieve Windows Mobile 5 compliance. I recommend using SQL Mobile for your on-device database as a replacement for Pocket Access. Sorry there isn't better news, but eVB and Access have reached the end of their support time horizon for current and future Windows Mobile platforms.
-Darren
|||Ok Darren
So if I move my application to .Net et use SQL Mobile 2005 on my PocketPC, what do I need to synchronise my PocketPC's database (so SQL Mobile) and my PC Database ?
Which database on PC ?
Each PocketPC will have his own PC and his own database, and it have to run my application on Windows XP Home.
What solution for synchronisation ?
Thanks for your explanations
Jo?l
|||Any solution ?
Jo?l
|||
Joel,
SQL Mobile comes with two options for data synchronization, Remote Data Access and Merge Replication. Both of these require IIS as the broker or gateway through which this synchronization occurs. In your situation, you may want to write a simple synchronization method that detects when the device is connected and uses System.Data.SqlClient to synchronize between your device database and SQL Server 2005.
-Darren
|||Ok Darren, thks.Is there a place where I can find some example of this method ?
My SQL application on Windows Mobile 5
Hi
My application :
On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB
I synchronise my DBs through ActivSync.
It runs good before Windows Mobile 5.
My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.
So what are my solutions ?
My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....
Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?
Jo?l
Joel,
You're at the end of the road with eVB. You are going to need to move your mobile application's code either to the .NET Compact Framework or use Visual C++ for Mobile Devices (in VS2005) to achieve Windows Mobile 5 compliance. I recommend using SQL Mobile for your on-device database as a replacement for Pocket Access. Sorry there isn't better news, but eVB and Access have reached the end of their support time horizon for current and future Windows Mobile platforms.
-Darren
|||
Ok Darren
So if I move my application to .Net et use SQL Mobile 2005 on my PocketPC, what do I need to synchronise my PocketPC's database (so SQL Mobile) and my PC Database ?
Which database on PC ?
Each PocketPC will have his own PC and his own database, and it have to run my application on Windows XP Home.
What solution for synchronisation ?
Thanks for your explanations
Jo?l|||Any solution ?
Jo?l|||
Joel,
SQL Mobile comes with two options for data synchronization, Remote Data Access and Merge Replication. Both of these require IIS as the broker or gateway through which this synchronization occurs. In your situation, you may want to write a simple synchronization method that detects when the device is connected and uses System.Data.SqlClient to synchronize between your device database and SQL Server 2005.
-Darren
|||Ok Darren, thks.
Is there a place where I can find some example of this method ?
My Report feature
Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?
Yes. You do not have to use the "My Reports" function at all. Just create a folder for each user under the Home folder and then assign them at least browser rights to that folder. Also, be sure they have browser rights to the Home folder or they will not be able to see their own folder as this follows a hierachial structure.
Subscribe to:
Posts (Atom)