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

How can I change the Sort Code Page under MSDE? And also
where can i find the rebuild option under MSDE?
Any help would be highly appreciated
Thanks
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:20a001c47d51$d5771270$a301280a@.phx.gbl...
> How can I change the Sort Code Page under MSDE? And also
> where can i find the rebuild option under MSDE?
you can create databases with different collations, and you can define
different collation at column level too...
as regard the defaul collation, I think MSDE does not provide the rubuild
utility, so you probably have to uninstall MSDE and reinstall it
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,
Thanks for your quick response. As I am new to this, can
you please guide me how to determine the collation for the
database in msde.
Thanks once again
Asim
>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:20a001c47d51$d5771270$a301280a@.phx.gbl...
>you can create databases with different collations, and
you can define
>different collation at column level too...
>as regard the defaul collation, I think MSDE does not
provide the rubuild
>utility, so you probably have to uninstall MSDE and
reinstall it
>--
>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,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:247501c47d58$fc457160$a601280a@.phx.gbl...
> HI Andrea,
> Thanks for your quick response. As I am new to this, can
> you please guide me how to determine the collation for the
> database in msde.
you can investigate the collation settings like
SET NOCOUNT ON
SELECT SERVERPROPERTY ( 'Collation' ) AS [Server wide Collation] ,
DATABASEPROPERTYEX ( 'master' , 'Collation' ) AS [Specific Database
Collation] ;
as for the specifi instance and for each database...
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
sql

MSDE installation for .Text blogging

Hi All
A little help for MSDE please. I have tried and tried but
no luck ;-(
I followed the steps on the Installation page and
installed .Text and MSDE.
To install MSDE i used the instructions
Setup SAPWD=Test123 SecurityMode=SQL
My first question is
In the connection string, whats the username for the MSDE.
I tried looking for a default login but couldn't find one.
If i use my domain login, it doesn't work.
When i load the default page i get
"Sql Server does not exist or access denied"
I know Sql Server Exists and i can use the MSDE Query
tool. If i use NT Auth i can log in. Please advise for the
connection string.
<DbProvider type
= "Dottext.Framework.Data.SqlDataProvider,
Dottext.Framework"
connectionString = "Password=test1234;Persist
Security Info=True;User ID=admin;Initial
Catalog=blogDb;Data Source=localhost" />
Do i need to grant users for access. how do i do that.
I havent used databases in about 10 yers. a little rusty.
Raj
hi Raj,
"Raj" <raj.sinha@.gmail.com> ha scritto nel messaggio
news:996601c49747$c0098ca0$a601280a@.phx.gbl...
> Hi All
> A little help for MSDE please. I have tried and tried but
> no luck ;-(
> I followed the steps on the Installation page and
> installed .Text and MSDE.
> To install MSDE i used the instructions
> Setup SAPWD=Test123 SecurityMode=SQL
> My first question is
> In the connection string, whats the username for the MSDE.
> I tried looking for a default login but couldn't find one.
> If i use my domain login, it doesn't work.
> When i load the default page i get
> "Sql Server does not exist or access denied"
> I know Sql Server Exists and i can use the MSDE Query
> tool. If i use NT Auth i can log in. Please advise for the
> connection string.
> <DbProvider type
> = "Dottext.Framework.Data.SqlDataProvider,
> Dottext.Framework"
> connectionString = "Password=test1234;Persist
> Security Info=True;User ID=admin;Initial
> Catalog=blogDb;Data Source=localhost" />
> Do i need to grant users for access. how do i do that.
> I havent used databases in about 10 yers. a little rusty.
> Raj
>
for potential causes of access denied, please have a look at
http://support.microsoft.com/default...06&Product=sql
please verify MSDE accepts SQL Server connections too, and that the
credentials you are passing have been granted logins rights...
the "admin" SQL Server user must of course exists in SQL Server logins
collection, and so all other logins, both WindowsNT and SQL Server...
you can do that via oSql.exe, the command prompt management tool provided
with MSDE, more info at
http://support.microsoft.com/default...EN-US;q325003, but for
your convenience, you can have a look at further management tools, both free
and/or commercials, at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
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

msde INSTALLATION

Hi

I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.

Could somebody help me.

AkshatOK. what's your computer's name?
what command line are you specifying, exactly?|||Thanx for the message.
Computer Name=Akshat

Setup SAPWD=hello SecurityMode=SQL

These are mentioned on the webpage for installation so I just followed them.

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Akshat