Solved

Microsoft SQL Server

Posted on 2011-02-28
10
310 Views
Last Modified: 2012-05-11
Hi Experts Exchange,

A client of ours is using a third party application on an old server. I have installed a new SBS 2003 Server and installed Microsoft SQL Server 2000. I have copied the database from the old Server to the new Server, but when I try and connect to the database from the third party application I get an error (open method OLEAuth object failed).

I have installed the Microsoft SQL Server 2000 in mixed mode authentication as the application will only work in mixed mode. From the error message this indicates a authentication issue. It is using the SA account which is correct.

Please can somebody help me with this issue.


Thank you Experts Exchange.
0
Comment
Question by:JBond2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 3

Expert Comment

by:mordi
ID: 34998742
The problem is with your  copy of the the database.
You have to do a backup restore of the database or detach attach approach.
0
 
LVL 15

Author Comment

by:JBond2010
ID: 34998785
We did a copy and paste of the database and then used a script to load the database. We have done on other new installs and this worked.
0
 
LVL 3

Expert Comment

by:mordi
ID: 34999020
What command is used in this script. Is it attach or detach?
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 3

Expert Comment

by:mordi
ID: 34999128
You just need to do the following:
1. right click on the database and select properties  and record data and log files locations
2. right click on the database and select all tasks -->detach database
3. copy the data and log files to the second  server
4. start enterprise manager  on the second server
5.right click on the databases folder and select all tasks -->attach database
6. in the MDF file field enter the data file path that was copyied to the second server
0
 
LVL 15

Author Comment

by:JBond2010
ID: 35005205
Hi Mordi,

Thank you for your help, but the problem still remains. The error is (open method OLEAuth object failed).

0
 
LVL 3

Accepted Solution

by:
mordi earned 500 total points
ID: 35005696
I would check the OLEDB connection  from the server running the third party applic. to the database by creating a  .udl file on this server.
Then double click on it and choose the oledb provider for sql server, then in the connection tab server name and user sa and its password , then click on test connection button.
It its successfull then may be the applic. uses the NT authentication  so you just try the same as before with a the NT username used by the applic.
0
 
LVL 15

Author Comment

by:JBond2010
ID: 35005787
There is another error "no connection to the database subuno".
0
 
LVL 15

Author Comment

by:JBond2010
ID: 35006882
Hi Mordi,

I created a UDL file and connected to the database successfully. So, the problem is obviously with the software.
0
 
LVL 3

Expert Comment

by:mordi
ID: 35009150
If you connected ok from same server were application is running then the application maybe connecting with another user or provider. You can check the sql server errorlog to see what user fails to connect . Also you can see there other errors.
0
 
LVL 3

Expert Comment

by:mordi
ID: 35009279
Did you copy the third party applic. also?
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IF SQL Query 12 29
SQL Distinct Question 3 15
Convert time stamp to date 2 57
Why do I get an error when executing a stored procedure using SQL Server 2008? 1 7
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question