I got error when installing MSDE

I got a message when I type in :
setup SAPWD=abc SECURITYCODE=SQL
and setup the MSDE, there is an error said
"Unable to determine system default collatution."
What can I do?
Bill,
I think you cannot use abc, password, or anything that easy as pwd.
"Bill" wrote:

> I got a message when I type in :
> setup SAPWD=abc SECURITYCODE=SQL
> and setup the MSDE, there is an error said
> "Unable to determine system default collatution."
> What can I do?
>
|||Bill,
check MSDN knowledge base article 823466... may be able to help... also
check knowledge base articles for "Unable to determine system default
collation", there were several articles...
hope this helps!
wardeaux
"Bill" <vbpro@.hgcbroadband.com> wrote in message
news:017a01c48b9b$b6d04230$a401280a@.phx.gbl...
> I got a message when I type in :
> setup SAPWD=abc SECURITYCODE=SQL
> and setup the MSDE, there is an error said
> "Unable to determine system default collatution."
> What can I do?
sql

I get "Error 2245 while trying to do NetUserAdd operation"

Hi all,
I tried installing MSDE 1 and 2 on my system but whenever I try to install it, it come up with the error:
"Error 2245 while trying to perform operation NetUserAdd"
I don't understand why this happens. Can anyone help? I've used msde successfully before but this is a new problem recently. I have an AMD 2600+, with Windows XP Pro, 512 MB RAM.
Any help would be greatly appreciated
Thanks
hi,
"Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> Hi all,
> I tried installing MSDE 1 and 2 on my system but whenever I try to install
it, it come up with the error:
> "Error 2245 while trying to perform operation NetUserAdd"
> I don't understand why this happens. Can anyone help? I've used msde
successfully before but this is a new problem recently. I have an AMD
2600+, with Windows XP Pro, 512 MB RAM.
> Any help would be greatly appreciated
> Thanks
>
perhaps it's an AD relate problem... please have a look at
http://tinyurl.com/5ewol
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
|||Thanks for that suggestion.
I have read the link and tried using a longer password but it does not help and I still get the same error. Any other advice please?
Thanks
"Andrea Montanari" wrote:

> hi,
> "Indy" <Indy@.discussions.microsoft.com> ha scritto nel messaggio
> news:C843C48D-936F-4BE8-8751-BB725FA47BF2@.microsoft.com...
> it, it come up with the error:
> successfully before but this is a new problem recently. I have an AMD
> 2600+, with Windows XP Pro, 512 MB RAM.
> perhaps it's an AD relate problem... please have a look at
> http://tinyurl.com/5ewol
> --
> 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
>

i cant activate the report

Hi all
I set up a enviroment of report services:
windows 2000+mssql 2000+vs.net 2003+report service.
after finished installing the report ,it told me cant activate
automatically,
i should activate the report service by hand,
so i fount the command in help file: rsacivate command
so
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>reac
tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report
Server\rsreportserver.config" -t
and it shows:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548)
0x80004002 -->
System.Exception: 0x80004002
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
any1 can help me out.
thank youHi Asher!
Did you find a solution?
I have the same problem too and i noticed other users with this problem,
nobody has found a solution til now...
I'd appreciate help from microsoft staff on this topic.
I'm on Windows 2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
--
ErrorMessage when executing rsactivate -c"C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
Error Message when executing rskeymgmt -d -t:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thx for any help
yara
"Asher Wu" wrote:
> Hi all
> I set up a enviroment of report services:
> windows 2000+mssql 2000+vs.net 2003+report service.
> after finished installing the report ,it told me cant activate
> automatically,
> i should activate the report service by hand,
> so i fount the command in help file: rsacivate command
> so
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>reac
> tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Report
> Server\rsreportserver.config" -t
> and it shows:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548)
> 0x80004002 -->
> System.Exception: 0x80004002
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> any1 can help me out.
> thank you
>
>

I believe I have installed SQLExpress ok but using the command prompt after that does not track

I am at the command prompt after installing SQLExpress and typing in the following: sqlcmd -S roger-xp-x2\SQLExpress -E and I get the following response: 1> and at that point I type in sp_grantlogin [roger-xp-x2\Roger and I get the following response: 2~ and not 2> I then type go and get a 3~ which I am guessing the tildes indicate errors. Any ideas where I am going amuck?

Roger

it looks like your missing a closing "]".|||

Thanks Dan, It only sounds too simple but I am hopefull that is all it is.

Roger