Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Compatability Issue

Author  Topic 

jemshed
Starting Member

5 Posts

Posted - 2008-07-03 : 09:47:31
My Client is using SQL Server 2008 CTP where as i am using SQL Server 2008 RC0( Sine i could not find CTP version anywhere ) . Please help me as i am getting the following error

A connection was successfully established with the server, but then an error occurred during the login process(provider: TCP Provider, error:0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error:10054

I am using XP Operating System. If else , please let me know where i can find the installation for SQL Server 2008 CTP

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-03 : 23:55:12
Is tcp/ip protocol enabled in sql server?
Go to Top of Page

jemshed
Starting Member

5 Posts

Posted - 2008-07-04 : 00:07:19
How do we enable tcp/ip protocol in sql server 2008
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 00:20:05
In configuration manager, same as sql2k5.
Go to Top of Page

jemshed
Starting Member

5 Posts

Posted - 2008-07-04 : 00:27:21
Yeah...Enabled it...but got same error
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 01:08:36
Used valid sql login. Can you connect with named pipes?
Go to Top of Page

jemshed
Starting Member

5 Posts

Posted - 2008-07-04 : 01:49:54
Enabled but got the same error
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-04 : 18:09:26
Did you get any error during installation?
Go to Top of Page

jemshed
Starting Member

5 Posts

Posted - 2008-07-07 : 00:50:32
quote:
Originally posted by rmiao

Did you get any error during installation?


No Error during installation..Just a warning about Windows Firewall
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-07 : 22:47:39
Did you try connect to it with named pipes (not just enabled on the server)? Which edition of rc0 did you install? Double checked installation log files?
Go to Top of Page
   

- Advertisement -