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 Guinn1918
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren654
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: How to administor sql 2k on sbs2003?
Prev Next
You are not authorized to post a reply.

Author Messages
Dan Morphis User is Offline
United States
Member since
5/25/2005

Registered Users
Posts: 2
5/25/2005 06:19 AM  
Pardon my ignorance on this matter.  I'm more familiar with the full blown version MS SQL Server.  I'm trying to do some configuration of the sql server on SBS 2003, however I can't find any of the admin tools like enterprise manager.  I'm trying to set the SA password to blank (Don't ask, third party software requires it), however I can't find anything to do that.

Any help you can provide would be greatly appreciated.

-dan
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
5/25/2005 09:25 AM  
To change the password from the command line on MSSQL Server or MSDE:
  1. Open a command shell by selecting "Start"-->"Run...", and typing "cmd.exe" in the "Run" dialog box.
  2. Change to the directory in which the MSSQL or MSDE utilities are stored (this is ususally C:\MSDE\binn, C:\MSSQL7\binn, etc., but YMMV).
  3. Issue the following command where <newpassword> is the password you have chosen:
    osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"
Mariëtte Knap 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'
Dan Morphis User is Offline
United States
Member since
5/25/2005

Registered Users
Posts: 2
5/25/2005 06:15 PM  
Thank you for your help.null When I issue that command I get the following error message:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

The server is a stock Dell PowerEdge w/ SBS Premium.
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
5/25/2005 10:54 PM  
You need to add the instance and server name to the command. This KB article will help you:
 
How To Verify and Change the MSDE System Administrator Password:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336
Mariëtte Knap 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 > How to administor sql 2k on sbs2003?


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.312502 seconds.   :   Terms Of Use   :   Privacy Statement