SQL Server Management tool(2005/2008) connecting to web MS SQL
Hi all
Am trying to coonect MS SQL Server management tool(tried 05 and 08) to a SQL Server database
I have checked with the Host and my setting seem correct woth ehosting ie server/ user/ password...selected tcp/ip as protocol
Anyone got any ideas what could be wrong?? Or what else I can test?
I even turned off the firewall to see if that was issue
cheers George
Re: SQL Server Management tool(2005/2008) connecting to web MS SQL
What kind of errors are you getting?
Re: SQL Server Management tool(2005/2008) connecting to web MS SQL
unable to connect to server.... when I first setup the website I had issues with TCP/ip configuration but checked this and it says enabled...so
Re: SQL Server Management tool(2005/2008) connecting to web MS SQL
There should be more to the message.... a timeout? invalid login?
-tg
Re: SQL Server Management tool(2005/2008) connecting to web MS SQL
well I was in dialup on laptop when it failed, got home and wireless through the same laptop works.... error 0 A socket operation was attempted to an unreachable network MS SQL Server error 10051
Why would dialup fail??
Re: SQL Server Management tool(2005/2008) connecting to web MS SQL
Because the connection is slower.... the ManagementStudio sends out the attempt to connect, it's expecting a reply within a certain time span.... otherwise it would sit there forever, waiting....
-tg