Run the RodopiConfiguration utility which should have been installed on
the Web Server to reconfigure Rodopi Database Access.
You should ideally add a new user to your SQL Server and restrict the
login for that user to your Rodopi databases. Then configure Rodopi to
use this login as opposed to configuring it for SA login.
---
At the end of your rope? Tie a knot and swing.
(--------------------------------) {((((((
( 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 )
(----------------------------------------------------------)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 07 June 2004 15:33
To: [EMAIL PROTECTED]
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 )
(----------------------------------------------------------)
________________________________________
---------------------
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
---------------------
