Problem recovering old database

> I need to resurrect an old info database from a ms sql 7 server backup
(generated from a sql
> maintenance plan). I have recovered the master, model and msdb databases
as well as the old info
> database. Unfortunately the sa password has been lost and once I recover
the master DB, I cannot
> log on to the query analyser to get the info I need. I have tried both sql
authentication and nt windows
> 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...
> 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...
> > I need to resurrect an old info database from a ms sql 7 server backup
> (generated from a sql
> > maintenance plan). I have recovered the master, model and msdb
databases
> as well as the old info
> > database. Unfortunately the sa password has been lost and once I
recover
> the master DB, I cannot
> > log on to the query analyser to get the info I need. I have tried both
sql
> authentication and nt windows
> > 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...
> > 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.
> >
>
>|||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...
> 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...
> > > I need to resurrect an old info database from a ms sql 7 server backup
> > (generated from a sql
> > > maintenance plan). I have recovered the master, model and msdb
> databases
> > as well as the old info
> > > database. Unfortunately the sa password has been lost and once I
> recover
> > the master DB, I cannot
> > > log on to the query analyser to get the info I need. I have tried both
> sql
> > authentication and nt windows
> > > 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...
> > > 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.
> > >
> >
> >
> >
> >
>