Link to home
Start Free TrialLog in
Avatar of menreeq
menreeq

asked on

SQL 2008 backwards compatibility

I have 2 application running on 2 different servers that i need to integrate.  The applications are called Connectwise and Kaseya.  In order for the integration to happen I need to install a small integration app on the Kaseya server that connects to the Kaseya SQL 2008 database.  The problem I'm having is that this app is not able to connect to the local SQL 2008 database - just gives me a generic connection error.  I've confirmed that the credentials are good and believe that the problem is happening because the app was designed for SQL 2005 and Kaseya is running on SQL 2008.  Having said all that, is there anything I can do on the SQL 2008 server to make it more backwards compatible?  I'm a SQL novice.  thanks!
ASKER CERTIFIED SOLUTION
Avatar of 8080_Diver
8080_Diver
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of menreeq
menreeq

ASKER

Take a look at the screenshot below.  the database i want to connect to is local.  I can connect to the other SQL databases with it on other servers, just not the one that is local.  Unfortunately I don't know the language the app is written in.  I was guessing that it is only compatible w/ SQL 2005 because the instructions it comes with only referrence SQL 2005... being a SQL novice I just connected those dots.


 User generated image
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check to make sure that the service for your local SQL server Instance is actually running.  You should probably have a little icon that looks sort of like a computer tower in the lower right corner of the screen.

Also, did you install SQL Server Express on your local box and is that the server you are targetting?  

If you installed SQL Server Express on your box, then it is very probably that you will need to specify the server/instance for the database instead of (local) and the key pieces are probably nameof yourbox/SQLExpress.
Avatar of menreeq

ASKER

Thanks, I've confirmed that mixed authentication is on and that SQL services are running.  I'm using SQL 2008 not SQL express.  thanks
Avatar of menreeq

ASKER

I forgot to mention in my previous post that I'm still having the problem... sorry
When you connect to the server via Management Studio, what do you put in the Server Name, Authentication, and (if necessary) User Name and Password?
Avatar of menreeq

ASKER

Server name is (local), authentication is SQL Server Authentication and I use the SA password to login.  Same stuff I use in the app.  thx
Okay, based on both the fact that you are attempting to use the SA login and the fact that the screen print yu provided mentions using a SQL Server login, I have to assume that the application relies on Server Authentication.  So, we're back to a question you never really answered: Do you know that the SQL Server instance is running on your box?  (Again, do you see the little computer tower icon in the lower right corner?)
Avatar of menreeq

ASKER

I don't see a little computer tower icon in the lower right corner but i think that's just how it is with SQL 2008 and Server 2008.  I'm sure that the instance is running because i do have people using the database  w/out a problem.  thanks
Are they using the database on your box?

Can you go to another box and set up the software so that it can access your original box?  Or, can you access the database using the sa login from another box using Management Studio?
Avatar of menreeq

ASKER

Well, I ended up contacting the vendor and they were able to somehow make it work... not exactly sure how.  What's the fair thing to do here?  I appreciate your time in answering my question, what do you suggest in terms of awarding points etc?
menreeq,

Well, of course, I want max points and an A rating. ;-)  Seriously, though, whatever you think nmy input was worth is what you should award.  I am mostly here to try to help (and, thereby, learn).
Avatar of menreeq

ASKER

A solution was not provided by the answers but the effort is greatly appreciated.