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 warren651
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: SA Not associated with a trusted SQL Server connection.
Prev Next
You are not authorized to post a reply.

Author Messages
paul burke User is Offline
United Kingdom
Member since
1/4/2006

Registered Users
Posts: 5
2/27/2006 05:03 PM  
any assistance on this would be great...
 
I am running SBS Server 2003 & Microsoft SQL Server 2000 - 8.00.760
This server is hosting the named instance of MSDE
From a cmd prompt I type osql -U sa which then prompts for password...
I type in old password (hasnt been changed) - then get error
 
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
 
Firstly I checked to see if  SQL Server was set to “mixed mode” authentication.  I checked it out and SQL Server was set to “Windows only“ mode.  That's easy enough to change.  Changed it and restarted the MSSQLSERVER service.
Mixed Mode authentication is enabled, the LoginMode subkey [HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%MSSQLServer\LoginMode] value is 2.
So now I tried chaining the 'sa' password
From a cmd prompt I type osql -E sa
then sp_password @old = null, @new = ,  @loginame ='sa' then [on next line] I type go
and password changed successfully.
Restart the MSSQLSERVER and the SQLSERVERAgent services.
[have also tried powercycle of server]
From a cmd prompt I type osql -U sa
type in press enter
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
paul burke User is Offline
United Kingdom
Member since
1/4/2006

Registered Users
Posts: 5
2/28/2006 07:34 PM  
after a little frustration and some great advice, issue sorted...

I installed the SQL Server 2000 eval version - just to get the client tools installed
Used enterprise manager to register and connect to the MSDE instance using Windows auth
Used the GUI to easily change the sa password and also verify in the server properties window that mixed mode authentication enabled.

This can all be done via TSQL (Through your OSQL command line) but knowing the the particular params of all the procs is a different story (and I don't think MSDE has Books Online) and it is easier to use the GUI for some of the adhoc changes such as mixed vs windows only mode...

PS - I hate SQL

:)
Mariette Knap User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12968
2/28/2006 09:29 PM  
I love SQL...this site runs on it
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 > SA Not associated with a trusted SQL Server connection.


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