Registered users    
MembershipMembership:
Latest New UserLatest:Taganova Ronya
New TodayNew Today:12
New YesterdayNew Yesterday:9
User CountOverall:23415
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12968
Marina Roos12627
Eriq Neale2117
Stan Guinn1917
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren650
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Cannot Register SQL Server Instance
Prev Next
You are not authorized to post a reply.

Author Messages
Mike Bowling User is Offline
United States
Member since
9/7/2005

Registered Users
Posts: 2
6/30/2006 12:28 AM  
I have a new installation of SBS 2003 Premium. I currently have no SQL instances listed in Enterprise Manager under SQL Server Group. I'm attempting to register the first instance. When finishing the Register SQL Server wizard an error is returned: "SQL Server does not exist or access denied".
 
Also, in the Service Manager if I enter the servername\sharepoint it connects and starts. However, if the server is rebooted the Service Manager is not connected after the reboot. "Auto-start service when OS starts" is selected.
 
The following SQL Services are starting automatically.
MSSQL$MSFW
MSSQL$SBSMONITORING
MSSQL$SHAREPOINT
SQLAGENT$SBSMONITORING
 
Why is this error returned when attempting to register an instance?
"SQL Server does not exist or access denied".
 
Thank you.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
6/30/2006 12:54 AM  
Hi Mike,
 
Did you upgrade the Sharepoint MSDE to a SQL instance, as described in the Premiuminstallsteps.htm?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Mike Bowling User is Offline
United States
Member since
9/7/2005

Registered Users
Posts: 2
6/30/2006 02:13 AM  
Yes, MSDE has been upgraded to SQL Server 2000 SP4 per the documentation.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12627
7/03/2006 05:55 AM  
Hi Mike,
 
But you haven't installed a default instance of SQL server, as that would have automatically registered itself in Enterprise Manager. So you must be doing something wrong. You have replaced 'SERVERNAME' with the actual SBS servername, right?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Cannot Register SQL Server Instance


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.3437522 seconds.   :   Terms Of Use   :   Privacy Statement