February 13, 2009 at 11:12 am
We installed SQL 2008 Standard
We can connect using SSMS that came with 2008
TCP/IP and Named Pipes are enabled in configuration settings
When the app tries to access the server it quickly fails saying can not connect.
What am I missing. The app works against SQL 2005
February 13, 2009 at 11:41 am
I'm guessing you migrated the DB from the 2005 to 2008 server or did you do an in-place upgrade?
If you migrated the data from one server to another, check for orphaned users, etc. How is your application connecting? Was it using certificates or some other resource that is not set up correctly on the new box?
-Luke.
February 13, 2009 at 12:51 pm
This is not an upgrade. It is a clean install. I also tried to connect using odbc and it will not allow me to connect.
February 13, 2009 at 12:55 pm
Did you transfer your logins etc? If I remember correctly when correcting orphaned users, it puts them in the deny data reader group sometimes. check on to make sure they can actually read the data they are attempting to. What does the Security log say? How about the SQL Server log? Any clues there?
-Luke.
February 13, 2009 at 2:17 pm
the firewall was turned off but the service was still running. so I got the odbc to connect only to find that assemblies that were made in 05 are not compatible with 08. I can not believe SQL would make version 10 not compatible with V9.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply