Error when restoring master database

Dear all,
I'm working on MS SQL 2000.
I stopped the SQL Server and the SQL Agent services.
and from the prompt:
sqlservr.exe -s MyInstanceName -c -m
then from QA, I've entered my MyInstanceName, user: sa and pwd.
and wrote there:
RESTORE DATABASE master FROM DISK = 'c:\master.bak'
I'm getting an error:
RESTORE DATABASE must be used in single user mode when trying to restore the
master database.
what am I missing'
Thanks in advance
joujI've discovered why. :$
I wasn't using the sqlservr.exe from MSSQl$MyInstanceName\Binn.
My problem now is the server version. I think I should install a Service
Pack for that the versions match.
Thanks.
"jouj" wrote:
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore the
> master database.
> what am I missing'
> Thanks in advance
> jouj|||sqlservr.exe -c - m -s {instancename}
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:C13BA8B2-490A-4365-8591-82C84F2BB0FB@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000.
> I stopped the SQL Server and the SQL Agent services.
> and from the prompt:
> sqlservr.exe -s MyInstanceName -c -m
> then from QA, I've entered my MyInstanceName, user: sa and pwd.
> and wrote there:
> RESTORE DATABASE master FROM DISK = 'c:\master.bak'
> I'm getting an error:
> RESTORE DATABASE must be used in single user mode when trying to restore
> the
> master database.
> what am I missing'
> Thanks in advance
> jouj

error to register the msde2000 in enterprise manager

Hi all,
can anyone tell what can i do to register the msde in enterprise manager, it prompt me the 'sa' login fail. should the name pipe
protocol included or TCP/IP is already ok? thanks.
hi,
"CWeb@.office" <a@.b.com> ha scritto nel messaggio
news:%23AcFcAioEHA.4032@.TK2MSFTNGP15.phx.gbl
> Hi all,
> can anyone tell what can i do to register the msde in enterprise
> manager, it prompt me the 'sa' login fail. should the name pipe
> protocol included or TCP/IP is already ok? thanks.
MSDE installs by default allowing only trusted connections and not SQL
Server authenticated connections
in order to modify this behaviour at install time you have to pass the
additional parameter
SECURITYMODE = SQL
to the command line setup.exe boostrappert installer
you can have a look at
http://support.microsoft.com/default...b;en-us;285097 for
additional information about that, including further info on how to change
this setting after install hacking the windows registry
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

Error running rs utility

Hi
Trying to render a report using rs utlitlity however I'm getting the
following problem
The command i issue in the command prompt is:
rs.exe -i RenderReport-SalesOrderMarkup.rss -s
http://server.com/ReportServer -u Domain\
george -p thepassword -v salesid="SO000644" -t
The result;
System.Exception: Could not connect to server:
http://server.com/ReportServer/ReportService.asmx
at
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
Any ideas why I'm getting this error?
Thanks
GeorgeJust guessing:
1. Can you go to IE and paste: http://server.com/ReportServer and it comes
back?
2. Can you rename: RenderReport-SalesOrderMarkup.rss, to something without
the "-"
Reeves
"_george" wrote:
> Hi
> Trying to render a report using rs utlitlity however I'm getting the
> following problem
> The command i issue in the command prompt is:
> rs.exe -i RenderReport-SalesOrderMarkup.rss -s
> http://server.com/ReportServer -u Domain\
> george -p thepassword -v salesid="SO000644" -t
> The result;
> System.Exception: Could not connect to server:
> http://server.com/ReportServer/ReportService.asmx
> at
> Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
> ty()
> at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> Any ideas why I'm getting this error?
> Thanks
> George
>
>