Login fail for admin

[PBuckwalter]

I created a new test database on our test SQL 2008 server.  I took a backup of our live database and restored it to test.

I ran the update script for the sysdba.

I blanked the admin password

I updated the ping server in the systeminfo table to point to the correct server.

I have the sql native drivers installed.

On my "connection" server I can set up a connection to the test database thru connection manager with sysdba and the test connection is successful.

However...

When I try to set up any connection in the datalink manager the test is unsuccessful.  grrrrrrrrr

No firewall

Tried by IP to rule out DNS.

Anyone have any insight as to why the admin cannot log in.  (or any known users for that matter)

[AdamTravers]

Check out page 31 of the Sage SalesLogix implementation guide.

(Microsoft SQL Server 2008 Only) On the All tab:
a. Double-click Persist Security Info.
b. In the Property Value drop-down list, select True.
c. Click OK.
d. Double-click Integrated Security.
e. Click Reset Value.
Data may exist that does not display in the Value field. This value must be reset to
ensure that all data is removed.
f. Click OK.
7. (Oracle Only) On the All tab:
a. Double-click Extended Properties.
b. In the Property Value box, type chunksize=3000.
You must set the Property Value if you plan to create custom views that will be included
when you create a remote database. If the value is not set, the SQL View is truncated
on the remote database.
c. Click OK.
8. Click OK to save the information and close the Data Link Properties dialog box.

[PBuckwalter]

That didnt work either.  When I try to login I get "Database login failed: Unspecified error"

Its like the datalink doesnt know the admin or any user anymore. 

[AdamTravers]

A few more suggestions for you..

Ensure that the correct version of the SQL Server 2008 Native Client is installed, as Microsoft has released a version for 32-bit (x86) and 64-bit (x64) systems.

Remove the System Admin Role from the sysdba user with in SQL.

On Windows 7 workstations in a SQL Server 2008 or SQL Server 2008 R2 environment, ensure that the following components are installed:

SQL Server 2008 Native Client
SQL Server 2005 Native Client
SQL Server 2005 Backward Compatibility

[AdamTravers]

Also, check the SLX Compatibility guide to ensure you are running a supported environment..?

http://www.empath-e.com/documents/v754/ReleaseNotes/Sage_SalesLogix_2011_Compatibility_Checklist_v7....

[RJLedger]

In 64 bit environments you (sometimes) have to also install the SQL2005 native client (as well as the 2008).

[PBuckwalter]

System admin role was not assigned to the sysdba

I looked over the compatibility document..For the version Im on (7.5.3.4227) recommends SQL SP2 so I installed that.

I've uninstalled any sql driver and reinstalled both 2005 and 2008 64bit.

Still cannot login   

[MikeSpragg · Accepted solution]

Drop ***everything** that you've done (so that we know where we are)

- Drop the DB

- Drop the sysdba user

- Drop the connection you made

- In SQL Studio, under Security|Logins, create a sysdba user - just give it the name sysdba, password of masterkey and ensure the enforce password policy is off

- Create your new database

- Under Security|Logins, dbl click the sysdba user, go to user mappings and enable the new database with db_owner and public only.

- Now, restore your database over the top

- Run the sysdba fix script (as you did before)

- In SLX ConnMgr - cerate the new connection (follow exactly the steps that Adam sent that deals with the persistence on passwd). Look here for graphics.

That's it - should all work.

[PBuckwalter]

That worked!!

Thank you all for your help.