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!
|
|
SLX V7.0.1 Attach remote fails
Posted: 07 Aug 07 9:00 AM
|
Good day,
I created a remote database in SLX V7 (SQL2005), and tried to attach it by double-cliking on the remote database file. It gets up to the point where the "Remote Database Setup" window is displayed, but immediately afer this, he following error message is displayed:
SalesLogix Attach Remote
Failed to attach database: Class not registered.
OK
I did install the SLX 7.0.1 remote client. Is there anything else that should be installed? Does anyone have any idea of the classes that must be registered in order to be able to attache a remote for V7.0.1?
Thanks
Ina |
|
|
|
Re: SLX V7.0.1 Attach remote fails
Posted: 07 Aug 07 1:43 PM
|
Questions:
Did you create a SQL 2005 database or a SQL 2000 database from the SQL2005 database?
Is the remote a MSDE 2000 or SQL Express remote?
Is MDAC 2.8 installed on the remote?
Is Microsoft .Net FrameWork 2.0 install in the remote?
|
|
|
| |
| |
| |
|
Re: SLX V7.0.1 Attach remote fails
Posted: 04 Sep 07 1:10 AM
|
Hi Frank,
This is my first time really working with remotes, so I'm not really sure..
I just used the "Tools -> Create Remote User Database" in the Architect to create the database. In the "Create Options", I selected "Create on SQL Host", which probably means that this database is also 2005. Is that correct?
For the remote, I just installed the SalesLogix Remote Client. I think that installs MSDE for you? Or do I need to install something seperate?
MDAC2.8 and .Net Framework 2.0 is installed on the remote.
Thanks
Ina
|
|
|
| |
|
Re: SLX V7.0.1 Attach remote fails
Posted: 04 Sep 07 6:58 AM
|
Originally posted by Ina Nortje
Hi Frank,
This is my first time really working with remotes, so I'm not really sure..
I just used the "Tools -> Create Remote User Database" in the Architect to create the database. In the "Create Options", I selected "Create on SQL Host", which probably means that this database is also 2005. Is that correct? |
|
Yes I would agree.
To check the MSDE version on the remote open a DOS box and type the following
osql.exe -U sa -Q "USE master SELECT @@version"
| For the remote, I just installed the SalesLogix Remote Client. I think that installs MSDE for you? Or do I need to install something seperate? |
|
As far as I know the V7.01 CD ships with MSDE 2000. So this means the remote database you cut will not work.
Try cutting a remote and select "Create on MSDE Instance from SQL Host".
|
|
|
|
Re: SLX V7.0.1 Attach remote fails
Posted: 04 Sep 07 9:42 AM
|
To further clarify (and I hope I am doing so),
SLX 7.01 doesn't "support" SQL Express (2005) for remotes. Remotes run MSDE 2000 (unless you went out of your way to install them with SQL Express, then this is what you are running).
So, if you are running MSDE 2000, you won't be able to attach a Remote Database cut on an SQL 2005 server.
In order to cut a remote, you will need to have either SQL 2000 or MSDE 2000 installed somewhere (this is what the Implementation guide may refer to as the Administrative Workstation)
Once you have a machine with the proper version of SQL2K/MSDE, you need to cut the remote database utilizing the "Create on MSDE Instance from SQL Host". You will need to provide the name of your SQL2K/MSDE instance, as well as the sysdba password on that machine.
Also, the Path to create the database will be located on the machine running the SQL2K/MSDE instance. |
|
|
|
Re: SLX V7.0.1 Attach remote fails
Posted: 04 Sep 07 10:22 AM
|
SLX 7.01 doesn't "support" SQL Express (2005) for remotes. Remotes run MSDE 2000 (unless you went out of your way to install them with SQL Express, then this is what you are running).
|
|
SQL Express was supported, though it had some issues. However, the SQL Express was not included on the SLX 7.01 CD (MSDE 2000 was).
For SLX7.2 SQL Express is included on the CD. MSDE 2000 remotes will still work but you have to jump through some hoops to create a MSDE 2000 remote. |
|
|
|
Re: SLX V7.0.1 Attach remote fails
Posted: 05 Sep 07 12:32 AM
|
Hi Frank,
I have now installed SalesLogix Administrator on a separate server (our application server), and I installed MSDE 2000 on there. I followed the instructions setting the SAPWD to SLXMaster by changing the .ini file. From there I am trying to cut a remote using the "Create on MSDE Instance from SQL Host".
In the MSDE Instance Name, I put the name of my application server (HI-SRV-02)
In MSDE sysdba password 'n put "masterkey" (Does this specify what the sysdba password will be, or what it currently is? If it specifies what it currently is, how will I know? Does the MSDE 2000 that ships with SLX 7.0.1 create the sysdba user with password masterkey?)
In the Host Database Owner Login, I use sysdba as username and masterkey as password.
In the Target Database Administrator login, I put sa in the username and SLXMaster in the password. (Is this what specifies the username and password with which to connect to the MSDE instance in order to create the database? In that case it should be sa and SLXMaster, am I correct?)
The problem that I have is that when I try to create the remote database, I get the error:
"Error in step: stpExecSQL_CreateDb Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
I checked in Services and my MSSQL$SALESLOGIX service is running.
Any idea what I should check next? |
|
|
|
Re: SLX V7.0.1 Attach remote fails
Posted: 05 Sep 07 5:46 AM
|
Ina,
Since you installed MSDE from the SLX CD I think the MSDE Instance Name syntax should be "MACHINENAME\SalesLogix". So for you that would be HI-SRV-02\SalesLogix.
Make sure the "Remote Path" is a LOCAL path on the Admin workstation. |
|
|
| |
| |
|