Re: ODBC login problem

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

.

Relevant Pages

  • Re: Cant Connect
    ... Then it's likely the authentication settings on the IIS side ... Try adding the IUSR account as a login in SQL Server ... > Cn.open CnStr ...
    (microsoft.public.sqlserver.connect)
  • Re:changing sa password / login
    ... authentication and it worked. ... >I think you might have made changes to SQL Server ... >Authentication" can not recognize SA login which is SQL ... >configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... > If you use NT authentication, a user's permissions to a database are ... Your assertion that a user's permissions are independent of the application ... Even using Access and "exploring" will require an ODBC login to SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re:changing sa password / login
    ... I think you might have made changes to SQL Server ... to make was using Mixed Authentication which will ... Authentication" can not recognize SA login which is SQL ... configuration to use mixed authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Kerberos / Authentication to SQL2K
    ... use Windows integrated security for database access. ... That SQL Server be running on the same computer as IIS. ... > authentication until I switched on impersonation either. ... > When set up on my web server however, I get the "Login failed for user ...
    (microsoft.public.dotnet.framework.aspnet)