StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Issues
»
Database Connection Wizard
Database Connection Wizard
Post Reply
Like
0
Database Connection Wizard
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Chris Diesel
Chris Diesel
posted 16 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 74,
Visits: 300
We moved our developement databases from a server running sql 2005 to sql 2008. When we try to setup a connection in the "Application Database Connections" from the StataFrame menu in vs, we select the new sql server but get a message "Invalid Server Connection - Could not authenticate the SQL server." when we click "Next". We tried both integrated security as well as sql security. We're able to connect to the new sql server via SQL Server Management Studio from the same workstation using either Integrated or SQL Security. On a slightly side note, the Database dropdown that specifies the "StataFrame" database is never enabled.
Reply
Like
0
Reply
Trent Taylor
Trent Taylor
posted 16 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
Try SQL authentication...it is always hard to tell if Windows Auth is setup properly. Try logging in with SQL auth to see if you have better results.
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Database Connection Wizard
Chris Diesel
-
16 Years Ago
This will be on your SQL Server configuration side of things. Make...
Trent L. Taylor
-
16 Years Ago
Double checked,this is how we have it set. When we moved the...
Chris Diesel
-
16 Years Ago
Connecting is pretty straight forward. It uses a standard...
Trent L. Taylor
-
16 Years Ago
I guess I wasn't clear.:) I can access the sql 2008 database from any...
Chris Diesel
-
16 Years Ago
When you go into the Database Connections and select the SF Data...
Trent L. Taylor
-
16 Years Ago
This is exactly where it's not authenticating.Attached message occurs...
Chris Diesel
-
16 Years Ago
Try SQL authentication...it is always hard to tell if Windows Auth is...
Trent L. Taylor
-
16 Years Ago
Hi Chris,
I forget the details now but when we moved to SQL...
Peter Jones
-
16 Years Ago
Good point...are you running 1.6.7 beta? If not then you will have to...
Trent L. Taylor
-
16 Years Ago
Yea, the 1.6.7 did the trick for SQL 2008. One other issue though....
Chris Diesel
-
16 Years Ago
There are several places that a connection string can be...
Trent L. Taylor
-
16 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search