larryjhawkins
asked on
Problems installing SMS 2003 on W2K3 - SQL server not found
I am tring to setup SMS 2003 in a test lab to evaluate it and I cannot get it to connect to the SLQ server. Her is the setup log. Any ideas???
-------------------------- ----
Site Information:
Site code: HKN
Site name: *************
Site domain: HAWKCON
Extend AD schema: No
Security Mode: Advanced
Number of clients: 100
Components Selected:
Systems Management Server: Yes
SMS Administrator Console: Yes
Remote Tools: Yes
SMS Installation Directory: F:\SMS
SQL Server Information:
Computer running SQL Server: HC-SRVR-DL380\S (I use the SQL Server Service Manager with this name to connect to services)
SQL Server 2000
Use integrated security.
SMS Site Database Information:
Database name: SMS_HKN
SMS Site Database Information:
Number of SMS Administrator consoles: 5
Minimum number of SQL Server connections: 75
Automatically configure the SQL connections: Yes
Provider Location:
SQL Server computer
******** END SUMMARY INFORMATION ********
<11-13-2006 18:20:11> Starting evaluation process.
<11-13-2006 18:20:11> Enough free disk space.
<11-13-2006 18:20:11> Checking domain for advanced security, PDC for domain HAWKCON is \\HAWKCONSERVER04
<11-13-2006 18:20:32> No server type detected from registry
<11-13-2006 18:21:14> The NT machine HC-SRVR-DL380\S that's running the SQL server is down.
<11-13-2006 18:21:22> Verified machine account by installing service SMS_ACCOUNT_TEST_SERVICE
Error message I get
The Windows server HC-SRVR-DL380\S that is running the SQL Server is down or not on the network, or your current Windows logon ID does not allow you to access the Windows server.
--------------------------
Site Information:
Site code: HKN
Site name: *************
Site domain: HAWKCON
Extend AD schema: No
Security Mode: Advanced
Number of clients: 100
Components Selected:
Systems Management Server: Yes
SMS Administrator Console: Yes
Remote Tools: Yes
SMS Installation Directory: F:\SMS
SQL Server Information:
Computer running SQL Server: HC-SRVR-DL380\S (I use the SQL Server Service Manager with this name to connect to services)
SQL Server 2000
Use integrated security.
SMS Site Database Information:
Database name: SMS_HKN
SMS Site Database Information:
Number of SMS Administrator consoles: 5
Minimum number of SQL Server connections: 75
Automatically configure the SQL connections: Yes
Provider Location:
SQL Server computer
******** END SUMMARY INFORMATION ********
<11-13-2006 18:20:11> Starting evaluation process.
<11-13-2006 18:20:11> Enough free disk space.
<11-13-2006 18:20:11> Checking domain for advanced security, PDC for domain HAWKCON is \\HAWKCONSERVER04
<11-13-2006 18:20:32> No server type detected from registry
<11-13-2006 18:21:14> The NT machine HC-SRVR-DL380\S that's running the SQL server is down.
<11-13-2006 18:21:22> Verified machine account by installing service SMS_ACCOUNT_TEST_SERVICE
Error message I get
The Windows server HC-SRVR-DL380\S that is running the SQL Server is down or not on the network, or your current Windows logon ID does not allow you to access the Windows server.
ASKER
Great, I found the client utility and created the alias but the installation still bombs. The SQL Server Service Manager has the server in it but the are no services shown for it. How do I debug the Alias to ensure it is setup properly ?
ASKER
Also I am using Windows 2003 R2 Advanced Server if it makes a difference !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Using SMS with SQL 2000 Named Instances
http://www.databasejournal.com/features/mssql/article.php/1459961