September 27, 2006 at 11:50 am
i could not connect to SQLServer 2000 DB.
The error message while trying to connect to the DB
http://imgfly.com/files/270906_104634/web1.JPG
this is what i have in my DB
http://imgfly.com/files/270906_104634/web2.JPG
pleease suggest , how do i able to connect ?
September 27, 2006 at 11:56 am
Do you use mixed mode authentication (sql or windows authentication)?
September 27, 2006 at 12:05 pm
i think you are asking for this
http://imgfly.com/files/270906_110055/web3.JPG
How can i solve this problem
September 27, 2006 at 12:13 pm
and one more thing...
suppose,if i forget my password...then do i have to uninstall SQL server ?
can i get back passwrd from SQL Server ?
September 27, 2006 at 12:16 pm
I know there's a way to do it but I never had to put it in use so I forgot how.
Anyway I don't have much else to offer. Surely somebody will figure this one out for you.
Good luck!
September 27, 2006 at 11:49 pm
someone please help.
do you think..i am making mistake in password ?
do i need to reinstall ?
is there any way to recover password (i dont think i am putting wrong password but to make sure can i check it?)
what is the problem actually ? i am not able to diagonise it.
do i need any patch ?
do i need to upgrade ?
September 28, 2006 at 3:10 am
Spectra,
Are you attempting to connect to the database via an application? If so then connecting using the sa password is very bad practice due to the sa account having full permission to the SQL Server. It's best to setup a new login and user fspecific to the application.
Can you also check if your server is configured for Mixed mode authentication? Right click the server in EM and select properties, select the 'Security' tab and then check which Authentication option is selected, if it is set to 'Windows only' then you won't be able to use the 'sa' login (or any other SQL Server logins), even if you are getting the password correct.
If you need to reset your 'sa' Login password you need to login to the server with an NT Login that is a member of the 'BUILTIN\Administrators' active directory group (by default this is any domain administrator account or any account with admin rights on the server), you can then right click the 'sa' login and change the password.
ll
September 28, 2006 at 10:38 am
Spectra, you didn't type the password wrong, you would have gotten a different error. Please check out this page and see if it makes it clearer what others are trying to say here about trusted connections:
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
