Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, May 26, 2020 
 
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 ThreadView:  Search:  
 Author  Thread: SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.
Karna Taneja
Posts: 26
 
SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 26 Feb 13 10:25 PM
fiogf49gjkf0d

Hello, A couple of our remote users(WINDOWS 7 Machine) getting the error "Database login failed: unspecified error." while login through SLX Client.


They had a new remote DB cut and DB were attached successfully.


- Tried recreating datalink and database connections. From Connction Manager DB connction is tested successfully. However from SLX Client the test connection is getting Failed.


- All Users are running under global firewall setting so not a firewall issue either.


I stopped SLXSystem.exe .while restarting it not able to restart...throwing error like"....not responded in timely fashion..."


Please help how to troubleshoot this "Database login failed: unspecified error."

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Feb 13 2:08 AM
fiogf49gjkf0d

If the database is a remote database then you can run Connection Manager - set the connection name to (Local) and then re-create the connection in SLX to this new connection (probably best to delete both connmgr and client entries to be sure). That way you'll avoid the network and be accessing locally and avoid any f/wall issues. Which SQL Provider are you using with 2005? MSSQLOleDB or Native Client?

[Reply][Quote]
Karna Taneja
Posts: 26
 
Re: SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Feb 13 2:43 AM

In connction Managr we are using SQL Native Client.

[Reply][Quote]
Karna Taneja
Posts: 26
 
Re: SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Feb 13 2:48 AM
fiogf49gjkf0d

Should I create the connection in the same way in Client? Thanks

[Reply][Quote]
Mike Spragg
Posts: 1226
Top 10 forum poster: 1226 posts
 
Re: SQL Server 2005, 7.5.4 LAN, Database login failed: unspecified error.Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 27 Feb 13 2:57 AM

In a remote situation the host & remote are one and the same:


In Connection Manager - specify the connection to the SQL Server - in here, set connection as (Local) - unless you are using a named instance - in which case, go with standard hostname but make sure it resolves and tests. The connection will use a provider which should be SQL Native client. You will use sysdba/masterkey as login details.


In SLX Client (Admin, Architect etc) you will then define the connection (using Data Link Manager, the ellipses) to create a connection to the provider. In here you will drop down the SLX server and then the connection defined above. You will use the SLX Username/password here.


However: On logging in - it will interrogate the server via connmgr and attempt to open the same connection that SLX Server does - using the same SQL Provider (SQL Native Client) so it will hit the same firewall issues as if it were connecting across the network. So, using firewall manager ensure the SQL Server ports are open and also ports 1706-1707. I generally create a rule that enables 1706-1707,1433-1434 to enable all.


Also, run CliConfig and make sure the connection settings are TCP-IP.

[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 © 2020 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 5/26/2020 1:21:11 PM