Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 16th March 2009, 20:04
instant000 instant000 is offline
Member
 
Join Date: Jan 2008
Posts: 59
instant000 is on a distinguished road
Baan: BAAN IV - DB: Oracle 9I - OS: HP-UX 11;Windows Server 2003
Post Problem with Convert SSA ERP User to Database User
Baan: ERP LN 6.1
DB: SQL Server 2005
OS: Windows 2003
C/S: Both

When attempting to run the session for Convert SSA ERP User to Database User, we have issues. I think the error message explains my problem, please assist ...

Here are the steps we follow.


1) create user in OS – I have already created user “user01” with password “********”
2) from session ttaad2500m000 – create a new baan user by inserting a new record or copying existing user (need baan password “******”
3) change system login to user01 (if copied from some other user)
4) convert to runtime from specific menu


5) Convert SSA ERP user to database users (here database comes into picture)

There are two ways

5-a) we can use existing windows authentication to access db
Press the convert button, system will prompt for sa credentials.

5-b) we can create a new db user in db
in this option, db user and password should be given with default password checkbox checked.
It need not be same user baan user and password. We can generate a new db user and password and link to user01
For convenience, we always keep it same.

In both cases, baan user is automatically linked to db

6) Convert to runtime from links between db user and baan user session if ttstpoledaemon error occurs

Our case has got stuck in step 5 where we need help from infor.



Just so you know while answering this question, this is the configuration:

BaanAppServer = Windows 2003, w/ Baan LN 6.1
BaanDBServer= Windows 2003, w/ SQL 2005

Users are created locally on BaanAppServer.

Our current workaround is to manually create the user within SQL on the BaanDBServer, and then manually connect the BaanDBUser to the BaanUser, using a different session than this one.

Hopefully, someone can have an idea of what my problem might be.

Here is the error message:
Error from Database: Error-1, [MSQL logon failed. Connect error 0 from 'Microsoft-SQL-DMO (ODBC SQLState: 08001) as 'sa' to server '.' [Microsoft][OBDC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.

I think my problem is that the session is attempting to connect to local BaanAppServer, rather than connect to remote BaanDBServer, since it says "." ... I think that "." usually means connecting to yourself, like in most directory languages, "." means connecting to yourself.

Is this my problem? How do I repair it? Is there a place to correct this linking?

Thanks!

Last edited by instant000 : 16th March 2009 at 20:12.
Reply With Quote
Sponsored Links
  #2  
Old 17th March 2009, 18:29
instant000 instant000 is offline
Member
 
Join Date: Jan 2008
Posts: 59
instant000 is on a distinguished road
Baan: BAAN IV - DB: Oracle 9I - OS: HP-UX 11;Windows Server 2003
Post Repaired the problem!

The key to this problem was the "."

After repairing the config for the location of the DBServer, with the assistance of Infor, it worked. (Yes, I am so lame as to not know how to configure this stuff.)

Thanks!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Workshop Sharepoint integration with SSA BAAN ERP ssaerpnow General Discussion & Chat 0 13th May 2006 20:37
For View/Edit the Script we changes in session ttams1151m000 learn_ln6 Tools Development 2 25th April 2006 08:18
SSA ERP LN and Remote Connectivity baaniac General Discussion & Chat 2 22nd March 2006 08:16
Invitation to SSA Global's BaaN User Group Meeting in Bangkok nopadon ไทยฟอรัม 0 12th January 2005 20:25
Creation of a baan user linked to a database user maximus Operating Systems & Databases 17 23rd April 2002 13:44


All times are GMT +2. The time now is 12:20.


©2001-2017 - Baanboard.com - Baanforums.com