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: SQL Express and SalesLogix Database Problem

Derek
Posts: 115

SQL Express and SalesLogix Database Problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Sep 08 4:01 AM

Installed SalesLogix and SQL Express and When I try to attach the database we get the following error.

Directory lookup for the file “c:\program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SLX_user_dat.mdf failed with the operating system error 5(error not found)

Any ideas what would be the cause of this

Thanks
derek

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: SQL Express and SalesLogix Database Problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Sep 08 12:29 PM

Hi Derek,

Is there some security issue with the user that is running the SQL Server process on this PC on that folder?

Stephen
www.slxmaster.com

[Reply][Quote]

Derek
Posts: 115

Re: SQL Express and SalesLogix Database Problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Sep 08 6:02 PM

Hi Stephen,
Thanks for your reply

Not sure what you mean?

This problem occurs when When I use Saleslogix, attach remote to attach the remote user database, I get that error.

Regards
Derek

[Reply][Quote]

Stephen Redmond
Posts: 190

Re: SQL Express and SalesLogix Database Problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 2:39 AM

Hi Derek,

When AttachRemote works, it first copies the database to the default SQL data folder (in your case, c:\program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\) then it calls into SQL Server to attach the database (probably calling sp_attach_single_file_db). Now, if there is a security issue with the user that is running the SQL Server service, one that means that it can't see the file, then you might get a file not found error (although I am just speculating here).

Did the file even make it into the c:\program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ folder?

You could try using AttachRemote \admin to attach the file in a different folder and see if that works. With the "\admin" switch, the file is not moved, it just tries to attach it wherever it is.

Stephen

[Reply][Quote]

Derek
Posts: 115

Re: SQL Express and SalesLogix Database Problem Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 08 2:53 AM

Hi Stephen,

Thanks again, I will check this out and let you know

Regards
Derek

[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:46:43 PM