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.

This will be on your SQL Server configuration side of things.  Make sure that you turn on TCP/IP services and support for each of the IPs (NICS) that provide access to the server.  I am willing to bet this is the step that you might have missed.  Once you can connect via TCP/IP then I am willing to be you can connect.

At any rate, this is a legitimate message coming from SQL Server, but my first guess to the issue you are fighting is as mentioned above.

Double checked, this is how we have it set.  When we moved the application database over, we didn't have any problems (app runs fine pointing to 2008 using a connection string).  It's just when I tried to use the Database Connection Wizard and the Business Object Mapper.

Connecting is pretty straight forward. It uses a standard DbConnection (SqlConnection) using a standard connection string. So if you are having connectivity issues, double-check your connection string. Next, make sure that you can access the database from a machine OTHER than the machine on which it resides through SQL Server Management Studio or something along those lines. If you can connect in that regard, then the BO Mapper, DDT, etc. all connect the same way.

I guess I wasn't clear.   I can access the sql 2008 database from any computer via sql server management studio or our application using a connection string just fine (integrated or sql security).  When I try to setup a new database connection from either dev machine is when we get that message.    There has to be something different going on somewhere.  No doubt something I screwed up.   Is there anyway to tell what connection string is being used from the connection wizard?

When you go into the Database Connections and select the SF Data Store, click the Edit button and go through the wizard.  Does it authenticate?  This is the connection that is used.  So you if you can authenticate here, then all other SF pieces should be able to authenticate.

This is exactly where it's not authenticating.  Attached message occurs when I click next.

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.

Hi Chris,



I forget the details now but when we moved to SQL 2008 it wasn't supported out-of-the-box by SF and we had to change references to SQL 10 in the SF sources. Maybe this is the problem - are you running the latest version of SF?



Cheers, Peter

Good point...are you running 1.6.7 beta? If not then you will have to go there in order for this to work...in fact, I know that is what is happening at this point. SQL Server 2008 is only supported in the 1.6.7 build.