none
I can't configure sql server to allow remote access

    Question

  • Hi, I've got SQL Server 2008 on my laptop computer (an Acer Aspire 5735 running with Windows Vista), and I need to configure SQL Server to allow "remote access". So I tried installing SQL Server Management Studio 2008, but I can't seem to install it. It's hard for me to explain why I can't install (because I don't know), and it much easier to say, when looking at this video on youtube: http://www.youtube.com/watch?v=7whqA-VZaYc (a video of how to install sql server management studio 2008);

    I copied everything on the video that the guy does, and the part that I get stuck on, is at the point of 2:40 in the video, the guy presses install, so I press install too, then on the video, the window disappears at about 2:50, and a small window then displays "Please wait while SQL Server 2008 Setup processes the current operation.". Now on the video, after this small window pops up, the setup window pops up again, and the guy carries on. For me after the window displaying "Please wait while SQL Server 2008 setup processes the current operation" pops up, it then disappears again, and then that's it, it appears to have finished, unlike in the video, the Setup window does not pop up again, and nothing else happens, and SQL Server Management Studio does not install.

    Also I don't understand SQL Server much at all, so I might find it hard to understand technical details relating to sql server :/

    I've been trying to sort this out for a while, can anyone please help?
    Monday, April 09, 2012 9:50 AM

Answers

  • You don't need SQL Server Management Studio to enable remote connections. When SQL Server is installed it includes the SQL Server Configuration Manager tool. That's the tool you use to enable remote connections. See Enable or Disable a Server Network Protocolhttp://msdn.microsoft.com/en-us/library/ms191294.aspx


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Monday, April 09, 2012 3:27 PM
  • Just a guess, but one possibility is that you are trying to run the 32-bit setup on a 64-bit Operating System or the other way around.

    If you are not sure which Operating System you have, point to All Programs, right-click Computer, and then click Properties. The System type value will say 64 or 32.

    Then from this site Microsoft SQL Server 2008 R2 RTM - Management Studio Express http://www.microsoft.com/download/en/details.aspx?id=22985 select the x64 or x32 program to match your Operating System.

    If this still fails, copy the file locally, open a command prompt and run the SQLManagementStudio_x**_ENU.exe program from the command prompt. (Let me know if you need more specific instructions on doing that.) If setup fails when run from the command prompt, the error message should stay on the screen, so you will have more info.  


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Friday, April 13, 2012 4:08 PM

All replies

  • Hi,

    Here there can be many such things, first

    1) Enable the TCP\IP and Named pipe protocols from SQL server configuration manager

    2) Look at the firewall on server and if its enabled, allow port 1433

    Also, Kindly have a look at this post for more details http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

    Please revert if this does not work..


    - Chintak (My Blog)


    Monday, April 09, 2012 11:23 AM
  • You don't need SQL Server Management Studio to enable remote connections. When SQL Server is installed it includes the SQL Server Configuration Manager tool. That's the tool you use to enable remote connections. See Enable or Disable a Server Network Protocolhttp://msdn.microsoft.com/en-us/library/ms191294.aspx


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Monday, April 09, 2012 3:27 PM
  • You don't need SQL Server Management Studio to enable remote connections. When SQL Server is installed it includes the SQL Server Configuration Manager tool. That's the tool you use to enable remote connections. See Enable or Disable a Server Network Protocolhttp://msdn.microsoft.com/en-us/library/ms191294.aspx


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    SQL Server Configuration Manager Tool does not allow to enable Remote Connection - it allows only to enable/disable various protocol stacks like TCP/IP etc. And exactly that is described in your linked MSDN article.


    Monday, April 09, 2012 4:41 PM
  • Hello,

    Follow the links below for more help.

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

    http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

    http://forums.asp.net/t/1338911.aspx/1

    • Proposed as answer by ryguy72 Wednesday, April 11, 2012 11:38 PM
    Tuesday, April 10, 2012 8:53 AM
  • does anyone know what I am doing wrong with installing sql server management studio? I can't download the management studio, but i think if I download that, then i'll be able to get sql server working
    Friday, April 13, 2012 2:20 PM
  • SQL Server Management Studio (SSMS) is part of the .ISO installation image - get it from the original installation media used to install SQL Server 2008 on your computer.

    I would not recommand to install SQL Server Management Studio Express as it had too many restriction and when you have a license to install SQL Server on your computer than you've the license to install SSMS too.

    Friday, April 13, 2012 3:56 PM
  • Just a guess, but one possibility is that you are trying to run the 32-bit setup on a 64-bit Operating System or the other way around.

    If you are not sure which Operating System you have, point to All Programs, right-click Computer, and then click Properties. The System type value will say 64 or 32.

    Then from this site Microsoft SQL Server 2008 R2 RTM - Management Studio Express http://www.microsoft.com/download/en/details.aspx?id=22985 select the x64 or x32 program to match your Operating System.

    If this still fails, copy the file locally, open a command prompt and run the SQLManagementStudio_x**_ENU.exe program from the command prompt. (Let me know if you need more specific instructions on doing that.) If setup fails when run from the command prompt, the error message should stay on the screen, so you will have more info.  


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Friday, April 13, 2012 4:08 PM
  • hi, please check this link , it may help you out.

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

    Wednesday, April 18, 2012 11:27 AM