Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Entire 2005 Database deleted

The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.

Enterprise Manager Registration

Hi,
I have an SQL Server(2000) registration(SQL Authentication:sa).
I changed the sa password and deleted the registration.
Now I cannot re-create the registration using:
User=sa
Password=newpasssword
An error occured: Login failed for user 'sa'...
I re-put the old password(another registration on another PC) and the proble
m persist(on my PC).
Note: I made a successful registration using another login name and password
but not for 'sa'.
Any help will be very appreciated.
Thanks in advance
Regards
G.HaddadJouj wrote:

> Hi,
> I have an SQL Server(2000) registration(SQL Authentication:sa).
> I changed the sa password and deleted the registration.
> Now I cannot re-create the registration using:
> User=sa
> Password=newpasssword
> An error occured: Login failed for user 'sa'...
> I re-put the old password(another registration on another PC) and the
> problem persist(on my PC). Note: I made a successful registration
> using another login name and password but not for 'sa'.
You must have entered/changed the sa password wrong... try changing it again
and see if it fails with "Old (current) password incorrect for user. The
password was not changed." with your newpassword
sp_password @.old = 'old_password' , @.new ='new_password', 'sa'
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||hi,
The new(previous) password is correct 100%, from another machine I can conne
ct.
Only from my PC I cannot neither using Enterprise manager nor the Query Anal
yzer.
I suspect that it's a matter of registry :S.
Thanks again
Regards,
G.Haddad

Enterprise Manager Registration

Hi
I have an SQL Server(2000) registration(SQL Authentication:sa).
I changed the sa password and deleted the registration
Now I cannot re-create the registration using:
User=sa
Password=newpasssword
An error occured: Login failed for user 'sa'...
I re-put the old password(another registration on another PC) and the problem persist(on my PC)
Note: I made a successful registration using another login name and password but not for 'sa'
Any help will be very appreciated
Thanks in advanc
Regard
G.HaddadJouj wrote:
> Hi,
> I have an SQL Server(2000) registration(SQL Authentication:sa).
> I changed the sa password and deleted the registration.
> Now I cannot re-create the registration using:
> User=sa
> Password=newpasssword
> An error occured: Login failed for user 'sa'...
> I re-put the old password(another registration on another PC) and the
> problem persist(on my PC). Note: I made a successful registration
> using another login name and password but not for 'sa'.
You must have entered/changed the sa password wrong... try changing it again
and see if it fails with "Old (current) password incorrect for user. The
password was not changed." with your newpassword
sp_password @.old = 'old_password' , @.new ='new_password', 'sa'
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||hi
The new(previous) password is correct 100%, from another machine I can connect
Only from my PC I cannot neither using Enterprise manager nor the Query Analyzer
I suspect that it's a matter of registry :S
Thanks agai
Regards
G.Haddad