Re: ODBC login problem

Thanks Sue

1) Your Question: > Is the new server setup for both Windows and SQL
Authentication? Did you add the login to the SQL Server 2005
server?

I am using the built-in account on the local system as shown in the "SQL
Server properties" in the SQL Configuration Manager.

From there I perform the following:
under "Administrative Tools" I select the "ODBC Data Source Administrator",
where I enter data in the "Microsoft SQL Server DSN Configuation".
Here I select the second option button: "With SQL Server Authentication
using a login ID and password entered by the user."
I also tick "Connect to SQL Server ..." and enter my Login ID and my Password.

My new Login ID and Password do not work with the newly created login and
Password using:
CREATE LOGIN MyLogin
WITH PASSWORD = 'asecrtpasw0rd',
DEFAULT_DATABASE = MyDatabase
GO

The same error results:
"Login failed for user 'XXXXX'. The user is not associated with a Trusted
SQL Server connection".

2) The results from your procedure: EXEC sp_change_users_login 'Report'
gave me 2 x UserName and 2 x UserSID

The UserSIDs I have never seen or used before: Should they be familar?

Thanks

"Sue Hoegemeier" wrote:

Is the new server setup for both Windows and SQL
Authentication? Did you add the login to the SQL Server 2005
server?
You can also check for users not mapped to a login as well
as map users and SQL logins using sp_change_users_login. To
list the users, execute the following in the database:
EXEC sp_change_users_login 'Report'
See books online for more information on
sp_change_users_login

-Sue

On Mon, 11 Jun 2007 01:39:02 -0700, Calculator
<Calculator@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

This is possibly related to my restoration of the MS SQL DB from MSSQL 2000
to MSSQL 2005:

I backed up a database from MSSQL 2000 to move to a new server running MSSQL
2005.

The DB appeared to restore without a problem (although not yet confirmed);
however, my ODBC login is now not accepted?

In setting up the ODBC DSN configuration, I use my old SQL Server
Authentication login and password, which I get the following error message:

"Login failed for user 'XXXXX'. The user is not associated with a Trusted
SQL Server connection".

My ODBC login was what I used on my MSSQL 2000 setup and I presume the
backup and restore would copy these Authentication securities across to the
MSSQL 2005 setup?

Please let me know what I have overlooked.

Thanks


.