Results 1 to 6 of 6

Thread: SQL Server Management tool(2005/2008) connecting to web MS SQL

  1. Jan 29th, 2008, 12:29 PM #1
    Ggalla1779
    Ggalla1779 is offline

    Thread Starter
    Fanatic Member Ggalla1779's Avatar
    Join Date
    Feb 2006
    Location
    Glasgow
    Posts
    532

    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
    Reply With Quote Reply With Quote
  2. Jan 29th, 2008, 12:46 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: SQL Server Management tool(2005/2008) connecting to web MS SQL

    What kind of errors are you getting?
    Reply With Quote Reply With Quote
  3. Jan 29th, 2008, 12:57 PM #3
    Ggalla1779
    Ggalla1779 is offline

    Thread Starter
    Fanatic Member Ggalla1779's Avatar
    Join Date
    Feb 2006
    Location
    Glasgow
    Posts
    532

    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
    Reply With Quote Reply With Quote
  4. Jan 29th, 2008, 01:17 PM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: SQL Server Management tool(2005/2008) connecting to web MS SQL

    There should be more to the message.... a timeout? invalid login?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Jan 29th, 2008, 06:14 PM #5
    Ggalla1779
    Ggalla1779 is offline

    Thread Starter
    Fanatic Member Ggalla1779's Avatar
    Join Date
    Feb 2006
    Location
    Glasgow
    Posts
    532

    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??
    Reply With Quote Reply With Quote
  7. Jan 30th, 2008, 12:41 AM #6
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width