|
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: Yesterday @ 12:10:08 PM
Posts: 1,327, Visits: 3,471 |
| | I would like to deploy packages remotely. Is it possible to use a TCP/IP library with the Dbengine? This is how I've connected normal SF apps to remote db via a vpn. Or is there another way? I'm cautious about installing an app on a production db server. |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| | SQL Server fully supports TCP/IP as does the DDT. If the specified host name or IP can be resolved and the SQL Server accessed and authenticated, then the DDT can deploy to it. |
| |
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: Yesterday @ 12:10:08 PM
Posts: 1,327, Visits: 3,471 |
| I knew that SQL server supports TCP/IP, as I've been using it for a couple of years with my app 
I'm glad DDT supports it too 
Now, how? I've attempted to deploy my security db right from DDT to my remote server. It bombs. I know I have a connection to the server, as SQL Server Management Studio is connected, via TCP/IP (and I've deployed a number of other changes to the db through it). I tried the server name, the IP and the IP:port. All failed, reporting that a connection to SQL server couldn't be established, and to try my settings again. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| | At what point does it "bomb" and how are you attempting to deploy it? Are you using the DatabaseMigrator class or deploying through the DDT? Also, what type of connection is this? If there is a VPN then there should be no issue, but if these are just exposed ports then there could be some issue there in the connection. We use SMO (the same thing as SQL Server Management Studio) to actually connect to the server. We authenticate the connection first before doing anything else. |
| |
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: Yesterday @ 12:10:08 PM
Posts: 1,327, Visits: 3,471 |
| At what point does it "bomb"
When authenticating, on page with server name and authentication information.
how are you attempting to deploy it? Are you using the DatabaseMigrator class or deploying through the DDT?
Using the deploy database wizard directly in the DDT
Also, what type of connection is this?
I have access to port 1433 and terminal services on port 3389.
If there is a VPN then there should be no issue, but if these are just exposed ports then there could be some issue there in the connection.
Whenever I connect to the db, I have to indicate the network library to use and also use the IP. This is how I connected to it within SQL Server Management Studio.
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| | More than likely there is a port that you do not have access to. Have you tried to put a packet sniffer on the network to see what ports are trying to be accessed? This is how we figure out those types of issues. |
| |
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: Yesterday @ 12:10:08 PM
Posts: 1,327, Visits: 3,471 |
| Well, I did some sniffing....and it worked. The DDT had no problem connecting. I'm guessing I probably fubared typing in the password, or used a non-server admin account or something stupid like that. Thanks for the help and sorry for the trouble.  |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:50:35 PM
Posts: 4,796, Visits: 4,766 |
| Well, I didn't think it made any sense  I am glad you got it working. |
| |
|
|