Can't Connect to StrataFrame database.


Author
Message
Larry Caylor
Larry Caylor
StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
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
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
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 8 Years Ago by Ivan George Borges
Larry Caylor
Larry Caylor
StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)StrataFrame VIP (1.7K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K
Ivan,

That was it! Thanks!!

-Larry
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Glad it helped, Larry. Cool
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search