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 Server Validation Failed on New Install Eval and Empty Databases

Tim Conway
Posts: 41

Database Server Validation Failed on New Install Eval and Empty Databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 10 7:51 AM

On a new install. MS Server 2003

I am not able to create the databases. The error is

Database Server Validation Failed
and
MS SQLServer 2000 or higher not found on this machine

I have both SQL 2000 and 2005 installed. I'm searching for some answers but not finding anything. Have you run into this, do we have support with SLX.

Checked the services and they are all running

Any ideas

Thanks

Tim

[Reply][Quote]

Lane
Posts: 121

Re: Database Server Validation Failed on New Install Eval and Empty Databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 10 10:45 AM

you ned to give more info.
Is a AttachRemote issue or you can't manage the sqlserver?
Look at the service and get the instance name (it'll be the -s parameter of the command line)
Make sure you are connecting to it using the right syntax servername\instancename
then try NT authentication to connect, bother with sql authentication until NT works

[Reply][Quote]

Tim Conway
Posts: 41

Re: Database Server Validation Failed on New Install Eval and Empty Databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 10 11:30 AM

Thanks Lane

It's a clean install and I have SQL 2000 and 2005 installed. I did express install when done I noticed the databases were never created, Eval DB and Empty DB. So I went to the DVD and from Standard install I tried running "Install SQL Databases", which opens the SalesLogix Database Installation Utility. This dialog has "Copy Database From" (pointing to the DVD), checkboxes for Attach SLX Blank DB and Attach SLX Eval DB and the Button, Attach DBs. Pressing the button retuns the two error messages. At the bottom of this dialog in the Status bar is the message "Database Server validation failed. Please Try again."

On install, the SLX connection manager went ahead and created the two SLX database connections, production and eval. I want them to use SQL 2005. I tried editing these to use SQLclient and also tried OLEDB. Both succeed in the Test connection but the Database Utility still fails to see that SQL server exists on the Machine.

What I don't know is why it failed and what it is looking for.
In MS Manage Server\Services all SLX and SQL services are running.
Could it be a Ports issue?

I don't know what other information might be helpful.

Thanks

Tim

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Database Server Validation Failed on New Install Eval and Empty Databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 10 1:36 PM

Tim:

On the Installation Media, under the Database folder you will find the MDF files for the DBs.

You just need to:
- Create the Sysdba user
- Attach the MDF file(s)
- Map your Sysdba Server user to the DB user if needed

[Reply][Quote]

Tim Conway
Posts: 41

Re: Database Server Validation Failed on New Install Eval and Empty Databases Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 10 2:03 PM

Pure Genius! Worked perfectly. Why didn't I think of that?

Thanks

Tim

oh, one other thing, I also ran the SQL query in the same database folder on the DVD, sysdbafix_script.sql, on both databases to get them to connect.

Thanks for your help.

[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): 11/25/2024 12:50:18 PM