Msg 15406, Level 16, State 1, Line 1

Cannot execute as the server principal because the principal "LIMSUSA" does not exist, this type of principal cannot be impersonated, or you do...

Not sure where to check this one:

1 The Trusted Connection box is not selected in the System DSN definition.

I believe I'm in mixed...

OK still getting error message:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login in failed for user 'LIMSUSA',LIMSPROD

This message appears when trying to connect on the front end client on another machine. Pipes...

ok just did a search on update statistics and found this:

Update statistics - To help optimize query performance, we recommend that you update statistics on all databases following upgrade. Use...

I would suggest following :-

1. Execute sp_help_revlogin on sql server 2000 and save the output.

2. Take backup of sql server 2000 database and restore on Sql Server 2005 on other...

when running

use master

exec sp_help_revlogin

get this error message:

Server: Msg 2812, Level 16, State 62, Line 2

Could not find stored procedure 'sp_help_revlogin'.

I've seen a couple of copies of the sp_help_revlogin which...

OK I am going to remove the SQL 2005 instance on server and re-install to make sure I start from scratch. But what do you mean by Update statistics...

OK, I remembered that I had an evaluation version SQL 2000 from a SQL class I took. I installed it on my computer versus the server. So now...

I do see in my 2000 instance db that can't connect to any computers, that LIMSUSA which is the one having a login error has is the owner to 5...

When running the sp_change_users_login @Action='Report' under master db I get nothing. That is nothing appears in the report.

I had to do a restore. Our server crashed and all we have was the .bak file. I was able to build an SQL 2000 server on a...

OK I may have gotten the master copied over, not sure. Another question I do have. In my databases that run through the ODBC on the computers I...

OK when I tried to restore to 2005 it gave as Master_2000 it have me an error, something about sys....something existed already. I installed a version of 2000 on...

I'm sorry george sibbald, I think I may HAVE a .bak of the master file on my backup tape the night before the server crashed. What do I need...

[highlight=#ffff11]are you connecting to SSMS with the same ID as when you try and connect from the App?

Have you installed the 2005 instance to use mixed mode authorisation?

Does the login...