Post reply

Remote Access to Sql Server Management Studio

  • August 12, 2008 at 7:08 am

    #130639

    Dear All,

    I have a problem in accessing Sql server management Studio from another system. here is the fact,

    1. I have Installed SQL Server Management Studio in my system with windows authentication.

    2. when i try to access the sql server from another system using Windows authentication i got the following error..

    sql server does not allow remote connections

    An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server

    i have try to solve and using the following modifications in my system. but the same problem has occured. here is link for your information.

    http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

    Please give your ideas...

    Thanks in advance,

    ...Sekar

  • August 12, 2008 at 7:14 am

    #856655

    have you:

    1. allowed remote connections in the surface area configuration tool?

    2. enabled named pipes and/or tcp/ip?

    3. if this is a named instance, started the sql browser?

    4. allowed connections to pass through your firewall?

    5. started the sql server service?

    6. made sure you're using the same protocol on the remote machine that the server is listening on?

  • August 12, 2008 at 7:30 am

    #856678

    Hi lenny,

    I did steps 1 to 5 as you mention in reply. but i dont know the step 6 how to check this???

    Thanks,

    ...Sekar

  • August 12, 2008 at 7:35 am

    #856683

    that part really depends on how you're trying to access the remote server. if you're using sql management studio, then when you're at the connection dialog, click the Options button (lower right), then choose the network protocol from the dropdown. if your server is only configured to run tcp/ip, choose tcp/ip. if it's configured to use either named pipes or tcp/ip, then choose either.

    are you able to connect from any other machines? have you installed the client connect tools on the machine you're trying to connect from?

  • August 12, 2008 at 7:43 am

    #856693

    yes i have checked but not able to connect it. the same SQL Server Management studio have been installed in other system.. But in that Options dialog the network protocol has either TCP/IP or Named Pipe. Not able to select two things. Then If i Connect to Database option the same error has thrown..

    ..Sekar

  • August 12, 2008 at 7:54 am

    #856703

    if you're not able to connect from any other system, then i would think the problem's on the server. while it's possible that the same (or similar) problems exist on all the machines you're not able to connect from, it's more likely that the problem(s) exist on the server. but one more thing you can try from a remote is to connect using the ip address of the server instead of its name.

    some things to check on the server:

    1. if there's a local firewall, disable it temporarily

    2. if you're trying to connect to a default instance, ensure it's listening on port 1433; for a named instance using a dynamic port, ensure the sql browser service on the server is running; for a named instance using a static port, ensure you're using the same port on the remotes

    3. ping one of the remotes from the server to see if there's a connection between the two machines (or ping the server from the remote)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply