Hi there,

   What are the SQL requirment to have the website running?

   I did some testing on different machines which have a conbination of instalated  SQL Server 2008, SQL Server 2005, SQL Server 2005 Express. In some the website works fine, in others I get: "cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.".

   Thanks ;)

What version of Visual Studio are you using?  If it's VS 2005, then SS 2008 is not supported.  Additionally, SS 2005 cannot access SS 2008 databases.

 I am using VS 2008 SP1

So, when you get the error message, which version of SQL Server are you trying to use?

 In my dev machine I have SQL Server Express 2005 and it works fine when the wen site is hosted on it and I cann access it from VS2008 Server Explorer window. On the web server I have tried:

 > SQL Server 2008 + SQL Sever Express 2008

 > SQL Server 2008 + SQL Sever Express 2005

 > SQL Server 2008

  And now apparently running SQL Server 2008 only, I can publish it on the webserver and the application communicates properly with the database. Although, within VS2008 I cannot acces the database via the 'Server Explorer'. When I double click on the DB, I get "Connections to SQL Server files (*.mdf) requires SQL Server Express 2005 to function properly". I went to Tools>Options>Database Tools>Data Connections and double checked the instance is correct.

Thanks

It sounds like that your SP1 update may not have worked.  SP1 provides support for SS 2008.  You might try reinstalling (repairing) your SP1 installation once again and then see if you can connect from VS 2008.

 Here are useful threads for the same

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/a17b7561-0025-4b3e-9ab4-9f9981bf2ef0

http://forums.asp.net/t/1349092.aspx

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/1688f683-5199-4879-88d5-a814b58c7860

http://forums.asp.net/p/1385242/2943288.aspx

 Are these post helps you, can you please tell if you are able to run TTS

 Are you running on different SQL Server on same machine

 Which version are using for SQL Server

Hey, thanks for you replies! I had tried it in both ways. Having VS2008 and database server in the same box and also a dedicated databaser server and neither work. But after sever tests I took the drastic solution of rebuilding the database server with one on instance of SQL Server, the 2008 one. After that is seams everything is working now and I can a publish nad run my website properly.

Thanks you for your time and help ;)

Thats great