If you don't have mixed mode authentication (windows and sql) then you will
not be able to use the local administrator.
Gary
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 07, 2004 10:32 AM
Subject: [Rodopi] What do you do if you lose the SA password
> Hi Suneel -
>
> It is still saying:
>
> SQL Server error 08001 occurred in module RODOPI Procedures Server:
>
> [08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does
> not exist or access denied.
>
> Thanks...Tim
>
>
> ----- Original Message -----
> From: "Suneel Jhangiani" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, June 05, 2004 2:25 PM
> Subject: [Rodopi] What do you do if you lose the SA password
>
>
> 1. Login to the SQL Server box as the Administrator.
> 2. Run SQL Server Enterprise Manager.
> 3. Right-click the server name and choose 'Edit SQL Server Registration
> properties'.
> 4. Choose 'Use Windows authentication' and click OK button.
> 5. Expand a server, expand a Security and click Logins.
> 6. Double-click the sa login and specify new password on the General tab.
>
>
> -----
> Why not have your cake and eat it too - it's cake, what else are you going
> to do with it?
>
> (--------------------------------) {((((((
> ( Suneel Jhangiani ) /_ _ )
> ( Technical Director ) ( . . )
> ( Inter-Computer Technology Ltd. ) ( / )
> (----------------------------------oOOo------------oOOo----)
> ( 40 James Street Tel: +44 (0) 20 7486 9601 )
> ( London W1U 1EU Fax: +44 (0) 7050 678 978 )
> ( United Kingdom Email: [EMAIL PROTECTED] )
> ( Website: http://www.inctech.com )
> (----------------------------------------------------------)
> ________________________________________
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of technical
> Sent: 04 June 2004 20:36
> To: [EMAIL PROTECTED]
> Subject: [Rodopi] What do you do if you lose the SA password
>
> Hi - What do you do if you lose the SA password?
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
>
>
> I have no idea what it could be?
>
>
> Thansk...Tim
>
>
>
>
>
>
>
> ---------------------
> To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
> with the word LEAVE as the message body.
>
> Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
> ---------------------
>
>
>
>
>
>
> ---------------------
> To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
> with the word LEAVE as the message body.
>
> Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
> ---------------------
>
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------
