msde 2000

Greetings:

I am trying to install MSDE on a local machine on port 1433.
I can't get it to install using that port it only installs using shared memory according to the logs. can someone tell me how to install it using tcp port 1433 or how to change it in the registry.
so far here are a few of the settings i am passing to the setup program.

setup INSTANCENAME=something SAPWD=something_else SECURITYMODE=SQL

i have read some of the manual but i could not find how to make this change.

thanks
BrianRfer thru MSDE readme.html file to install.

MSDE (SQL 2000) Full Service Pack 1 (2)

I need the full Service Pack 1 (or 2) MSDE Installation files to include in an Installer. I am not interested in upgrading current MSDE RTM installs but rather need to install an MSDE SP1 (2) Instance on the client machines. I found a lot of places to get the files but the weird thing is in the supposed MSDE SP2 download files (SQL2KDeskSP2.exe) the sample.msi and samplupgr.msi files are missing that are the templates to be used to create the unique (GUID) MSI installation files for MSDE. Microsoft highly recommends creating the unique MSI files to ensure a previous instance did not use an MSI file with the same GUID.

see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp

The SQL2KDeskSP2.exe does include the SQLRUN01.MSI SQLRUN16.MSI files, but nowhere does it say you can use one of these files as a template and change the GUID internally using ORCA and VC++.

Are we supposed to use the old sample and sampleupg.msi files with SP2 .. but use all the other Install files for SP 1 (2) ?

Please excuse my ignorance of the "Windows Installer" software.

Thanks very much for any information,
Billy MatlockI have been able to get the full sql server sp1 files using msdn subscriber download. I think you have to order a cd if you do not have an msdn subscription.

I have not found a full desktop download for sp2 - although the page that announced the availability of sp2 implied that it would be in the subscriber downloads and that was a while ago.

MSDE > SQL Express

We have a product on the market, with 100k or so installs that use MSDE as its database (desktop application in .net). Our number 1 complaint is massive installation problems with MSDE.

Now, we are stuck a bit - first, we need to release a Vista Compatible version - which means no MSDE. We also need to migrate users from MSDE to SQL Express, with no data loss (we deal with financial information, and people tend to have zero tolerance for data loss here).

So, I have large scale reservations for two reasons - first, Microsoft's track record in supporting and making MSDE in the past has not been stellar.

With that said - are the multiple installation failure issues fixed in SQL Express? Did MS make the effort to get SQL Express to install on Win2k/XP/Vista improved? Are their benchmark figures out there regarding SQL Express install failure rates?

Additionally, can I get some information regarding MSDE to SQL Express upgrades done during for existing customers?

jason

Hi Jason,

Great strides have been made in installation for SQL Express and it is much better than MSDE. This is not to say there are no issues, a quick search of this forum will confirm that there are, but I have not seen the kind of wholesale failures that were common with MSDE. I think SQL Express is way better for install than MSDE.

I don't know of anyone that tracks benchmarks such as you describe, sorry. I can point you to an article that we have that describes best practices for upgrading from MSDE to SQL Express, you can find it here. I have confidence that our upgrade procedure will not harm or lose our data since your database files are just left in place and then attached once the new server is installed, but I would be remise to not remind you that you should take responsibility for protecting your own important data.

I'd say that it's critical to backup your databases as a first step of any migration process. Additionally, you may want to consider doing a side by side upgrade in stead of in place to give you maximum control. During a side by side upgrade, you manually move your databases, so you can choose to use a copy (leaving the original safe) or even migrate your data by restoring a backup rather than using the original mdf. One thing to remember, once the database is converted to SQL 2005, it can't go back to 2000 format. If you are concerned that you might want to roll back the migration, you need to ensure that you keep a copy of the 2000 format database around until migration is complete.

Mike

MSDE - Unknown Server

Hello,
I installed software called AutoAPP on a users desktop and this software
automatically installs MSDE (No idea what version). When run under the
administrator account everything is fine. When the user logs on under their
account (power user) SQL Icon is on the task bar, but it is blank \\ -
Unknown Server. I have to manually type in the laptop name in the server
field of the SQL Server Service Manager and then the arrow will go green.
Does anyone know why under Administrator account the server name is there,
but not under the users profile? It is annoying having to type in the
computer each time the computer reboots, giving the user Administrative
access to their computer is not really an option. Once the computer name is
entered under the user account everything seems to function normally.
Laptop is running Windows XP Pro SP1
Thank You.
hi John,
"John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
> Hello,
> I installed software called AutoAPP on a users desktop and this
> software automatically installs MSDE (No idea what version). When
> run under the administrator account everything is fine. When the
> user logs on under their account (power user) SQL Icon is on the task
> bar, but it is blank \\ - Unknown Server. I have to manually type in
> the laptop name in the server field of the SQL Server Service Manager
> and then the arrow will go green. Does anyone know why under
> Administrator account the server name is there, but not under the
> users profile? It is annoying having to type in the computer each
> time the computer reboots, giving the user Administrative access to
> their computer is not really an option. Once the computer name is
> entered under the user account everything seems to function normally.
> Laptop is running Windows XP Pro SP1
is the Service Manager only that does not enlist the local server, or is the
MSDE service itself that is not running when logging as a power user?
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
|||> is the Service Manager only that does not enlist the local server, or is
> the
> MSDE service itself that is not running when logging as a power user?
I uninstalled everything, but once I reinstall I will check under the
Services and Applications -> Services to make sure it is running. I'm
almost positive it is running and the Service manager does load on boot up,
but the circle will not have the green arrow. If I open the Service Manager
the drop down for the Server field will be empty. I type in the name of the
local comptuer i.e. laptop1 and it arrow goes green and the application can
access the database. It is just annoying to have to type in the computer
name each time. I will very 100% for sure if the service is running in the
next day or so, once I get a chance to work on the users laptop again.
Thanks You.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2u4493F26ob6nU1@.uni-berlin.de...
> hi John,
> "John J. Rambone" <lgm_rambone@.remove.hotmail.com> ha scritto nel
> messaggio news:uANQsnFuEHA.1472@.TK2MSFTNGP10.phx.gbl
>

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