• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

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
0
195ecentralave
Asked:
195ecentralave
2 Solutions
 
mlmccCommented:
DId you open the reports and change the dtat source?

How are you running the reports?

mlmcc
0
 
jogosCommented:
Transfering databases to another server could orphin the users.

Check out doc about sp_change_users_login.
0
 
rboyd56Commented:
This error indicates that the login information is incorrect:

Login Failed for user “tm7user”

Either the login does not exist or the password is wrong. Verify that the login exists in SQL Server. This is a standard SQL login, not an NT authentication.

Also check to see if SQL Server is set for mixed authentication. If it is set for NT only then SQL authenticated connections will fail. You can check this under the properties of the SQL Server instance under the Security tab in Enterprise Manager

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
195ecentralaveAuthor Commented:
mlmcc, how do i change the data source in the report?
0
 
mlmccCommented:
To change the data source
Open the report in Crystal
Click DATABASE --> SET LOCATION
Follow the prompts

mlmcc
0
 
195ecentralaveAuthor Commented:
I also had to change all the login info, as suggested by rboyd 56, so it really took two answers.
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now