October 1, 2002 at 12:54 pm
Tried to change SA password via Enterprise Manager and receiving the following error: Error 21776:[SQL-DMO]The name 'dbo' was not found in the Users collection. If the name is a qualified name, use[]to separate various parts of the name, and try again.
Tried using the following:
sp_password [[@old =] 'oldpassword',] {[@new =] 'newpassword'} [,[@loginame =] 'sa']
Results: [ODBC SQL Driver] Syntax error or access violation.
Can anyone out there provide some guidance on this problem?
October 1, 2002 at 3:08 pm
Here are some KB articles that are probably relevant:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q218172
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305711
The first speaks directly to the issue you are having. The second gives another possible reason for the error you are seeing. The format for sp_password is:
EXEC sp_password
@old = 'oldpassword',
@new = 'newpassword',
@loginame = 'sa'
The EXEC is optional if the stored procedure is the first and/or only line in a query.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply