Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Thursday, July 10, 2025
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
7/10/2025 3:29:56 AM
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 - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the
code of conduct
for posting guidelines.
Forums RSS Feed
Back to Forum List
|
Back to General Administration
|
New Thread
View:
Dynamic
Flat
Tree
Search:
Author
Thread: Remote DB Creation error
Rekha
Posts: 72
Remote DB Creation error
Posted: 18 Dec 07 8:11 PM
******************************************************************
I am getting the following error while creating remote DB. Any help in this regard would be appreciated...
******************************************************************
[12/18/2007 8:59:24 PM]Starting step: stpExecSQL_CreateDb
[12/18/2007 8:59:57 PM]Error in step: stpExecSQL_CreateDb Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
[12/18/2007 8:59:57 PM]Finished step: stpExecSQL_CreateDb
[12/18/2007 8:59:57 PM]
Step: stpExecSQL_CreateDb returned error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Step: stpExecSQL_InitDb did not execute. See previous error.
Package Execution Stopped. Total execution time: 33.0310 sec.
See error description above.
Database connection information:
SourceServer- sqlservername\sqlserverinstance
TargetServer- appservername\databasename
AdminUserID- sa
AdminPWD- ****
NewOwnerUserID- sysdba
NewOwnerPWD- ****
[12/18/2007 8:59:57 PM]Detaching remote db...
[12/18/2007 9:00:14 PM]Detaching remote DB error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
Database creation cancelled.
I have a stored procedure created in DB through SQL 2005. I am not getting any errors in a different machine with same settings I tried creating remote DB. However, in a different machine this is causing issue.
I have MSDE instance as appservername\saleslogix
MSDE Password: masterkey
Host uid: sysdba
Host pwd: masterkey
target uid: sa
target pwd: SLXMaster
I have correct folder settings for remote DB and has full write permission. why is it not creating remote DB? I have created remote DB several times and succeeded several times. but this time its not resolving properly. The same thing was working in same machine several times.
[
Reply
][
Quote
]
Frank Chaffin
Posts: 475
Re: Remote DB Creation error
Posted: 19 Dec 07 5:09 AM
Check the connection in the Connection Manager to see what Provider is selected. It needs to be the SQL Native Client.
Did you reboot the SQL Server and SLXServer?
[
Reply
][
Quote
]
Robert Levine
Posts: 132
Re: Remote DB Creation error
Posted: 19 Dec 07 8:51 AM
I'm just think out loud, but I'll bet you have to use the SQL Native Client rather than the OLE-DB connection method. SQL2005 is great as a primary server, but the MSDE used for the remotes is not a match as it is a version of SQL2000. Try to set up a secondary Slx Administrative Workstation based on the SQL Native Client connection to the SQL2005 server and install MSDE on this secondary Admin. Workstation. The SQL Native Client software should be available on the install DVD or you could get it from the Microsoft site. Then try to generate a new remote DB on the secondary Admin Workstation.
[
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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.
code of conduct
|
page cache (param): 7/10/2025 3:31:04 AM