Problem recovering old database

> I need to resurrect an old info database from a ms sql 7 server backup
(generated from a sql

quote:

---

> maintenance plan). I have recovered the master, model and msdb databases

---

as well as the old info

quote:

---

> database. Unfortunately the sa password has been lost and once I recover

---

the master DB, I cannot

quote:

---

> log on to the query analyser to get the info I need. I have tried both sql

---

authentication and nt windows

quote:

---

> authentication.
> can anyone point me in the right direction to reset or recover?
> Thanks
> Si

---

The error messages that I get when trying to log into querry analyser are:
Using Windows NT Authentication
Unable to connect to Server \\SQL-SERVER1:
Server: Msg 18456, Level16, State1
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'SQL-SERVER1\administrator'
----
--
Using SQL Authentication
Unable to connect to Server \\SQL-SERVER1:
Server: Msg 18456, Level16, State1
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'
Thanks
si
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:zFzg4Zn6DHA.568@.cpmsftngxa07.phx.gbl...

quote:

---

> What error message do you get when you attempt to login using the sa
> account?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

---

Any reason you need the system databases? You can restore the the old user
database to a new system. You will need to use sp_change_users_login to
remap the usernames to logins, but the data should be just fine. You can
even restore to an SQL 2000 host system.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"John Smith" <so@.funtime.com> wrote in message
news:1075904525.255819@.smtp-1.griffin.com...

quote:

---

> (generated from a sql
databases[QUOTE]
> as well as the old info
recover[QUOTE]
> the master DB, I cannot
sql[QUOTE]
> authentication and nt windows
> The error messages that I get when trying to log into querry analyser are:
> Using Windows NT Authentication
> Unable to connect to Server \\SQL-SERVER1:
> Server: Msg 18456, Level16, State1
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> 'SQL-SERVER1\administrator'
> ----

---

--

quote:

---

> --
> Using SQL Authentication
> Unable to connect to Server \\SQL-SERVER1:
> Server: Msg 18456, Level16, State1
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'
> Thanks
> si
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:zFzg4Zn6DHA.568@.cpmsftngxa07.phx.gbl...
rights.[QUOTE]
>
>

---

|||I want to restore the server "as was" for a period of time. I thought I
could just follow the notes supplied by microsoft on moving databases to a
new server. They recommend that the system databases are first restored.
Thanks for the help
si
"Geoff N.Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:ugObu9y6DHA.4012@.tk2msftngp13.phx.gbl...

quote:

---

> Any reason you need the system databases? You can restore the the old

---

user

quote:

---

> database to a new system. You will need to use sp_change_users_login to
> remap the usernames to logins, but the data should be just fine. You can
> even restore to an SQL 2000 host system.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "John Smith" <so@.funtime.com> wrote in message
> news:1075904525.255819@.smtp-1.griffin.com...
> databases
> recover
> sql
are:[QUOTE]
> ----
> --
'sa'[QUOTE]
> rights.
>

---