MSDE Sort Page

Hi,
I would like to install MSDE by selecting options from the
screen and not by typing commads at command prompt, just
the same way of installing SQL Server 2000.
I would also like to change the Sorting and collation
options under MSDE.
Please Help.
Thanks
Asim
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:79d501c48460$d47c2890$a401280a@.phx.gbl...
> Hi,
> I would like to install MSDE by selecting options from the
> screen and not by typing commads at command prompt, just
> the same way of installing SQL Server 2000.
> I would also like to change the Sorting and collation
> options under MSDE.
you have then to provide your own custom tool, which will then pass al
gathered info to the setup.exe via standard command line parameters or INI
settings
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||HI Andrea,
I think your message did not come completely. I would
appreciate if you can send it once again.
Also please let me know how can I change by what code, the
sort or collation page setting after the MSDE has been
installed. My email is asim@.dataocean.com
Thanks

>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:79d501c48460$d47c2890$a401280a@.phx.gbl...
the
>you have then to provide your own custom tool, which will
then pass al
>gathered info to the setup.exe via standard command line
parameters or INI
>settings
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi Asim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7c8b01c48468$b1d359a0$a601280a@.phx.gbl...
> HI Andrea,
> I think your message did not come completely. I would
> appreciate if you can send it once again.
> Also please let me know how can I change by what code, the
> sort or collation page setting after the MSDE has been
> installed. My email is asim@.dataocean.com
my message was complete... LOL
I apologise if it was not clear
you have to implement a vb/vc/.net/delphi pre-installer, which collects all
user's input regarding settings like SAPWD, DISABLENETWORKPROTOCOLS,
INSTANCENAME, SECURITYMODE, TARGETDIR, DATADIR and COLLATION (for sort
order)...
then you have shell out to setup.exe passing all parameters (or setting them
in the referenced INI file)
as regard COLLATION, you can not change the system collation after the
instance has been installed...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Reinstall

Have reinstalled MSDE using Command Prompt Installation and received Errors.
Then I proceeded with a Batch.file installation and that seemed to work for the most part.

This is what I used for the Batch.file

setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL

The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.

Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:\>osql -E check with the Command Line Prompt which returned the following message:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Tried again with c:\>osql -E -S
returned the same message.

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Not sure what to do at this point any help/advice. Thx/TIA

(MSDE Version: sql2kdesksp3)
OS = XP ProUpdate:

Finally Managed to Connect to (SERVICE MANAGER) So now I have Connection with my server. I had to Specify ServerName\Instancename - and finally managed to connect.

But I can't seem to make a Database Connection In webMatrix. I entered The (USERName & Password Name) with no luck, even tried different combinations but still no luck!! USERNAME:Someusername**** (and) PASSWORD:SomePassword****

Is there a way I can create a New USERNAME & PASSWORD, with the command Line Prompt?
Anyone know how to do this? THX /TIS

Tristen|||view post 446484|||Thank you for Link/replying Bill,

Problem corrected. Reinstalled MSDE & Made a New SQL Authentication Password.|||Did "setup /upgradesp" help you?

MSDE Password

