SQL Server - Unable to connect to SQL server ('cannot generate sspi context')

Asked By sqlserver dotnet on 01-Sep-09 02:24 AM

Hi,

    Is it possible to connect with SQL Server 2008 from SQL 2005 Express Edition from another computer?. When i try to connect it, it through an error 'cannot generate sspi context'. But i try the error in google and i tried all the possiblities but it never log in. What will be reson for this?


   

Vasanthakumar D replied to sqlserver dotnet on 01-Sep-09 03:00 AM

Hi,

you cannot connect to higher version of database engine using lower version.

you need to use Sql server 2008 Management studio for this.

KG coder replied to sqlserver dotnet on 01-Sep-09 03:01 AM
you can not connect higher edition from lower edition

NO - Web Star replied to sqlserver dotnet on 01-Sep-09 03:26 AM

NO
re - sqlserver dotnet replied to Vasanthakumar D on 01-Sep-09 05:22 AM

then can i use SQL Server 2008 Management Studio Express in client side?


RE - Ravenet Rasaiyah replied to sqlserver dotnet on 01-Sep-09 09:00 AM
Hi

You can do this way

http://support.microsoft.com/kb/811889

thank you
http://www.codegain.com