Can't Connect to StrataFrame database.

Author Message
 Posted 7/18/2016 9:23:37 AM
Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: Awaiting Activation
Last Login: 3/2/2020 12:19:05 PM
Posts: 595, Visits: 3,807
I'm getting an error when trying to create a deployment package saying the user cannot log onto the StrataFrame database. We recently move the StrataFrame database to a new server. After moving the DB we deleted the connection files on the developer PCs restarted Visual Studio, opened an existing project and selected the new database location when prompted by the connection wizard. Everything seems to work ok except I cannot create a deployment package from a project that existed prior to moving the database. I can create a new project and everything works fine. Does the DDT hold onto the prior connection information someplace? I can use the same windows user in SQL Management Studio and connect to the StrataFrame database with no problem so I can't see how it could be a permissions issue. I must be missing something  but I can't figure out what it is.

-Larry
Post #33339
Add to Twitter Add to Facebook
 Posted 7/18/2016 10:02:30 AM
Strategic Support Team Member

Strategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team Member

Group: StrataFrame MVPs
Last Login: 2/26/2021 10:30:31 PM
Posts: 1,920, Visits: 21,166
Hi Larry.

The Deployment Data Packages have a Source Data Connection configuration that points to where you will fetch the data from. Have you checked these?



http://forum.strataframe.net/Uploads/Images/8891d490-afa6-4d60-a8e0-a5dc.jpg




Cheers.

Ivan

Edited: 7/18/2016 10:04:11 AM by Ivan George Borges
Post #33340
Add to Twitter Add to Facebook
 Posted 7/18/2016 10:17:51 AM
Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: Awaiting Activation
Last Login: 3/2/2020 12:19:05 PM
Posts: 595, Visits: 3,807
Ivan,

That was it! Thanks!!

-Larry
Post #33341
Add to Twitter Add to Facebook
 Posted 7/18/2016 12:52:53 PM
Strategic Support Team Member

Strategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team MemberStrategic Support Team Member

Group: StrataFrame MVPs
Last Login: 2/26/2021 10:30:31 PM
Posts: 1,920, Visits: 21,166
Glad it helped, Larry. Cool
Post #33342
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.