Cannot install SMS2003 Primary Site with SQL2000sp3a

Help~!

we got problems installing SMS 2003. it is when we try to install SMS 2003,
it always pop a window say cannot locate the SQL Database or you dont have
appropriate rights to access it. but we build that SQL Server 2000 sp3a right
on the server which we are trying to install SMS, and the Database is
accessable from LAN user, we tried SQL authentication mode, and use the su
account.

and we got this message at last:
The Windows server ITSZ-NETFINITY that is running the SQL Server is down or
not on the network,or you current windows login ID does not allow you to
access the Windows server.


Product Registration:
Name: Netfinity
Organization: iTSZ
CD Key: 270-6671126

Site Information:

Site code: 100
Site name: iTSZ-netfinity
Site domain: ITSZ

Extend AD schema: No

Security Mode: Standard
Service account name: ITSZ\SMSService

Number of clients: 100

Components Selected:
Systems Management Server: Yes
SMS Administrator Console: Yes
Remote Tools: Yes

SMS Installation Directory: C:\SMS

SQL Server Information:
Computer running SQL Server: ITSZ-NETFINITY
SQL Server 2000
Do not use integrated security.

SQL Account For SMS Site Database:
SQL Server login ID: sa

SMS Database Creation:
Automatic

SMS Site Database Information:
Database name: SMS_100

SMS Site Database Directory:
C:\SMSDATA

SMS Site Database Information:
Number of SMS Administrator consoles: 5
Minimum number of SQL Server connections: 75
Automatically configure the SQL connections: Yes

******** END SUMMARY INFORMATION ********

<10-28-2005 11:07:03> Starting evaluation process.
<10-28-2005 11:07:03> Enough free disk space.
<10-28-2005 11:07:03> The domain and PDC checked out OK.
<10-28-2005 11:07:10> The NT machine ITSZ-NETFINITY that's running the SQL
server is down.
<10-28-2005 11:07:10> Checking disk space for SQL devices (SMS database).
<10-28-2005 11:07:11> SmsLsaAccount returns 0 Flags = 30000h
<10-28-2005 11:07:22> Verified service account by installing service
SMS_ACCOUNT_TEST_SERVICE



--
....sigh
.

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)
Loading