Named Pipes Provider

Hi!

I tryed to make an silent mode install for SQL express edition, for example:

start/ wait setup.exe /qn ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=***** SQLBROWSERAUTOSTART=1 DISABLENETWORKPROTOCOLS=0

When i run it from a .bat file it's ok but i'm using this command in a .ini file in some apllication.
It doesn't install all the SQL, i mean in services it appears only SQL Server VSS Writer.
I also get the error Named Pipes Provider. The application that i want to install gets installed but can't connect to server.
I really need some help.

Seems your server is not installed at all. If no server is running, you will see the Named Pipes Provider error. So, make your server is installed first. How do you initiate the setup from a .ini file?

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,
>

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,
>

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,
>

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...
>

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

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...
>

My host runs SQL Server 2000, i have SQL Server 2005. What to do?

Hi,

the title of this topic about summarises it. I have a dev-machine with SQL Server 2005 Standard edition on it. My host runs SQL Server 2000. What are my options?

Is there some sort of backward compatibility? Can i export as 2000?

I have no idea and i can't find anything about this particular problem.

Thanks

2 solutions:

Move your database to SQL Server 2000 or|||

The possibility to script the database/objects makes it rather easy to generate a script in SQL 2005 and run the script in SQL 2000 Query Analyzer.

There is a feature (dropdownbox) that is named : Script for version.

If you select SQL Server 2000, you'll eliminate many of the SQL 2005 specific commands.

Clientwise... You have to use the SQL provider, I don't think the NAtive provider for 2005 works with 2000 (please feel free to prove me wrong on this...)

/micke

|||The main difference SQL Server 2000 uses TDS(tabular data stream) 80 while SQL Server 2005 uses TDS 90 but SQL Server 2005 also require file groups in the create table statement, so you can create a blank database in SQL Server 2000 and do INSERT INTO with column list per table which gives you control of the insert. The other alternative is to look for SQL Server 2005 hosting provider. Hope this helps.