slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Database loginfailed :catastrophic Failure

NagaratnaPandi
Posts: 111

Database loginfailed :catastrophic Failure Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jul 09 10:50 AM

Hi all,

I took a backup of the saleslogix db from my local system and installed it on the Test db server .I created a different username for sysdba. And i was able to connect thru connection manager but when i connect thru the datalink manager i am getting an error "Database loginfailed :catastrophic Failure".

I have also run the sysdba script .

can we use a diffrent user other than sysdba.

Please help me to slove this issue.

Thanks,
Pandi

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Database loginfailed :catastrophic Failure Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Jul 09 11:30 AM

If the objects are accessible (and probably owned by the new user).

In other words, SLX will not issue the following query: SELECT * FROM SYSDBA.ACCOUNT
it will do : SELECT * FROM ACCOUNT

So, if you login with the new user to MAnagement studio and run a query, you shouldn't have to include the owner name on the query. Once you get that working, it "should work".

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Database loginfailed :catastrophic Failure Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Jul 09 1:36 AM

In SQL Server 2005 and above, users no longer own objects. A new concept - called a schema - was introduced, and it is the sysdba schema which, by default, owns the SalesLogix objects.

The sysdba schema is owned by the sysdba user, so this distinction is not necessarily obvious.

But maybe you can create a different user and grant them ownership of the sysdba schema - at the same time making sysdba their default schema, so that queries like select * from Account continue to work as expected.

Then again, maybe it won't. I've never tried. It's much easier to go with the flow and use sysdba like everyone else.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Database loginfailed :catastrophic Failure Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jul 09 4:54 AM

Quote:

Originally posted by Phil Parkin

In SQL Server 2005 and above, users no longer own objects. A new concept - called a schema - was introduced, and it is the sysdba schema which, by default, owns the SalesLogix objects.

The sysdba schema is owned by the sysdba user, so this distinction is not necessarily obvious.

But maybe you can create a different user and grant them ownership of the sysdba schema - at the same time making sysdba their default schema, so that queries like select * from Account continue to work as expected.

Then again, maybe it won't. I've never tried. It's much easier to go with the flow and use sysdba like everyone else.

Phil, thanks for the clarification, I was indeed just trying to keep it simple.

Also, I do agree with you regarding sysdba.
It is much simpler to just change the default password.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Database loginfailed :catastrophic Failure Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jul 09 5:02 AM

Hi Raul

My answer was aimed at the OP, not you. I know from reading your other posts that you know your stuff! But SQL Server is, perhaps, the one area where I can compete

Cheers
Phil

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/25/2024 6:36:28 PM