Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Problems installing SMS 2003 on W2K3 - SQL server not found

Posted on 2006-11-13
4
Medium Priority
?
470 Views
Last Modified: 2008-01-09
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.

0
Comment
Question by:larryjhawkins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Expert Comment

by:oBdA
ID: 17940419
SMS doesn't like named instances. Either use a standard instance, or try if this workaround helps:
Using SMS with SQL 2000 Named Instances
http://www.databasejournal.com/features/mssql/article.php/1459961
0
 

Author Comment

by:larryjhawkins
ID: 17951884
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 ?
0
 

Author Comment

by:larryjhawkins
ID: 17956646
Also I am using Windows 2003 R2 Advanced Server if it makes a difference !
0
 
LVL 85

Accepted Solution

by:
oBdA earned 2000 total points
ID: 17959487
Sorry, SQL is not my specialty; you might want to put a pointer to this question in the SQL TA.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question