I'm trying to apply a password to the (sa) account. When
I go to the dos prompt I type
osql -U sa
password:
1>sp_password @.old = null
2>@.new = 'password'
3>@.loginame = 'sa'
4>go
Then I get this error message
Msg 170, Level 15, State 1, Server _____, Line 2
Line 2: Incorrect syntax near '@.new'
what am i doing wrong
Try commas in between parameters like so:
1>sp_password @.old = null,
2>@.new = 'password',
3>@.loginame = 'sa',
4>go,
Bob
SuccessWare Software
"mcarter297" <anonymous@.discussions.microsoft.com> wrote in message
news:1d48001c453bc$190dfa40$a101280a@.phx.gbl...
> I'm trying to apply a password to the (sa) account. When
> I go to the dos prompt I type
> osql -U sa
> password:
> 1>sp_password @.old = null
> 2>@.new = 'password'
> 3>@.loginame = 'sa'
> 4>go
> Then I get this error message
> Msg 170, Level 15, State 1, Server _____, Line 2
> Line 2: Incorrect syntax near '@.new'
> what am i doing wrong
|||Hi,
OSQL -Usa -Ppasword -S Servername (Enter Key)
1>sp_password null,'newpassword',sa (Enter key)
2>go (Enter Key)
Thanks
Hari
MCDBA
"mcarter297" <anonymous@.discussions.microsoft.com> wrote in message
news:1d48001c453bc$190dfa40$a101280a@.phx.gbl...
> I'm trying to apply a password to the (sa) account. When
> I go to the dos prompt I type
> osql -U sa
> password:
> 1>sp_password @.old = null
> 2>@.new = 'password'
> 3>@.loginame = 'sa'
> 4>go
> Then I get this error message
> Msg 170, Level 15, State 1, Server _____, Line 2
> Line 2: Incorrect syntax near '@.new'
> what am i doing wrong

MSDE installed, now what?

I've run the install from the command prompt for MSDE. Is there a GUI somewhere that I can fire up? I don't see anything installed in my programs or any shortcuts anywhere, so I'm not sure where to go from here and how to tie my aspx pages into it. Thanks.Hi,

No GUI for MSDE natively except that you can use other third party 'control panel' to configure the MSDE engine. After installing the MSDE from command prompt , your next step is most likely to install the SP3 and then get started writing code against your database. :)

FYI:http://asp.net/webmatrix/guidedtour/Appendices/installMsde.aspx

Regards,|||Thank you!|||Check this 3rd party tool out for a great MSDE GUI interface:

http://www.valesoftware.com/

MSDE Installation stops in Command Prompt

Hi,
I am trying to install MSDE from a CD. At the beginning I cunpack all files at C:\sql2ksp3. Then in in Command prompt
I enter C:\sql2ksp3\MSDE>Setup SAPWD=Hello SecurityMode=SQL
The problem is that nothing happens after that. When I press enter another line appears C:\sql2ksp3\MSDE>
but that's about it.
The installation does not continue. Does anybody know how to "push" it a bit so it will continue?
Thanks
Try the post below for the correct file part. Hope this helps.
http://forums.asp.net/955765/ShowPost.aspx

MSDE installation - newbie problem

Dear all,

I have this problem with MSDE Installation:

I install MSDE then from prompt c:\sql...\msde\
I type: setup INSTANCENAME=pippo SECURITYMODE=SQL SAPWD=pp
then I restart but I see on the toolbar the icon of the SQL server but Ihaven't any Server or Service, in the Icon there is not the green signal nether the red signal, the little circle is white.

what I need to do?

thanks,
lucaHi Luca,

What version of Windows is this?

Don|||Windows XP Pro.

Now I unistall MSDE and Re-install it and now is ok.

Is the 1st time I use MSDE and I'd like t know wath's the use of SAPWD ?
and I need to indicate in the SETUP SAPWD=... etc. also uid= ?
and uid wath's

thanks,
luca|||I'm having the same problem. I'm using Windows 2000 Professional.

I do have the SQL Server 2000 CLIENT Tools installed on my computer, but as far as I know, those are just for connecting to SQL db's, it's not the actual engine; that's why I want MSDE on my machine. Would those client tools be conflicting with my MSDE installation?|||I've tried uninstalling it and then reinstalling it...

When I double click the little server icon in the tray and I go to hit the green play button, there are no services in the dropdown menu to start.

Anyone know how to solve this?|||Hi Luca,

