Cloned Drive

I have a machine named DOG with MSDE (computername=DOG). I clone the machine
to another and rename the machine CAT. When I do this, SQL Server reports
"Your SQL Server installation is either corrupt or has been tampered with
(unknown package id). Please rerun setup." I understand why this happens,
the computername changed.
Is there a way to change the package id to work with the new computername?
Of course I can reinstall MSDE, but that defeats the mai purpose of the
clone.
TIA,
Will
hi Will,
Will T wrote:
> I have a machine named DOG with MSDE (computername=DOG). I clone the
> machine to another and rename the machine CAT. When I do this, SQL
> Server reports "Your SQL Server installation is either corrupt or has
> been tampered with (unknown package id). Please rerun setup." I
> understand why this happens, the computername changed.
> Is there a way to change the package id to work with the new
> computername? Of course I can reinstall MSDE, but that defeats the
> mai purpose of the clone.
to the best of my knowledge, this was a problem with SQL Server 7.0 and MSDE
1.0(http://support.microsoft.com/default...b;en-us;229875), as SQL
Server 7.0 could be "managed" rerunning the setup (
http://databasejournal.com/features/...0894_2194711_3 ),
where no work around was available for MSDE 1.0...
for SQL Server 2000, if you change the computer name, you only need to
delete and re-create the server registration in Enterprise Manager, but as
MSDE doew not provide it, you need nothing on MSDE 2000...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Client utilities for MSDE

Hi,

I heard from a guy that the client utilities (Enterprice Manager and Query Analyser) that are on the Sql Server 2000 CD can be fetched separatly from Microsoft and that they can be deployed with MSDE to a potential customer.

Is that correct?

And if it is, where can I obtain those client apps?

TIA

OhlywohlyNope. You can't get the client utilities for free (legally), and deploy it to a customer.

http://msdn.microsoft.com/sql/downloads/tools/default.aspx

That's what you're limited to.|||You absolutely cannot deploy the Client Tools with MSDE to a customer! The whole point of MSDE is that it's an engine and your application should supply the means necessary to manage it.

If the client already owns a version of SQL Server then they may legally use the Client Tools to manage MSDE.

Unfortunately the Client Tools are not available for purchase separately. You might consider a set of 3rd party tools.

Terri
Disclaimer: I am not a lawyer nor a licensing expert

Client Tools?

Anyone know if it is legal to install SQL Server Client
Tools on a server with MSDE installed to manage MSDE? If
not, what are my tool options? (other than OSQL)
Thanks
Hi,
For using the SQL Server client utilities u need to buy License. But you can
get the free tool from microsoft.
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Hari
MCDBA
"Rnavis@.proflowers.com" <anonymous@.discussions.microsoft.com> wrote in
message news:1de201c4a750$9b0cb4e0$a401280a@.phx.gbl...
> Anyone know if it is legal to install SQL Server Client
> Tools on a server with MSDE installed to manage MSDE? If
> not, what are my tool options? (other than OSQL)
> Thanks
|||In addition to other answers...
Our customers are very happy doing MSDE development
with our (non free) tool Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> Anyone know if it is legal to install SQL Server Client
> Tools on a server with MSDE installed to manage MSDE? If
> not, what are my tool options? (other than OSQL)
> Thanks
|||hi,
"Rnavis@.proflowers.com" <anonymous@.discussions.microsoft.com> ha
scritto nel messaggio news:1de201c4a750$9b0cb4e0$a401280a@.phx.gbl
> Anyone know if it is legal to install SQL Server Client
> Tools on a server with MSDE installed to manage MSDE? If
> not, what are my tool options? (other than OSQL)
or you can have a look at further tools, both free and/or commercial at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea, can't seem to open your URL for DBAMGR...
Allan Halbert
"Andrea Montanari" wrote:

> hi,
> "Rnavis@.proflowers.com" <anonymous@.discussions.microsoft.com> ha
> scritto nel messaggio news:1de201c4a750$9b0cb4e0$a401280a@.phx.gbl
> or you can have a look at further tools, both free and/or commercial at
> http://www.microsoft.com/sql/msde/partners/default.asp and
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Allan,
"Allan Halbert" <AllanHalbert@.discussions.microsoft.com> ha scritto nel
messaggio news:3863100F-636E-48B6-8A03-72EB6EDEE8A7@.microsoft.com
> Hi Andrea, can't seem to open your URL for DBAMGR...
>
perhaps the server was down.. :-(
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||if you go to the MS site and search for SQL 2000 eval version, it states
that the client tools can be used indefinitely. confirmed with MS. Use the
EVAL version to intstall just Enterprise Mgr for MSDE. everything works
properly except the scheduled backups.
steve
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2s5bq9F1gove2U1@.uni-berlin.de...
> hi,
> "Rnavis@.proflowers.com" <anonymous@.discussions.microsoft.com> ha
> scritto nel messaggio news:1de201c4a750$9b0cb4e0$a401280a@.phx.gbl
> or you can have a look at further tools, both free and/or commercial at
> http://www.microsoft.com/sql/msde/partners/default.asp and
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||And the section of the eval license agreement that says you'll only use it
to evaluate the product (ie not use it in production) fits with this how?
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"bozo" <bozo@.bozosplace.com> wrote in message
news:10nc31oopkgtjfb@.corp.supernews.com...
> if you go to the MS site and search for SQL 2000 eval version, it states
> that the client tools can be used indefinitely. confirmed with MS. Use
> the
> EVAL version to intstall just Enterprise Mgr for MSDE. everything works
> properly except the scheduled backups.
> steve
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:2s5bq9F1gove2U1@.uni-berlin.de...
>

Client tools licensing question

Hello,
If we have a full version of SQL2K and want to install MSDE on about 30
mobile laptops can we install the client utilities from the SQL2K cd onto
each laptop? If not is there any other options? What would be the cost per
laptop to install the client software? Thanks.
Jake
Hi Jake,
No, you can't. We have a utility that's free for personal use and licensing
for things like you describe. Details are at our site. For other options,
look at: www.microsoft.com/sql/msde/partners/default.asp
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about 30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||Greg,
Is there one that would be good for setting up and managing replication.
We are planning on using merge replication.
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Hi Jake,
> No, you can't. We have a utility that's free for personal use and
> licensing for things like you describe. Details are at our site. For other
> options, look at: www.microsoft.com/sql/msde/partners/default.asp
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Jake,
That's on the way in our next version but it's not here yet. I've tried many
of the others but haven't come across one yet that does.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
> Greg,
> Is there one that would be good for setting up and managing
> replication. We are planning on using merge replication.
> Jake
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:eKmUUt%23rEHA.2948@.TK2MSFTNGP11.phx.gbl...
>
|||Greg,
Any idea on a release date? Will it work with SQLExpress?
Jake
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
> Hi Jake,
> That's on the way in our next version but it's not here yet. I've tried
> many of the others but haven't come across one yet that does.
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jake" <rondican@.hotmail.com> wrote in message
> news:OepQcx%23rEHA.868@.TK2MSFTNGP10.phx.gbl...
>
|||Hi Jake,
Still about 6 weeks. Separate product coming for SQL Express. It's a little
more challenging because SQL Agent isn't included.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||Pop me an email offline with what you need it to do so I can make sure it's
getting covered.
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jake" <rondican@.hotmail.com> wrote in message
news:ORLaiyFsEHA.2136@.TK2MSFTNGP14.phx.gbl...
> Greg,
> Any idea on a release date? Will it work with SQLExpress?
> Jake
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u%234Y7IEsEHA.376@.TK2MSFTNGP14.phx.gbl...
>
|||"Jake" <rondican@.hotmail.com> wrote in message news:O5In$G%
| If we have a full version of SQL2K and want to install MSDE on about 30
| mobile laptops can we install the client utilities from the SQL2K cd onto
| each laptop? If not is there any other options? What would be the cost per
| laptop to install the client software? Thanks.
|
For 30 servers, wouldn't you want to script it anyway? Seems odd to want to
install a GUI for such a task. I don't like using EM to make changes on even 1
production box.
Also, if you are going to use EM, I would want either the same person or 'team'
of dba's doing the configs. What you can do is put the msde box on the LAN and
connect to it from the dba's copy of EM that is probably installed on their
desktop.
Carl Karsten
|||if you go to the MS site and search for SQL 2000 eval version, it states
that the enterprise t tools can be used indefinitely. confirmed with MS.
Use the EVAL version to intstall just the Enterprise Mgr. everything works
properly with MSDE2000 except the scheduled backups.
steve
"Jake" <rondican@.hotmail.com> wrote in message
news:O5In$G%23rEHA.3848@.TK2MSFTNGP14.phx.gbl...
> Hello,
> If we have a full version of SQL2K and want to install MSDE on about
30
> mobile laptops can we install the client utilities from the SQL2K cd onto
> each laptop? If not is there any other options? What would be the cost per
> laptop to install the client software? Thanks.
> Jake
>
|||hi Steve,
"bozo" <bozo@.bozosplace.com> ha scritto nel messaggio
news:10nc2v5ff2iambe@.corp.supernews.com
> if you go to the MS site and search for SQL 2000 eval version, it
> states that the enterprise t tools can be used indefinitely.
> confirmed with MS. Use the EVAL version to intstall just the
> Enterprise Mgr. everything works properly with MSDE2000 except the
> scheduled backups.
I'm really not certain you are allowed to use the Eval tools on production
servers, or, anyway, after the evaluation time is finished...
they do work after the evaluation expires, but I'm confident you are not
allowed at all to use them...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Client tools

Hi I am new to MSDE. I see that you can use Access Data Projects to setup
MSDE but don't see some of the tools I have seen in SQL Server enterprise
manager. (Forgive me if I ask some really elementary questions for a while).
I want to set up tables with unique PK's that auto-generate values. I
learned today that the IDENTITY column is the way to do this, but how do I
set up one of these columns from Access?
Thanks
hi,
archer wrote:
> Hi I am new to MSDE. I see that you can use Access Data Projects to
> setup MSDE but don't see some of the tools I have seen in SQL Server
> enterprise manager. (Forgive me if I ask some really elementary
> questions for a while).
> I want to set up tables with unique PK's that auto-generate values. I
> learned today that the IDENTITY column is the way to do this, but how
> do I set up one of these columns from Access?
> Thanks
unfortunately I'm not an Access guy...
perhaps you have to ask in Acces/Office public NG
but you can define that via Transact-SQL Code like
CREATE TABLE dbo.someTable (
ID int NOT NULL IDENTITY(1,1) ,
other columns ...
)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||In Access project, which is connected to the said database, open the said
table in design view, at bottom of table design view is table column
properties view, make "Identity" to "Yes".
"archer" <archer@.discussions.microsoft.com> wrote in message
news:B9F59449-222B-45ED-86ED-47113B76D7EE@.microsoft.com...
> Hi I am new to MSDE. I see that you can use Access Data Projects to setup
> MSDE but don't see some of the tools I have seen in SQL Server enterprise
> manager. (Forgive me if I ask some really elementary questions for a
while).
> I want to set up tables with unique PK's that auto-generate values. I
> learned today that the IDENTITY column is the way to do this, but how do I
> set up one of these columns from Access?
> Thanks
>

client side

how does one install client side from MSDE? Developer told us we need to install client side so he can configure database links. I can't find anything on it in MSDE 2000 Release A.
I dont understand what you meant by client side? If it is to access the MSDE
database through ADO/ADO.NET/ASP code then all you would need is MDAC 2.6.
That would be a part of normal Windows OS itself. If you are interested in
tools to access and use MSDE as Enterprise Manager etc then you can always
use third party tools for the same.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"steve" <anonymous@.discussions.microsoft.com> wrote in message
news:0931AC39-990A-4543-AEE0-52417600280A@.microsoft.com...
> how does one install client side from MSDE? Developer told us we need to
install client side so he can configure database links. I can't find
anything on it in MSDE 2000 Release A.
|||It sounds like he meant to install an instance of MSDE on the "client" e.g.
whatever is running the application that requires a database. I assume he
meant this, rather than having the database hosted on a separate machine.
If this is the case, then run MSDE setup on the client machine, rather than
on a server.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"steve" <anonymous@.discussions.microsoft.com> wrote in message
news:0931AC39-990A-4543-AEE0-52417600280A@.microsoft.com...
> how does one install client side from MSDE? Developer told us we need to
> install client side so he can configure database links. I can't find
> anything on it in MSDE 2000 Release A.
|||yes, I think this is what he wants, that the msde components are installed for the application to be able to use them. WHen I use the current MSDE 2000 release a, it doesn't give me an option of installing anything but the MSDE SQL server side. is there
a command line, file or something that we need to be able to install the client side? He told me that he hasn't used the current MSDE 2000 Service release a yet, but that in prior versions and SQL one has the option of just installing the application /
client side. Thanks in advance - Steve
|||> MSDE 2000 release a, it doesn't give me an option of installing anything
but the MSDE SQL server side.
You're thinking about this entirely in the wrong way. What your other
people are suggesting is that you treat the client as the server. So, if
you run MSDE setup on the client, it is the server. MSDE doesn't understand
what you mean by "server side"... wherever it installs, that is the server!
Now, think about the app. The app lives on the client. Install MSDE on the
machine that is running the app. Now you have a client-side MSDE install.
Pretty simple, huh?

> has the option of just installing the application / client side.
He is confused as well. Maybe he is thinking about client tools (Enterprise
Manager, Query Analyzer) which is an installation option, but client tools
don't ship with MSDE at all so it wouldn't be relevant in this case.
Re-read the above paragraph and let me know if I need to clarify further.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||hi Steve,
"steve" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:23DA0332-ACC4-4A13-82CD-604671210454@.microsoft.com...
> yes, I think this is what he wants, that the msde components are installed
for the application to be able to use them. WHen I use the current MSDE
2000 release a, it doesn't give me an option of installing anything but the
MSDE SQL server side. is there a command line, file or something that we
need to be able to install the client side? He told me that he hasn't used
the current MSDE 2000 Service release a yet, but that in prior versions and
SQL one has the option of just installing the application / client side.
Thanks in advance - Steve
MSDE insatalls only as a whole package and there has never been a Client
Components Setup for it, only just for SQL Server...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||First - thank you for the replies.
I am at a loss then what it is that he needs. MSDE 2000 SRa is installed on a Windows 2000 Advanced Server that I set up for this. He then installed the database onto that computer and I created a VPN so he could use his Enterprise Tools remotely to make
some configuration changes. The application that interfaces with it he built on a VB / Access97 platform. He said the client side was needed to link the application to the MSDE server and that he was having trouble linking it but that they were some oth
er ways he could try. His suggestion was that I install the "client side" items on the workstation that was going to be running the VB / Access97 user interface. While I am MS certified, in prior jobs I haven't worked much with SQL server at the install
ation phase but have rather supported the interfaces after they were written and installed by the programers. I apologize for my lack of understanding and use of wrong syntax. We've used this programmer for years and everything else he has done has been
sucessful. Perhaps he isn't able to explain what it is that he wants.
-- Andrea Montanari wrote: --
hi Steve,
"steve" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:23DA0332-ACC4-4A13-82CD-604671210454@.microsoft.com...
> yes, I think this is what he wants, that the msde components are installed
for the application to be able to use them. WHen I use the current MSDE
2000 release a, it doesn't give me an option of installing anything but the
MSDE SQL server side. is there a command line, file or something that we
need to be able to install the client side? He told me that he hasn't used
the current MSDE 2000 Service release a yet, but that in prior versions and
SQL one has the option of just installing the application / client side.
Thanks in advance - Steve
MSDE insatalls only as a whole package and there has never been a Client
Components Setup for it, only just for SQL Server...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Steve,
"steve" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:8EBB34FC-64EC-4B21-9221-73CDECEF9DC0@.microsoft.com...
> First - thank you for the replies.
> I am at a loss then what it is that he needs. MSDE 2000 SRa is installed
on a Windows 2000
> Advanced Server that I set up for this. He then installed the database
onto that computer and I created
> a VPN so he could use his Enterprise Tools remotely to make some
configuration changes. The
> application that interfaces with it he built on a VB / Access97 platform.
He said the client side was
> needed to link the application to the MSDE server and that he was having
trouble linking it but that
> they were some other ways he could try. His suggestion was that I install
the "client side" items on the
> workstation that was going to be running the VB / Access97 user interface.
While I am MS certified,
> in prior jobs I haven't worked much with SQL server at the installation
phase but have rather supported
> the interfaces after they were written and installed by the programers. I
apologize for my lack of
> understanding and use of wrong syntax. We've used this programmer for
years and everything else
> he has done has been sucessful. Perhaps he isn't able to explain what it
is that he wants.
usually, at client side, you shoul'd only install MDAC that provides the
client side dirvers and interfaces to connect to remote SQL Server/MSDE
instances...
what your guy intended is not wrong at all, becouse he indicates to install
the Client Components for SQL Server, that includes MDAC and the whole tools
as Enterprise Manager, Query Analyzer and so on to manage SQL Server
instances.. this is fine as long as you own a full SQL Server edition that
license you to do it, while MSDE only provides a server side setup with no
management tools bu oSql.exe, a command line tool
(http://support.microsoft.com/default...;EN-US;q325003)
you reported the client application is a VB / Access97 platform... then you
are only required to install VB/Access runtime dependencies and MDAC on the
clients... or just VB/Access runtime dependencies on the server... as long
as the app =;-)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||thank you. Steve

client network utility & server network utility - what's the difference?

I'm confused about this. If I need MSDE installed on a server and have 10
workstations accessing it AND I don't want to use port 1433, what's the
process I need to go through to make that work right. I've fumbled around
with it and am not sure I follow the process. It seems logical to me that I
would run the server one on the server, set the port and then run the client
one on the client and set it to match the server but I hvae a feelign that's
not the case. Especially because since I'm not installing MSDE on any of the
client machines there is no network utility installed (AFAIK).
I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
things (if at all).
Thanks,
Keith
Yes, your thought is very logical and workable if the client network utility
is installed on workstations, so that you can have apps on workstation know
whih port is used to communicate with SQL Server. Actually, if you to create
a ODBC DSN to SQL Server, the DSN configuration provides you a dialog to
specify network library to use (TCP, Named Pipe...) and port number (or
dynamically determined).
However, in most cases, you do not need to run the client network utiliy on
workstations. The port number can be specified in the applications'
ConnectionString (if the app is designed well, there should be someway to
configure its connectionString, i.e. the database connection information).
AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
not explicitly set it to 0 when you install MSDE, by default, the MSDE is
not accessible from other computer. If you want the MSDE being accessible by
other computer, you either set it to 0 at installation or you can enable
network access after installation.
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
> I'm confused about this. If I need MSDE installed on a server and have 10
> workstations accessing it AND I don't want to use port 1433, what's the
> process I need to go through to make that work right. I've fumbled around
> with it and am not sure I follow the process. It seems logical to me that
> I
> would run the server one on the server, set the port and then run the
> client
> one on the client and set it to match the server but I hvae a feelign
> that's
> not the case. Especially because since I'm not installing MSDE on any of
> the
> client machines there is no network utility installed (AFAIK).
> I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
> things (if at all).
> Thanks,
> Keith
>
|||Just wondering if there's a clear answer to this - if
DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial installation of
MSDE sp3 so that the server is accessible from other workstations, what
happens if I set DISABLENETWORKPROTOCOLS=1 for an upgrade to sp4? Will that
basically disable the networkability for the specified instance of MSDE from
that point forward, or is that only temporary for the installation process?
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23v3k7Xf9GHA.3264@.TK2MSFTNGP04.phx.gbl...
> Yes, your thought is very logical and workable if the client network
> utility is installed on workstations, so that you can have apps on
> workstation know whih port is used to communicate with SQL Server.
> Actually, if you to create a ODBC DSN to SQL Server, the DSN configuration
> provides you a dialog to specify network library to use (TCP, Named
> Pipe...) and port number (or dynamically determined).
> However, in most cases, you do not need to run the client network utiliy
> on workstations. The port number can be specified in the applications'
> ConnectionString (if the app is designed well, there should be someway to
> configure its connectionString, i.e. the database connection information).
> AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
> not explicitly set it to 0 when you install MSDE, by default, the MSDE is
> not accessible from other computer. If you want the MSDE being accessible
> by other computer, you either set it to 0 at installation or you can
> enable network access after installation.
>
> "Keith G Hicks" <krh@.comcast.net> wrote in message
> news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
>
|||hi Bill,
Bill Hicks wrote:
> Just wondering if there's a clear answer to this - if
> DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial
> installation of MSDE sp3 so that the server is accessible from other
> workstations, what happens if I set DISABLENETWORKPROTOCOLS=1 for an
> upgrade to sp4? Will that basically disable the networkability for
> the specified instance of MSDE from that point forward, or is that
> only temporary for the installation process?
as per
http://msdn.microsoft.com/library/de...tsql_84xl.asp,
DISABLENETWORKPROTOCOLS=n
In SQL Server 2000 SP3 or later, specifies how the Installer configures the
network protocol support for the instance of the Desktop Engine being
installed or upgraded. n is an integer number, and should be set to either 0
or 1.
These are the behaviors of DISABLNETWORKPROTOCOLS in SP3a or later:
Value Specified for n Installing New Instance
1:
Upgrading Existing Instance: Instance is configured with all server
Net-Libraries disabled.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
0:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with default server
Net-Libraries and addresses enabled.
Parameter not specified, or is any value other than 0 or 1:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

Client Network Utility

Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
----
--
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
--
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***

Client Network Utility

Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***

Client Network Utility

Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
--
----
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>