195ecentralave
asked on
cant connect to sql2000 db. login failed for user - this is a new domain install upgrade from workgroup
We just moved our sql 2000 database to a new server, new instance of sql and migrated from a workgroup to a domain. I went into the workstation, xp-pro, and in admistrative tools, data sources, and changed the database location to the new instance of sql. the connectivity test there succeeded (but not on antoher machine for reasons i dont understand). now, when in crystal reports, trying to access the databse (the database is fine, working and accessed by everyone on the timematters system we use) I get the following: Logon failed. Details ado error code :0x80040e4d Source: Microsoft OLE DB Provider for sql server Description Login Failed for user “tm7user” sql state : 42000 Native Error: 18456 (database vendor code: 18456) What can i check to fix this? the new sql instance is the default, local instance and all users are domain users in the new domain.
thanks, experts
thanks, experts
Transfering databases to another server could orphin the users.
Check out doc about sp_change_users_login.
Check out doc about sp_change_users_login.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mlmcc, how do i change the data source in the report?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I also had to change all the login info, as suggested by rboyd 56, so it really took two answers.
Glad i could help
mlmcc
mlmcc
How are you running the reports?
mlmcc