Please help.....

We had a NT4 server with SQL 7 installed. AS it happened the machine complete
bombed out. I managed to copy the data folder from the SQL installation
diretory before the whole hdd went up in flames.
I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
and I really want to import this database into SQL 2000.
I have attached the database succefully and can see it there. Even the OBDC
test is successfull. However the application which is CRM Superoffice doens;t
want to log on as it says invalid username and password.
I am sure that I might have missed seomthing. Do I first need to some
coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
we no longer have SQL 7 but just the data directory of that installation. No
backups were done of this machine ( as usual )
Can I do anything at all?
Please, any help is appreciated.
Regards
Gian
Gian
Did you move all logins from source database to the destination?
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Sounds like the database is fine, but you may need to reattach database user
accounts.
See sp_change_users_login to see if you just need to realign the database
user accounts with the logins
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Hi,
Since you did an attach of databases, I am sure that you have not moved the
system databases from sql 7 to sql 2000.
All the SQL server logins will be kept in master database. So since you have
not copied the logins the SID in syslogins will not
match with SID in sysusers of each database. To resync the syslogins with
sysusers, refer the procedure "sp_change_users_login"
in sql server books online.
One more thing is after sync. you may need to make the CRM user to default
to that user database using the below system procedure
sp_defaultdb 'login_name','database_name'
Thanks
Hari
MCDBA
"Gian" <Gian@.discussions.microsoft.com> wrote in message
news:E0696A35-26A3-4FAA-BA1C-78E08275F81D@.microsoft.com...
> We had a NT4 server with SQL 7 installed. AS it happened the machine
complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+
megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the
OBDC
> test is successfull. However the application which is CRM Superoffice
doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind
that
> we no longer have SQL 7 but just the data directory of that installation.
No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian
|||Gian,
Things to check.
1) Did you import all the logins from the old server?
2) Are the logins mapped to the correct users in your attached database?
sp_change_users_login can help here.
3) Is the security mode the same as the old server? i.e. are you using
Windows Authentication Only or Mixed mode? Check that this is correct
because a standard SQL login will not be allowed on a Windows
Authentication Only server.
Also have a look at:
Microsoft Knowledge Base Article - 224071
Moving SQL Server databases to a new location with Detach/Attach
http://support.microsoft.com/?id=224071
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gian wrote:
> We had a NT4 server with SQL 7 installed. AS it happened the machine complete
> bombed out. I managed to copy the data folder from the SQL installation
> diretory before the whole hdd went up in flames.
> I am basically stuck now with *.mdf and *.ldf which both are about 100+ megs
> and I really want to import this database into SQL 2000.
> I have attached the database succefully and can see it there. Even the OBDC
> test is successfull. However the application which is CRM Superoffice doens;t
> want to log on as it says invalid username and password.
> I am sure that I might have missed seomthing. Do I first need to some
> coverting of some sort from a SQL 7 to SQl 2000 database? Keep in mind that
> we no longer have SQL 7 but just the data directory of that installation. No
> backups were done of this machine ( as usual )
> Can I do anything at all?
> Please, any help is appreciated.
> Regards
> Gian