Solomon is unable to login to the specfied database...

[S]

Hi

We have prepared the successful test Solomon database server, but for some
reason after performing some testing we are getting the following error
message, when we are trying to select system database from login screen:

"Solomon is unable to login to the specified database. Please specify the
password which is associated with the "sa" user .............."

To build the Solomon test database server we have followed the following steps

Microsoft SQL Server 7.0

a. Make a backup of the database that can be restored in case an unwanted
data loss occurs.
b. Make sure that all users have exited Microsoft Dynamics SL and that the
installation and customizations are operating correctly.
c. Click Start, click All Programs, click Microsoft SQL Server 7.0, and
then click Enterprise Manager.
d. Back up the System and Application database.
e. Restore the System and Application databases individually by typing the
new database name in the Restore database as field and then selecting the
database in the Show backups of database field.
f. Click OK. The database will restore by using the new name.
g. Open SQL Query Analyzer, access the new System database, and then run
the following statements:
UPDATE COMPANY SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'
UPDATE DOMAIN SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'

Note Replace XXXXXX with the new name of the application database, and
replace YYYYYY with the old database name.
h. Update the database views in the Database Maintenance (98.290) window.
To access the Database Maintenance (98.290) window, click Start, click All
Programs, point to SolomonIV, and then click Database Maintenance.
i. Connect to the server. If you do not do this, you receive the following
error message:
Company Configuration Error: Company CompanyName not properly matched to
System database DatabaseName
j. On the Update Databases tab, verify that the correct database name is
selected in the System Database Name field.
k. Select the company.
l. Click Update Views.
m. Log on to Microsoft Business Solutions - Solomon by using the
appropriate SQL Server name and the appropriate Solomon system database name.

To troubleshoot this issue, I will appreciate if someone can help me.

Thanks

[Dan Shepherd]

First, and foremost... What version of SL are you running? If you are
running SQL 7 you have to be running SL 6 or prior (I think). Did you create
the new DB's using DB Maintenance as well? Always the easiest method.
Also.. make sure you synchronize all ownership. The Master60 user probably
is not right.

[S]

Thanks Dan for quick replay.

1. We are using Solomon IV on top of MS SQL 7.

2. Created the system and company database and restored the data from
production

3. Followed the steps mentioned below

Thanks

[Dan Shepherd]

What version of Solomon IV??? It was called that for many, many versions.

[S]

Solomon IV
Version: 4.21 SP2.1442

[Dan Shepherd]

Did you change DB servers? Is the SA password the same? I did not notice
that you did not mention that. If you changed DB servers then you must run
the following command:

Update Domain set ServerName = 'xxx' where ServerName = 'yyy'

[S]

1. No "sa" password is different

2. Yes did run

Update Domain set ServerName = 'xxx' where ServerName = 'yyy'

For detail steps from a to m, please see below,

Many thanks

[Dan Shepherd]

The only other thing I can think of is to delete your Solomon.ini file and
relaunch.

[S]

There is no Solomon.ini, on client

[Dan Shepherd]

Can you login to Solomon on the "new" server? If you can, and cannot on the
client, did you uninstall and reinstall the client using the path to the new
server share? Also - Make sure you share one directory above the application
files so that Parent.exe is as follows: S:\SLIV\Parent.exe

[S]

I will uninstall and reinstall the citrix client and will update you

Thanks for your help

[S]

No Progress.

1. I have uninstall and deleted all the files belongs to Solomon client

2. From same client I can able to login Production and Development but for
some reason can not able to login New test environment

Any help will be appreciated

Thanks,

[Barry Flynn]

You mentioned at the start of this thread that when you try to login, you
get a message "Solomon is unable to login to the specified database. Please

specify the password which is associated with the "sa" user .............."

What happens after you type in the sa password?

And - who is the Owner of both the System and Application databases?

Barry

--

Barry Flynn
Complete Solutions DG

"S" <S...@discussions.microsoft.com> wrote in message
news:C509C8A1-3BDF-4864...@microsoft.com...

[S]

Thanks Barry for replay,

1. Again promt for the "sa" password

2. User "master" is the owner of all companies and "SYSTEMPROD" and
"SIVApplication2" Database

3. User "sa" is the owner of "master" ,"model", "msdb", "Northwind", "pubs"
and "tempdb" database.

Thanks

[Barry Flynn]

What happens after you enter the sa password for the second time?
It does ask twice (I think once is for its "setting up" of the system
datrabase, and once for the application database.)

You did say that this was a test system didn't you?
With no other Solomon databases on that particular SQL Server?
If so, and if entering sa password for the second time doesn't help, I
suggest:-
- change the system & application databases to be owned by sa
- delete the Master & MasterRO logins (these are the two logins used by
Solomon). But do this ONLY if there are no other working Solomon datavases
on that SQL Server. If there ARE, then by definition the two logins are "OK"
and they should be retained.

Then attempt to login to Solomon.
As I recall the process, it will detect if no Master/MasterRO logins exist,
and will create them to its own "specifications".
And it will detect that the two databases are not owned by Master, and will
change the ownership of both to the newly created Master login.
In the course of doing that, it will ask you for the sa password twice.

Hope that's some use.

Barry

--

Barry Flynn
Complete Solutions DG

"S" <S...@discussions.microsoft.com> wrote in message

news:3DB96215-4721-4AC1...@microsoft.com...

[S]

Thanks Barry.

Now I can able login to Solomon

Performed the following tasks:

1. Deleted the master and masterro users
2. Login to Solomon and entered the "sa" password

But when I am changing the password of "master" to same as production, I am
getting the same error message.

Is there is any why to change the password of master to same as production ?

Thanks

[Barry Flynn]

Are you changing the Master paswsword in SQL Server, or are you doing it
from within Solomon?
As I recall 4.21, it must be done from withiin Solomon.

Barry

--

Barry Flynn
Complete Solutions DG

"S" <S...@discussions.microsoft.com> wrote in message

news:447E128B-FE16-4EDA...@microsoft.com...

[S]

I am changing in SQL Server.

In Solomon I can able to change the password for only Solomon users not
database users (master)

Thanks,

[Barry Flynn]

You MUST change it from within Solomon (otherwise Solomon does not know the
password, and it can't log in.)

Offhand I forget where you change it (its not the "set users password"
screen.)
I'll have a dig around to see if I can find where you do it.

Barry

--

Barry Flynn
Complete Solutions DG

"S" <S...@discussions.microsoft.com> wrote in message

news:E1F4C002-2999-4549...@microsoft.com...

[Barry Flynn]

Memories of 5.5 & earlier are fading a bit, but I think this is it.

Go to Utility/Database_Administration (98.270).
There will probably be more than 1 grid line.
Pick the line with a blank Database Name (probably the first.)
Go to the Password field & enter the new Master password.

Barry

--

Barry Flynn
Complete Solutions DG

"Barry Flynn" <Anonymouse> wrote in message
news:%23mMlH60...@TK2MSFTNGP03.phx.gbl...

[S]

From Solomon I can able to change the password of Only Solomon users.

(Utility >> Password >> Type Old and New Password)

Thanks For your help

[S]

I have sucessfully changed the password of "master"

Can able to connect to SQL Server through "master" user by using new password

But when I login to Solomon I am getting the same error message:

"Solomon is unable to login to the specified database ................."

[Barry Flynn]

Did you use the Solomon Database Administration (98.270) screen to change
the Master password?

Barry

--

Barry Flynn
Complete Solutions DG

"S" <S...@discussions.microsoft.com> wrote in message

news:E36F6877-5D11-4875...@microsoft.com...