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!
|
|
Error RE Creating remote user database
Posted: 16 Jul 08 2:55 PM
|
Hi,
I have a problem
I creating a remote user database and ocurrs the following error
------------------------
[07/16/2008 13:36:12]Detaching remote db...
[07/16/2008 13:36:12]Detaching remote dB error: The database 'SLX_pcando'does
not exist. Use sp_helpdb to show avalible databases
Database creataion canceled.
------------------------
Anybody can help me ???
Why occurs that
 |
|
|
|
Re: Error RE Creating remote user database
Posted: 16 Jul 08 6:09 PM
|
Originally posted by Patricia Capuz
Hi,
I have a problem
I creating a remote user database and ocurrs the following error
------------------------
[07/16/2008 13:36:12]Detaching remote db...
[07/16/2008 13:36:12]Detaching remote dB error: The database 'SLX_pcando'does
not exist. Use sp_helpdb to show avalible databases
Database creataion canceled.
------------------------
Anybody can help me ???
Why occurs that
|
|
Please your Help.
I have a Problem creating remote databases.
I have installed Saleslogix Server on A Virtual Machine. I am working with Saleslogix 6.2.6.
I Installed SLX Administrator on the SalesLogix Server (Virtual Machine) too.
When I Connect to SLX Administrator in SalesLogix Server (Virtual Machine) and I Try to create remote user database the following error occurs:
------------------------
[07/16/2008 13:36:12]Detaching remote db...
[07/16/2008 13:36:12]Detaching remote dB error: The database 'SLX_pcando'does
not exist. Use sp_helpdb to show avalible databases
Database creataion canceled.
------------------------
But When I try to create remote user database, connecting directly SLX Administrator installed on a PC with Windows Xp, the database is created without any problem.
My problem is when I trying to create remote databases on Slx Server (Virtual Machine).
Anybody knows How to fix this Problem or Why this Problem Occurs??
Thanks in Advance,
Paty
|
|
|
|
Re: Error RE Creating remote user database
Posted: 17 Jul 08 9:24 AM
|
Hi Paty,
What version of SQL Server?
Is the Administrator that is working installed on the same server as the SQL Server?
Have you checked where the Database is being created in Options? - (Create Remote DB in server directory) this should be a share on the SQL server that the database is being cut on.
Cheers,
Steve |
|
|
|
Re: Error RE Creating remote user database
Posted: 17 Jul 08 9:39 AM
|
Hi Paty,
If you are doing this on SQL 2005 you will need to install the following on your Virtual Machine:
1. MSDE v8
2. SQL Native Client
When you cut the database you need to select "Create on MSDE Instance from SQL Host" in Options on the Create Database screen.
Cheers,
Steve |
|
|
|
Re: Error RE Creating remote user database
Posted: 17 Jul 08 2:04 PM
|
Hi Steve!!!
Thanks for your help.
Well.
My slx architecture is the following:
I have installed the SLX database on a Virtual Machine on a Server (Databases Server). This virtual machine is Working with SQL 2000 sp4.
Also, I have installed the SLX Server (including Sync and Speed Search) and SLX Administrative Tools on a Virtual Machine on other Server (Applications Server). This virtual machine is working with Ms Windows 2003.
I have a PC (Windows XP). I installed the SLX Administrative Tools on that PC too.
SLX Administrator is not installed on SLX DB server(VM on Databases Server), only on SLX SERVER(VM on Applications Server) and other(s) PCs.
I checked all SYNC configuration and that is correct. In CREATE DATABASE OPTIONS, the Folder specified for REMOTE PATH is "H:\Temporal\" and it was created on DB SERVER (VM), and also It ´s shared.
When I create the remote Database in SLX Administrator on a pc or other machine,the creation is successfull; but why when I am trying to create It in SLX Administartor on SLX SERVER (that is virtual machine), that error occurs.
I need to knows, Why that error ocurrs ????
.
.
.
Is necesary to install
1. MSDE v8
2. SQL Native Client
, if I 'am working with SLQ 2000 on the Virtual Machine on DB Server.
Thanks,
Paty
|
|
|
| |
|
Re: Error RE Creating remote user database
Posted: 18 Jul 08 3:56 AM
|
Hi Paty,
Check on the SQL Server that the SLX_pcando database is not already there in SQL server.
Check that there is not an SLX_pcando.mdf or SLX_pcando.ldf file in the H:\Temporal folder.
Try removing the final "\" from "H:\Temporal\" in the "Create Remote DB in server directory" path.
As you are on SQL 2000 there is no need for MSDE or the SQL Native Client - they are only needed for SalesLogix 6.2 (Service Pack 3 upwards) running on SQL 2005.
Cheers,
Steve |
|
|
| |
|