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 not find stored procedure 'SP_DBOPTION'.

Hi All,
Command:
SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
Error Message:
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'SP_DBOPTION'.
I am getting the above message when I run the said
command. I tried to locate the resolution at several
places and no help
Thanks,
Mohammed Sarwar
Ocp Dba Oracle 9i, 8i, 8.0If you have a case-sensitive installation, you need to specify the
stored procedure name in lower case:
EXE sp_dboption 'ORDERDB', 'SELECT INTO', 'TRUE'
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Mohammed Sarwar" <MSarwar@.uBid.com> wrote in message
news:29fe001c391dd$1012bfd0$a601280a@.phx.gbl...
> Hi All,
> Command:
> SP_DBOPTION 'ORDERDB', 'SELECT INTO', 'TRUE'
> Error Message:
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'SP_DBOPTION'.
> I am getting the above message when I run the said
> command. I tried to locate the resolution at several
> places and no help
> Thanks,
> Mohammed Sarwar
> Ocp Dba Oracle 9i, 8i, 8.0
>|||Dan,
Super! That worked.
Thanks,
Mohammed Sarwar
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Could not bulk insert

Dear All,
Im trying to execute the follownf command:
(BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
from Query analyzer and I get the message:
(Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because
file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
opened. Operating system error code 5(error not found).)
what might be the problem:
Hi,
This error normally comes when you are not able to access the remote share.
The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.
Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>
|||1. \\server\shared is relative to the sqlserver.
2. check to see if the NT acct used to start sqlserver service has access to
network shared. LocalSystem acct will not have any access to network
resources.
-oj
http://www.rac4sql.net
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>

Could not bulk insert

Dear All,
Im trying to execute the follownf command:
(BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
from Query analyzer and I get the message:
(Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because
file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
opened. Operating system error code 5(error not found).)
what might be the problem:Hi,
This error normally comes when you are not able to access the remote share.
The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.
Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>|||1. \\server\shared is relative to the sqlserver.
2. check to see if the NT acct used to start sqlserver service has access to
network shared. LocalSystem acct will not have any access to network
resources.
-oj
http://www.rac4sql.net
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>

Corrupted sysindexes

After running the command dbcc checkdb, which is part of a weekly job the following returned
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
Considering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>
|||I'm going to create a DTS package and move the database over to anthor DB.
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend.
There was no going back because a number of days had pasted.
Doing the above DTS method, there is no loss in data.

Corrupted sysindexes

After running the command dbcc checkdb, which is part of a weekly job the following returne
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2)
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdConsidering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>|||I'm going to create a DTS package and move the database over to anthor DB
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend
There was no going back because a number of days had pasted
Doing the above DTS method, there is no loss in data.