Could we discuss Web Data Administrator one last time?

I installed MSDE (SQL2KDeskSP3) from the command prompt with the following command line:

Setup.exe /qb+ INSTANCENAME=newsdb_engine DISABLENETWORKPROTOCOLS=1 SAPWD=dotNet

I then installed WebDataAdmin using all of the defaults.

I opened WebDataAdmin and at the login entered these credentials:

Username: sa
Password: dotNet
Server: newsdb_engine

Each time the error is returned that the username or password is invalid and/or the server does not exist.

So I tried a different server name, adding the computer name:
Server: AZT12YXM/newsdb_engine

Same error message occurred.

Then I read that SQL Authentication mode has to have the correct registry setting.
I went to HKLM/Microsoft/MSSqlServer/MSSqlServer/ and changed the login from "1" to "0"
and rebooted.

Same error message occurred.

I do have a developer edition of SqlServer 2000, but I want to be able to install msde and configure it without enterprise tools so that msde is the sole database engine (for deployment reasons).

Could someone suggest a list of steps from start to finish for installing msde on a machine where the instance you create is the sole database on the target machine and how to configure it to be Web Data Administrator "friendly"?

Maybe this could be the "one-stop" Web Data Admin keyword search thread.

Thank you.The servername should be: MachineName\InstanceName

Cheers
Ken

Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2

Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express?
I DownLoad the tool named XM.exe,but It's only a Query tool and I have to do everything using scripts.I realy want to know Is there a tool that I can use to Create db and restore db and backup db and create table etc. like the Admination tools in SQL 2000 ?

Thanks for u kindness.

Tonny.

You can use the tools that come with the June CTP Developer Edition.

|||

Thanks for ur kindness ,and Is it a single tool or integrated with the SQL2005 TCP Developer Version?Is it free to download?If yes, Could u tell me where Can I Download the tool or Where Can I DownLoad the SQL 2005 TCP Developer Version?

Thank u again.

Tonny.

|||

SQL Server Express Edition did not originally ship with any type of Management Tools. After SQL Server 2005 Service Pack 1, you have the option to download SQL Server Management Studio Express with SQL Server Express Edition with Advanced Services.

Compare the new offerings: http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in S

Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express?
I DownLoad the tool named XM.exe,but It's only a Query tool and I have to do everything using scripts.I realy want to know Is there a tool that I can use to Create db and restore db and backup db and create table etc. like the Admination tools in SQL 2000 ?

Thanks for u kindness.

Tonny.

You can use the tools that come with the June CTP Developer Edition.

|||

Thanks for ur kindness ,and Is it a single tool or integrated with the SQL2005 TCP Developer Version?Is it free to download?If yes, Could u tell me where Can I Download the tool or Where Can I DownLoad the SQL 2005 TCP Developer Version?

Thank u again.

Tonny.

|||

SQL Server Express Edition did not originally ship with any type of Management Tools. After SQL Server 2005 Service Pack 1, you have the option to download SQL Server Management Studio Express with SQL Server Express Edition with Advanced Services.

Compare the new offerings: http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/