The SAPWD switch lets you set the sa (system administrator, SQL Server's superuser) password which you shouldALWAYS do because of worms that have taken advantage of it.

uid is user id, the user you can use to log into MSDE.

Don|||Hi Matt,

I'm not sure I understand what you're saying about having the SQL Server client tools installed. You can use those to connect to and manage the engine of any SQL Server or MSDE installation on the local machine or across the network that you have permissions to access.

Do you mean that those don't include the database engine? If so, yes, that's right. So you would indeed want to install MSDE in order to use databases locally. And no, the client tools won't conflict with your MSDE installation at all.

I don't know why you aren't getting any services listed. If you go into Computer Management from the Control Panel do you have MSSQLSERVER listed under Services and Applications | Services? If so, can you start it from there?

This could be because you already had the client tools installed when you installed MSDE. So you probably have to add a registration to the local MSDE. Go into Enterprise Manager, expand Microsoft SQL Servers in the treeview, right-click on SQL SErver Group and select New SQL SErver Registration from the popup menu. In the available servers select either LOCAL (it might say LOCALHOST) or the machine name. If it isn't listed, type it in. Then complete the other steps in the wizard.

Does that solve it?

Don|||Don:

Since my last post I UNinstalled MSDE. You did clear up a lot for me though. I was unsure if the Client Tools were somehow conflicting, but now I know they won't.

I'll REinstall MSDE and register it in Enterprise Manager and see what happens.

Thanks for your help!

MSDE install problems

hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(Please ignore this previous message, I seemed to have bypassed this old error, this old error only appeared when I don't specify an instance name.

When i do now specify one, then I get this error:

Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 0:18:23: InstallFinalize. Return value 3.

I tried numerous things but the only stuff that works is when I make a C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory and copy sqlctr.ini and sqlctr.h into it (which i poached from an install that didnt rollback).

But this results in the following error:

Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL Server\Mssql\BinnMSSQL$DONALD007\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 0:05:57: InstallFinalize. Return value 3.

Does anyone know how to solve this?
btw here are parameters

REINSTALL=All
REINSTALLMODE=omus
COLLATION=Latin1_General_CI_AS
TARGETDIR=C:\Program Files\Microsoft SQL Server\Mssql\Binn
DATADIR=C:\Program Files\Microsoft SQL Server\Mssql\Data
SAPWD=1111
INSTANCENAME=Donald007

This is a clean install of msde using sql service pack 3 on win xp pro.

I have attached a copy of my log file that is generated when this "LoadLibrary failed.." error occurs.

I also noticed that in the services i can still see a SQLSERVERAGENT even though this service is not started and the file it refers to has been deleted.

Originally posted by deekay2003
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(

MSDE install problem

I have installed MSDE from the command prompt as instructed and get no error message - nor do I get the expected request to reboot. Since I know I must reboot to see MSDE launch, I did so, but it does not launch. It doesn't matter how many times I do this... Any ideas? I am attempting to do this on an XP machine with more than the requirements for doing so. Any help would be MOST APPRECIATED.

thanks
JSearcyIf you go to Start -> Settings -> Control Panel -> Administrative Tools -> Services do you see anything like MSSQLServer listed?

(it may be named slightly different if you installed a "named instance", in which case the name of the instance will be after MSSQLServer).

Cheers
Ken

MSDE install

Hello,
I installed MSDE 2000 sp3 on my windows 2000 computer. I
installed it within the command prompt as per the
instructions "setup INSTANCENAME="InstanceName"
SECURITYMODE=SQL SAPWD="Mypassword"
The setup seemed to run ok. The instancename is running in
the services and the SQLAgent is running.
However, when I go into the Enterprise manager and try to
register the server as (local) and enter my sa password
when it asks for it. I'm getting "SQL server does not exit
or access denied".
Thank you,
Randy
hi Randy,
Randy wrote:
> Hello,
> I installed MSDE 2000 sp3 on my windows 2000 computer. I
> installed it within the command prompt as per the
> instructions "setup INSTANCENAME="InstanceName"
> SECURITYMODE=SQL SAPWD="Mypassword"
> The setup seemed to run ok. The instancename is running in
> the services and the SQLAgent is running.
> However, when I go into the Enterprise manager and try to
> register the server as (local) and enter my sa password
> when it asks for it. I'm getting "SQL server does not exit
> or access denied".
> Thank you,
> Randy
as you installed a named instance, you can reach it uing it's full name,
composed by ComputerName\InstanceName, or Local\InstanceName
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply