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

Microsoft SQL Server

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
James
Asked:
James
  • 6
  • 4
1 Solution
 
mordiCommented:
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
 
JamesSenior Cloud Infrastructure EngineerAuthor Commented:
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
 
mordiCommented:
What command is used in this script. Is it attach or detach?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
mordiCommented:
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
 
JamesSenior Cloud Infrastructure EngineerAuthor Commented:
Hi Mordi,

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

0
 
mordiCommented:
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
 
JamesSenior Cloud Infrastructure EngineerAuthor Commented:
There is another error "no connection to the database subuno".
0
 
JamesSenior Cloud Infrastructure EngineerAuthor Commented:
Hi Mordi,

I created a UDL file and connected to the database successfully. So, the problem is obviously with the software.
0
 
mordiCommented:
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
 
mordiCommented:
Did you copy the third party applic. also?
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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