Enable Remote Connection on SQL Server 2008 Express

Last time, I wrote an article show how to enable remote connection on SQL Server 2005 Express. Now SQL Server 2008 Express is released for a while, it doesn’t allow remote connection on default installation as on SQL Server 2005 Express. So you have to enable it manually. If you’re trying to connect to SQL Server 2008 Express remotely without enable remote connection first, you may see these error messages:

  • “Cannot connect to SQL-Server-Instance-Name
    An error has occurred 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: SQL Network Interfaces, error: 28 – Server doesn’t support requested protocol) (Microsoft SQL Server)”

    Server doesn't support requested protocol
  • “Cannot connect to SQL-Server-Instance-Name
    An error has occurred 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: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server)”

    Error Locating Server/Instance Specified
  • “Cannot connect to SQL-Server-Instance-Name
    Login failed for user ‘username‘. (Microsoft SQL Server, Error: 18456)”

    Login failed for user 'sa'

To enable remote connection on SQL Server 2008 Express, see the step below:

  1. Start SQL Server Browser service if it’s not started yet. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer.
  2. Enable TCP/IP protocol for SQL Server 2008 Express to accept remote connection.
  3. (Optional) Change Server Authentication to SQL Server and Windows Authentication. By default, SQL Server 2008 Express allows only Windows Authentication mode so you can connect to the SQL Server with current user log-on credential. If you want to specify user for connect to the SQL Server, you have to change Server Authentication to SQL Server and Windows Authentication.

Note: In SQL Server 2008 Express, there isn’t SQL Server Surface Area Configuration so you have to configure from SQL Server Configuration Manager instead.

Step-by-step to enable remote connection on SQL Server 2008 express

  1. Open SQL Server Configuration Manager. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.
    SQL Server Configuration Manager
  2. On SQL Server Configuration Manager, select SQL Server Services on the left window. If the state on SQL Server Browser is not running, you have to configure and start the service. Otherwise, you can skip to step 6.
    SQL Server Browser Service
  3. Double-click on SQL Server Browser, the Properties window will show up. Set the account for start SQL Server Browser Service. In this example, I set to Local Service account.
    Set Startup Account
  4. On SQL Server Browser Properties, move to Service tab and change Start Mode to Automatic. Therefore, the service will be start automatically when the computer starts. Click OK to apply changes.
    Set Start Mode to Automatic
  5. Back to SQL Server Configuration Manager, right-click on SQL Server Bowser on the right window and select Start to start the service.
    Start SQL Server Browser Service
  6. On the left window, expand SQL Server Network Configuration -> Protocols for SQLEXPRESS. You see that TCP/IP protocol status is disabled.
    Protocols for SQL EXPRESS
  7. Right-click on TCP/IP and select Enable to enable the protocol.
    Enable TCP/IP protocol
  8. There is a pop-up shown up that you have to restart the SQL Service to apply changes.
    Need to Restart SQL Server Service
  9. On the left window, select SQL Server Services. Select SQL Server (SQLEXPRESS) on the right window -> click Restart. The SQL Server service will be restarted.
    Restart SQL Server Service
  10. Open Microsoft SQL Server Management Studio and connect to the SQL Server 2008 Express.
    Open Microsoft SQL Server Management Studio
  11. Right-click on the SQL Server Instance and select Properties.
    Open Server Properties
  12. On Server Properties, select Security on the left window. Then, select SQL Server and Windows Authentication mode.
    Change Authentication to SQL Server and Windows Authentication
  13. Again, there is a pop-up shown up that you have to restart the SQL Service to apply changes.
    Need to Restart SQL Server Service
  14. Right-click on the SQL Server Instance and select Restart.
    Restart SQL Server Service
  15. That’s it. Now you should be able to connect to the SQL Server 2008 Express remotely.

345 Responses to “Enable Remote Connection on SQL Server 2008 Express”

  1. Robert

    Thank you so much for publishing “Enable Remote Connection on SQL Server 2008 Express “. It was exactly what I needed.

    Cheers,
    Robert

  2. Aju Peter

    Thanks!. It worked for me. JUST START “SQL SERVER BROWSER” service!.

    There are two things I learned
    1. SQL server 2008 does not have much to do with SQLServerAgent.
    2. ServerBrowser is instrumental in connecting to SQL Server from remote machines (FROM LOCAL MACHINE THIS IS NOT REQUIRED)

  3. SGR

    Thanks!
    This tutorial helped me to connect to SQL Server 2008 Express from MS Access 2003 via ODBC. Now I can use MS Access as a front end to SQL Server 2008 express.

  4. Richard

    Thanks!

    This fixed the problem i had. I have been running SQL Server since October and for some reason i just couldn’t login this morning. Perhaps something else has changed on my PC??

    Richard

  5. Jason

    This tutorial is great!

    Your instructions are thourghly written and should have assisted me in establishing the connection, but I keep getting the following:
    Login failed for user ‘username‘. (Microsoft SQL Server, Error: 18456)

    Ultimately, I am trying to use my local SQL Server Management Studio to connect to the remote SQL Server 2008 Express instance provided by my web host provider.

    What could I be missing?

  6. Azec

    Hallow.

    I did all you post, and also add ports 1433 + 1434 to firewall… and it is not workin, i tried near 2 days (( nothing changes. it drops 10060 Sql Server Excheption

  7. MrGreek

    Hello.. I have tried for some while now to get my SQL Server Browser running but whit no luck…
    Then I saw your site and i se that I have all ready tried all the things correct.. but when I´m trying to change to Local Service under Built in account… then I get som errors!!
    Can´t start. No active units are associsat with it… (ore somethings like that.. do you have any suggastions? I don´t know what to do now! HELP

  8. linglom

    Hi, Azec
    The error 10060 indicates that the client cannot open a socket to the SQL Server. You can verify the connection to the server by using telnet command with port 1433.

    I think the problem could be a firewall or some hardware is blocking the traffic.


    Hi, MrGreek
    Can you show the exactly error message?

    What if you specify other user account (domain users, network service)? Does the error message still showing?

  9. Geraint

    Spot on! Three hours of messing around and searching Microsoft’s site. This is the best reference on the web at the moment for enabling remote access on SQL Server 2008.

  10. ig4

    check win server 2008 firewall public profile state =off
    start–>Administrative Tools–>Windows Firewall with Advanced Security, to click Properties,to select Tab “Public Profile” set firewall state =off.
    Don’t need restart machine.

  11. MAsk

    Very usefull thank you

    Don’t forget to use connection format :
    “SERVER_IP\SQLEXPRESS”
    When asked server adress or creating ODBC connection

    also (for me) in step 6 :
    “Protocols for SQLEXPRESS.” make sure not to be in “native client” section because TCP/IP is runnning by default.

  12. rctaubert

    I have followed your outline above to the letter.

    On WHS server I have set the Firewall…Exceptions…Add Programs:

    SQL Server Error and Usage Reports
    SQL Server Management Studio
    sqlbrowser.exe (C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe)
    sqlservr.exe (C:\Program Files\Microsoft SQL Server\MSSQL.10SQLEXPRESS\MSSQL\Binn\sqlservr.exe)

    I added the port: SQLExpress 1533

    The log shows no indication that the server even knows there is a logon attempt.

    On my laptop using SQL Management Studio I go to the “Connect to Server” dialog box, click the down-arrow on the Server name box…Browse for more names…Network Servers tab.

    In the text box SERVER1\SQLEXPRESS (10.0) appears. I click on it and click Ok.

    I select SQL Server Authentication and enter the sa login and the password I set for this login.

    It will eventually time out with the following error message:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    What am I NOT doing right????

    On the server everything seems to work just fine.

  13. linglom

    Hi, Rctaubert
    Are you sure that the SQL Server is running on port 1533? By default, it is 1433.

    I would suggest you temporary disable the firewall and retry connect to the SQL Server to see if the problem is at firewall configuration or not.

  14. rctaubert

    I am sorry. I meant 1433. BUT, it turns out it was set to 1578. netstat -an show it was listening on that port.

    If I use Server1\SQLExpress,1578 it works.

    How would I get it back to 1433???

  15. J.Ackerman

    @No.2: even the _local_ SQL Server Express installation is dependent from the running SQL Server Browser service. When it’s not running then even on local machines you can not connect.
    Anyway thanks for this help to enable connection!

  16. linglom

    Hi, Rctaubert
    You don’t need to change if it’s working properly. But if you really want, just open SQL Server Configuration Manager -> expand SQL Server Network Configuration -> click on Protocol for your SQL Server -> double click on TCP/IP -> Click on IP Addresses tab. On IPAll section, here you can change port value to the new one by modify the existing value. Then, restart the SQL Server service.

  17. Panwar

    Hi linglom,

    This query is related to SQL server express 2005. By default if we install SQL server express 2005, it does not allow remote access to the created instance. Is there any way to allow remote connection to the created instance without using the UI (e.g. SQL Server Configuration Manager) i.e by changing some registry or invoking some exes? I am creating silent SQL instance (no UI).

    TIA.

  18. David

    Thank you!! I was trying to get some work done at home and I couldn’t figure out for the life of me why my sql server was not working (and it was working yesterday too…)

  19. Gerry

    Thanks very much for the sql 2008 set up information it was very helpful and enabled remote connection. However, I cannot seem to get Microsoft Access to connect and my host company are using port 1334 instead of 1434 and MS access dosnt seem to allow me to change the port?
    Help wouls be appreciated.
    Regards
    Gerry

  20. KMBrewer

    THIS IS THE ONLY FIX FOR THIS ISSUE -PERIOD!

    Thanks so muchmy friend this has really been a headache for me. After 3 install/uninstall attempts nothing was working for me. Again, thanks for the detailed resolution to this anomaly.
    KMB

  21. linglom

    Hi, Moonheart
    Can you show content of the error message?


    Hi, Gerry
    You can try to connect to the SQL Server using SQL Server Management Studio from a remote PC to see if the SQL Server is configured correctly.

  22. Orin Hooverson

    Thank you so much for publishing “Enable Remote Connection on SQL Server 2008 Express “. It was exactly what I needed. Your solution was very clear and to the point. Next time I look to google for help and not just see how many time I can install the same issue.

    Thank you for your time,
    Orin

  23. Ulyana Arsov

    Thank you, this helps a lot, I love you. This only help me while days of researching for the stupid Login fails with that user. Thank you, thank you, thank you :)

  24. Gautam

    I have installed SQL server 2008 on windows server 2008 R2. windows authentication mode is working but SQL Server authentication mode is not working giving errors login failures error code 18456, I have not any SQL user I don’t know the password of user “sa” I created user in SQL Management studio, user created but could not login as sql server authentication. Please help

  25. Gautam

    MR. JVillamil, I had already created a SQLServer user by using windows authenticated administrator login and this user couldn’t login. Furthermore I am using windows 2008 server R2 and I have also switched-off the firewall of private public network

  26. JVillamil

    Gautam that’s rigth, you should change of Windows Autentication to SQLServer Autentication to the user and the installation of SQLServer should indistinct in two cases…

    I’m sorry by my english, but I only speak spanish (see you from Mexico)

  27. Daniel

    This was really helpful but unfortunately I still can’t get a connection. I’m trying to use the “ASP.net SQL Server Setup Wizard”. Every time I try to get a list of the databases in SQL Server I get the remote connections error:

    “Failed to query a list of database names from the SQL server. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verifty that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)”.

  28. Gautam

    Hi Mr. JVillamil & all, The connection error of sql server authentication is solved by making a change in the registry.By default the windows server 2008 R2 having registry setting for the windows authentication by changing the value of registry key I could solve the problem.

  29. linglom

    Hi, Gautam
    Could you share what registry that you changed?

    About your problem (error code 18456), you should look into the SQL Server’s log which is located in Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. You will see more details on the error message. The example error message should looks similar to this:

    2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8

    You see that there is state number which tell the detail of the error message. Here are some common error states and their descriptions:
    2, 5 -> Invalid userid
    6 -> Attempt to use a Windows login name with SQL Authentication
    7 -> Login disabled and password mismatch
    8 -> Password mismatch
    9 -> Invalid password
    11,12 -> Valid login but server access failure
    13 -> SQL Server service paused
    18 -> Change password required

    Reference: Understanding “login failed” (Error 18456) error messages in SQL Server 2005


    Hi, Daniel
    Check your SQL Server’s name to see if it is correctly. This wizard always generates the server name as [MachineName]. But if you are using SQL Server express, it should be [MachineName]\SQLEXPRESS.

  30. PBC

    Very good explanation. I am still in need of help. At Step 4, the following error message appears:

    “The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.”

    Any advice?

    Thanks …

  31. Agus

    Hi, Mr. Linglom
    I think this is very good posting,
    but I have a question how about configuration setting ODBC for Ms. Access in PC Client to connect to the Windows Server 2008?, which is I put the master Database.
    Tks for your answer…

  32. Andy

    Outstanding. Thank you for the straightforward (and correct!) explanation.

    I’ve been going around in circles on this problem for hours, and Microsoft’s online resources have been unhelpful.

  33. Deepika

    I have completed till 9th step successfully..but microsoft sql server 2008 management studio does not found in my Start menu. Please solve this query.

  34. Mike

    Thank you for the article and thanks too to linglom. Having to append “\SQLEXPRESS” was not obvious at all. Changing my “Server name” value from “192.168.1.112″ to “192.168.1.112\SQLEXPRESS” did the trick for me.

  35. Vibgy Joseph

    @PBC – Hey I also got the same error “The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.”. I solved it by the following steps…

    1. Start -> Run
    2. Type “services.msc” and click “Ok”
    3. Locate “SQL Server Browser” service
    4. Right click on it and select “Properties”
    5. In “General” tab select “Automatic” in “Startup type”
    6. Goto “Logon” tab
    7. Select “Local System account” in “Log on as” section
    8. Click on “Ok”
    9. Now right click on the service and select “Start”

  36. wn

    Thanks, exactly what I needed.

    Has anyone tested how many simaltaneous users can access the db installed like this for simultaneous w+r access? I know each db can have it’s own issues, but just wondering if there has been any testing / reporting?

    Thanks

  37. itl

    The “,” saved my day!!

    So, if SQL is on different port then default 1433

    SERVERNAME(OR IP)\InstanceNAME,PORT

    ex: SQLSRV01\SQL2008,1588

    thx!!

  38. Andy

    Great article linglom!

    For some reason my SQL Server Management Studio Express had to be given “Server1\SQLExpress,1433″ to be able to connect to remote instance.

  39. Jan

    Thank you so much! Been struggling with the port issue for hours.

    So instead of a normal ‘: – then use ‘,’

    Thanks!

  40. Sarath

    Nice article man. But my issue is a bit different. I have a server in which both SQL server 2005 and 2008 are installed. few databases are in sql server 2005 and few are in sql server 2008.
    I am able to connect to 2005 from my local system but unable to connect to 2008 from local system. Can you please solve this issue.

  41. Mehboob

    Yup,nice article but i had follow all the steps and still i can’t connect remotely to Sql Server 2008 database.

  42. Cathy Ooi

    Thanks! This was very helpful. M$ should take note and give us concise simple instructions to their $#$@#$ idiosyncrasies.

    Also much thanks to Bud Aaron for the link. This and Bud Aaron’s link answered simply what I can’t get out of M$ help.

    Wish I’d seen this earlier. Would have saved me days of figuring out what the heck is wrong when I can’t connect remotely. And I can’t find any Listening PORT 1433 on “netstat -na”.

  43. Indoril Nerervar

    “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)”

    The above is the error I recieved and I have expended days on this incredibly annoying issue – I have trawled through forums and Google looking for answers, made changes to my Registry, contacted the rather stupidly named “Microsoft help”, uninstalled and re-installed SQL Server 2008 on numerous occasions and generally been ready to dump my Windows machine in the bin. I eventually arrived at this site, looked at the comments above and found that my SQL Service was not Listening on port 1433!

    This is why people turn away from MS products. I am glad to see their market share dwindle slowly but surely and await the day when they will, end up where the sun doesn’t shine. I hope its sooner rather than later!

    Rant over – btw – thanks to your post and the commentators.

  44. Asifali Kannattil

    Hi Linglom,

    Thank you for your valuable information, I’m able to connect to remote server now. But another problem still exists. I initialized a Publication and Subscription on Local server…its working perfectly. But in the case of subscription for Remote server (Added Remote SQL Server Subscriber from New Subscription Wizard) nothing happens like error and also any updations. May I want to do something in Remote Server for “Replication”?
    Pls help…

  45. Asifali Kannattil

    Hi Linglom,

    I have Two Machines (PC1 and PC2) and installed Sql Server 2005 on both. I initialized a ‘Merge Publication ‘ on PC1; Publication database was “db_Inventory” .I ticked the check boxes “Create a snapshot immediately” and” Schedule a snapshot Agent to run at the following times” and changed the schedule to occur every 5 minutes Daily.
    I want to Subscribe this Publication on a database ‘Master’ which is created on PC2. For that purpose I created a Subscription on PC1 (Subscriber and Subscription database is PC2 and Master. ) successfully.
    I inserted new records to db_Inventory using My Accounting Software that is running on PC1. The problem I’m facing is that the newly inserted records to Publication database are not getting inserted in the Subscribing database Master. But I can insert records to this database by simply changing the Database connection in My Accounting Software (The two databases having same structure).

    For testing purpose, I created a new database Master_B on PC1 and created a new subscription for that db. In this case, all records I inserted to db_Inventory are getting added in Master_B.

    I don’t know how to solve this issue. Help me pls…….

  46. Jmunoz

    I’m setting Up a SQL Server 2008 R2 on a Windows 2008 Server, and I can’t get connected because of a Windows Firewall issue, any idea?

  47. Rakesh

    Great .. was tensed .. thinking will I be able to do with SQL Server 2008 R2 Express or not .. your clear explaination solved my problem in minutes .. thanks
    But remotly I was forced to use Server IP address. Can it be connected by using server name?

    Thanks

  48. Farshad

    Hi , thanks for your kind help to all programmers like me.
    I have to make a setup that has to be installed on many PCs in different (about 80)cities of my country , so I have to make a script to enable TCP/IP in SQL Express.
    would you please help me if you have such a script to do this job ?
    looking forward to hearing from you.
    lots of thanks

  49. Bruno

    Tks for this very helpful explanation!
    But I still face a problem to find the server when I try the remote access of ODBC.
    The message I get is
    Connection Failure
    SQLState: ’01000′
    SQL Server Error: 2
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
    Connection Failure
    SQLState: ’08001′
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server unavailable or access denied

    Can you help me?

    Thanks again

  50. migro

    I got a named SQL server 2008R2 instance running on a 2008R2 Terminal Server. Mixed authentication is activated because my application connects with user and password via ODBC.

    When I logged in with admin rights, the application can access the database without any problems. When I’m logged in as a normal user I can’t get access to the database. Do You got any suggestions to solve this problem?

    When I establish a new ODBC connection to a SQL server/database running on a separate maschine it works with normal user rights. So I think the problem relies to the local instance of SQL Server 2008R2.

    Thanks in advance for Your help.

    Regards
    michael

  51. Liberty!!!

    This also worked for my DEVELOPER Edition of SQL Server 2008.
    THANK YOU!!!
    THANK YOU!!!
    THANK YOU!!!

  52. George

    Thanks, but I still have a problem. I can connect from machine/instance A to machine/instance B (‘green play-button’) with SSMS, but when I connect from machine/instance B to machine/instance A I see a ‘white dot’ instead of the ‘green play button’. Both firewall’s are off and I’m pretty sure the SQL Server Browsers are running and that I enabled TCP/IP on both machines…

  53. eqirtas

    Thanks, yes it works but my one more question.

    I want to attach mdf database file for database operations. As i can attach db file on my own local system and it works.

    Is it possible if mdf file is on other systems. and then i can attach for operations??

    I am using sql express with a desktop application in C#

    Regards
    Eqirtas

  54. bpelhos

    Very important, just repeating one of the comments:

    Don’t forget to use connection format:
    “SERVER_IP\SQLEXPRESS”
    When asked server adress or creating ODBC connection

  55. david

    thanks for posting this, the step-by-step with screenshots were PERFECTO, just what i needed. thank you again for taking the time to publish this!

  56. rodcompo

    I’ve tried this but still not getting connected. I have a SQL Express R2 instance on my XP desktop I’ve got a laptop with W7 also running a SQLExpR2 instance. I want to connect the laptop to the desktop instance (and vice versa) using the SQL Management Studio but getting no joy. Got the browser service and network protocols running but still can’t see or connect to either instance from laptop or desktop – any ideas please

  57. linglom

    Hi, rodcompo
    It could be blocked by Windows firewall, try to disable Windows firewall and reconnect again.

  58. kushi

    Awesomw steps and comments !…. it worked like a magic after 1 week of struggle to connect to my sql server db.

    thaks a ton :)

  59. phpbugs

    I am able to connect from remote machine using the “sa” username. I created another user called “asd” and I am not able to conect to the DB with this user.
    Please help!!!!!!!!!!!!!

  60. Leonardo Suarez

    Hi, Is needed the Sql Server Browse is started, I think its dangerous if you put the DB server in internet. There is another way or I’m just in panic. Thanks

  61. CCSWebWeaver

    I followed your instructions and now I can connect my SQL Express 2005 and SQL Express 2008 servers to / from MS Access 2003 database; this opens up a whole world of possibilities for me!

    Thank You for this wonderful well written guide!

  62. tobon424

    I have 5 computers connecting to a DB
    3 connecting fine, but 2 are not connecting, all computers are winXP Pro SP3

    This is the error message that I get from the two computers I cannot connect:

    Error Number: -2147467259

    SQL 2008 could not open a connection to SQL server [53]

    I know something is blocking the connection, but not sure what it is.

    Why the other computers can connect, all are connected to the same router, switch etc.

    I can see all computer within network, I am able to ping the server from the computer I cannot connected to the DB.

    Thank you

  63. Manuel Tenorio

    Thank you a lot for your excellent post!

    Some of us just don’t born with the DataBase Management gift… whatever that means :)

  64. Geo

    I’m having the same problems I cant connect to the db from any other server. I have checked that SQL browser is running but I cant see it in config manager but I can see it under services? any thoughts SQL 2008 windows sever 2008.
    Thanks in advance for any pointers

  65. Elham

    hello and thanks
    but I did all tasks that you said in your posts but it also doesnot work and return Error26.
    My windows is vista.
    what can I do now…??

  66. kachwahed

    Hi, Great thanks for share
    I did all tasks and I still get:
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server unavailable or access denied

  67. Bob_SA

    Thanks linglom! Ive used quite a bit of info from your blog over the past few days getting sql2005 express and sql2008 express running concurrently(dont ask) with remote access. Saved me a lot of time!

  68. Kachwahed

    Hi, linglom. Thanks for reply
    It’s OK now, I think the issue was in “Listen All” in TCP/IP properties, it should be set to “Yes”, add that in the article.
    Great thanks linglom
    Regards.

  69. Jeff

    Hi,

    I followed the entire guide. I disable windows firewall, enable DMZ mode for my computer with mssql server.
    I am able to connect from a differnt PC under the same LAN. However when I try to connect from a PC under a different network using SQL Server Management Studio and it doesn’t work and gave me error 26. I followed one of your links on solving error 26 you provided and followed the content listed below:

    ) Make sure your server name is correct, e.g., no typo on the name.
    2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]
    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4) Make sure SQL Browser service is running on the server.
    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    I am pretty sure I meet the requirements for all 5 points above. For part 3, I am able to ping the server in command prompt, is that good enough?

    Anyways I am totally clueless as what is wrong in my configuration. I would very much appriciate it if you can give me some pointers.
    Thanks!

  70. Jeff

    Hi,

    I followed the entire guide. I disable windows firewall, enable DMZ mode for my computer with mssql server.
    I am able to connect from a differnt PC under the same LAN. However when I try to connect from a PC under a different network using SQL Server Management Studio and it doesn’t work and gave me error 26. I followed one of your links on solving error 26 you provided and followed the content listed below:

    ) Make sure your server name is correct, e.g., no typo on the name.
    2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]
    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4) Make sure SQL Browser service is running on the server.
    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    I am pretty sure I meet the requirements for all 5 points above. For part 3, I am able to ping the server in command prompt, is that good enough?

    Anyways I am totally clueless as what is wrong in my configuration. I would very much appriciate it if you can give me some pointers.
    Thanks!

  71. mrcity

    One thing that hung me up for a while was the different “modes” of Windows Firewall — domain, private, and public. In testing, I had only shut off Domain, where I should have disabled the other two. Of course, the best thing to do is to add an exception for the particular port you’re using across all 3 modes.

    @Jeff, perhaps try looking at your TCP/IP configuration in Sql Server Configuration Manager (as described above), but double-click on it to examine the settings. In the “IP Addresses” tab, make sure the correct IP addresses and ports are enabled and set (you probably want to clear “Dynamic Ports” and enter a static port # in “TCP Port” – most people pick 1433). Go to the bottom, to IPAll, clear “Dynamic Ports”, and put in the desired port # in “TCP Port” just like the ones you have enabled above.

    - Stephen

  72. nildeen

    It would be great to expand this great walk-through to include server 2008 firewall setup :-) I’ve turned off the domain inbound for now and will need to go figure out the rest later.

    Anyhow, thank for the help!

  73. Roman

    If you follow the above steps, but the remote machine cannot connect, check your firewall software to ensure ports 1433, 1434 are open.

  74. Adam

    When all else failed your instructions worked.

    FYI – I did have to reboot after following instructions.

    Thanks again.

  75. lax

    Hi thanks in advance.
    There are three machines in LAN.
    Mac 1 contains windows server 2008 + Sql server 2005 + package X accessing local db
    Mac 2 contains windows 7 + Sql server 2005 + Package Y accessing local db
    Mac 3 Contains windows xp

    problem
    from mac 2 and 3 package x is working and retrieving data from x db
    mac 3 access package x and its data, but not y and its data.

  76. janerose

    O M G you are an angle sent down from heaven i want to buy an aeroplane and a jet ski. I have been trying to fix this error for the last 7 days my eyes hurt i was on the verge of jumping from my staircase fml. My stupid teacher who has been teaching this university module using this software for the last flipping 10 years he had no clue and gave no help (he will be egged soon).

    anywayyssss thankkkk youuu so much!!

  77. MathewUy

    Thank You so much for this very useful information,
    GOD Bless people like you who take time and effort in making this.

  78. Krzysztof

    Big thanks mr. Nipawit Luangaroon. This tutorial is verry helpful, working good :) Greetings from Poland

  79. Suresh

    Hi, I have installed sql server 2008 on a windows server 2008 system.I would like to access sql server browser to query data from other system but this doesn’t sql server 2008. Is it possible to access like that ? I followed your steps. Thanks.

  80. Roshani

    Thanks a lot!!!!!!!!!
    You solved my big problem..I was able to connect to the SQL server on local but was not able to connect from remote machine…

    I changed the server name to IP\SQLEXPRESS

    Thank you

  81. Dude

    You’re super!!this article helps me out from problem connecting to SQL Express 2008. Great thanks…

  82. Joy

    Great Article Superb Thanks to you. i was struggling quite a bit in connecting to the sql server . you saved my day :)

  83. Suzy

    Thanks you so much – your document helped me to finally get my remote access working. I had to blank out the dynamic port settings in the TCP/IP settings (in IPall), and add 1433 as specific port.

  84. Fourier

    Congratulations, the secret is the service SQL Server Browser. Thank you very much for your article.

  85. Cobesauce

    Awesome!!! 3 days, whole IT dept. could not solve it. But, I solved it from this once I found you guys!!!

  86. Rob

    Installed 2008 express with Microsoft defaults … only Microsoft would release a product with the defaults that leave the product inaccessable.

  87. Ramesh

    Thanks for ur guidance for enable the remote server in SQL Server 2008, Its very helpful for me and I have connected as per ur instruction. Thanks for posting this article.

  88. AlexF1980

    I tried everything listed above, and none of it worked. Then I checked another instance I had running (that I recently upgraded to SQL Server 2008). It turns out that (having setup the firewall correctly first!) changing the “TCP Dynamic Ports” under the IPAll section of the TCP/IP Properties dialogue to 1433 (and a restart of the SQL Server service) allows the remote connection to take place.

  89. Marco

    Thanks for the help!
    This may help too:
    (1)
    Look at the error log:
    Server Management Studio -> Object Explorer -> under you server connection expand Management, expand SQL Server Logs -> Open up Current
    (2)
    Find osql.exe and run this at the command line:
    osql -E -S %SERVER%\%INSTANCE% -Q “sp_grantlogin ‘NT AUTHORITY\NETWORK SERVICE’”

  90. abhi

    i have window 7 64 bit. Can 32 bit machine will be able to view my reports or i need some special settings as nthg working for me now……rep asap

  91. abhi

    i am not able to start my sqlexpress too? wats d problem in dat????? some error is dere like…..application not responding in timely fashion….???????? i installed sql 2008 properly

  92. Emil G

    When connecting to Microsoft SQL Server and trying to use usually SQL Authentication method you may get error 18456 login failed for user you provided. This usually means that your connection request was successfully received by the server name you specified but the server is not able to grant you access for a number of reasons and throws error: 18456. It sometimes provides also state 1 which actually isn’t that useful as due to security reasons any error is converted to state 1 unless you can check logging on the server. Check here for more info microsoft sql server error 18456

  93. jim

    thx ig4 (post #22)

    “check win server 2008 firewall public profile state =off
    start–>Administrative Tools–>Windows Firewall with Advanced Security, to click Properties,to select Tab “Public Profile” set firewall state =off.
    Don’t need restart machine.”

    that fixed it for me. thanks!

  94. Al

    I’ve followed every step…no problems and then I get step 10. It says ‘connect to SQL server 2008 express’ but I still can’t do this!

    Get the following error message….It’s driving me mad….any advice gratefully received!!!

    TITLE: Connect to Server
    ——————————

    Cannot connect to (local).

    ——————————
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

    ——————————
    BUTTONS:

    OK
    ——————————

  95. Farhan

    I added 1433 to ipall even after that its not working, I have done all steps, 1433 added to firewall sql server browser service is running also..

  96. Farhan

    I am working on a dedicated server I guess some upper level security is not letting me to open port 1433 so I have to install a software TunnelEX to open port 1433 and after installing this software I am able to connect remotely to SQL SERVER 2008 Express Finally

  97. Christine

    Hiya!

    This has been incredibly useful, however, I’m still falling down at the last hurdle of getting an ODBC connection from a machine that is also running SQL Server 2008 Express. I can register the remote server via SQL Server Management Studio, I’ve changed the port to 1433 in the TCP/IP configuration and then when that didn’t work to 14330 as per someone else’s suggestion. However, the error I’m getting with my ODBC connection is:

    Connection failed:
    SQLState: ’010000′
    SQL Server Error: 11004
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
    Connection failed:
    SQLState: ’08001′
    SQL Server Error: 6
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

    So the configuration is:

    Machine 1: Windows XP, SQL Server 2008 Express. Remote connectivity enabled.
    Machine 2: Windows XP, SQL Server 2008 Express. Can add Machine 1 to SQL Server Management studio but not set up an ODBC connection. Can connect via ODBC to machine 3
    Machine 3: Windows 7, SQL Server 2008 Standard. Can add Machine 1 to SQL Server Management studio and connect via ODBC to Machine 1

    What could it be on Machine 2 that will stop me connecting to one server via ODBC but not another?

  98. Christine

    Ignore me! I was being an idiot! It’s now working absolutely fine – in the SQL server name I’d used a forward slash instead of a backslash!

    In the immortal words of Homer Simpson – d’oh!!

  99. Elnora Kailey

    Fantastic web site. Lots of helpful info here. I am sending it to a few buddies ans also sharing in delicious. And of course, thanks for your sweat!

  100. Dannette Sarcone

    I’m not positive where you’re getting your information, but great topic. I needs to spend a while studying more or working out more. Thank you for wonderful information I was in search of this info for my mission.

  101. Alberto Juliao

    the comment #89 helped me with the issue starting SQL Browser, I’m new to creating remote connection with databases, However I want to know what specific IP must be set on the connection String, does it need to be the public ip of my local machine? Or the one I assign from the TCP/IP? Please answer as soon as possible.. THANK YOU FOR THIS GUIDE.

  102. Josip

    Hey man, thank you for the detailed informations and step-by-step leading through the problem! It helped me so much that I can’t tell you how happy I am :D

  103. Alberto Juliao

    Ok I figured it out, you need to type down your public IP address if you’re connecting from outer network (i.e friend’s home) if you’re connecting from the Server PC then, type your internal IP (192.168..) That’s all. And also what this post is missing is the steps of allowing windows firewall to sqlserver and its ports. Also the creation of accounts and users login that you choose to access the database you want to allow remote connection. Tutorial in this link: http://videotutors.net/sqlserver-remote-access.aspx

  104. Mustapha

    Hi all,
    I have followed steps , until step 10 , when I open Microsoft visual studio management . when I click on connect to , I see only database engine and SQL Server Compact ,but not he SQL Server 2008 Express .
    I d appreciate if someone can help me with this issue.
    Regards

  105. Alberto Juliao

    @Mustapha, there’s only those two features (Database Engine and SQL Server Compact) what he means for “SQL Server 2008 express” is connecting to the core service, which is “Database Engine”, it’s selected by default you just need to type your instance name in the “Server Name”, also “NameInstance”/SQLEXPRESS can work, by default the instance name is your Computer Name.

  106. Kazinski

    I have followed the steps above a couple of times and I am still having no luck in getting the server to talk from one machine to another.

    I can log on the local machine using Server Management Studio but I can not from a second machine on a local network.

    When I use sqlcmd – > sqlcmd -S \MSSQLSERVER it does not work, but if I use sqlcmd -S I get a sql command prompt.

    I am getting a Connection string is not valid [87] error.

    Any help would be greatly appreciated.

  107. Kazinski

    I am now able to connect. I use the IP address of the server and I am able to connect using a different account I set up. I was trying to log in using my admin account for the sql server and that is failing.

    I think I have 2 problems – the first is a domain name problem. The computers are connected in my home network via workgroup and the 2nd issue is account permissions.

  108. nwaomachux

    I’d like to ask you, since I do not have Microsoft SQL Server 2008 Management Studio Express installed on the PC that’s running the SQL Server 2008 R2, how do I connect to it from another PC.

    I installed the SQL Server on a Virtual Machine. I’m able to connect to the VM, but the problem is that I followed the above tutorial till I got to the point where I’d have to work further with Microsoft SQL Server 2008 Management Studio Express but I’m not able to finish up because I don’t have it installed.

    I will like to use another program to connect to the server. Please, how do I do it. Thanks.

  109. Rick

    Re: SQL Surface Area configuration.

    SQL 2008 Express does have Surface Area configuration. It is now (hidden) in “Facets” (see context menu), last option of the list. Ad hoc remote queries can be enabled there.

  110. Nicola Matarese

    Very useful tutorial! It worked fine for me.

    Now I have a question:
    is possible to establish a remote connection on SQL SERVER through a VPN using the Windows authentication?

    Thanks!

  111. Wombat69

    This was great, I am migrating a database to another server & wondered why I could not connect from a remote pc, now i have followed your detailed instructions & now it is working.

    Thank you, saved mae a lot of hours

  112. Poetry

    Great weblog right here! Also your website a lot up very fast! What host are you using? Can I am getting your affiliate link to your host? I want my site loaded up as fast as yours lol

  113. Halmeic

    Trying to do the same thing on windows 7 and MS SQL 2008. The menu tree is different can anyone help?

  114. Filme

    Thank you a bunch for sharing this with all of us you actually understand what you’re talking about! Bookmarked. Please additionally visit my web site =). We can have a link alternate contract between us

  115. Inno

    I am using a university computer connected to the university network. I don’t have admin rights. I did install SQL Server 2008 myself. SQl Server is running by default but SQL Server Agent and SQL Server Browser are both disabled so I could not start them by following the above instructions. Any way out? Please.

  116. hicsel

    Windows 7 won’t let you install most programs without the correct authorisation, so I take it your using an older OS. Any form of Server setup and configuration usually requires Admin rights. I think your very lucky it let you install SQL Server in the first place. Speak to the IT manager and ask him to elevate you to the required level of access.
    If you still have problems come back on.

  117. Yamini

    i did all settings which you mentioned above but still have bellowed error for remotely connection to SQLEXPRESS server.
    Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

    Can anybody giude me please…!

  118. linglom

    Hi, Yamini

    Here is a checklist that you could do:
    - Check if the SQL Server service is running.
    - Check if there is any firewall blocking the connection between the SQL Server and the remote computer or not.
    - If you are connecting by programming, you should verify the connection string if it corrects or not.

    If you have trouble in any step, let me know.

  119. Mubarak

    Hi guys,

    I’m VS 2008 to upload excel sheet in remote machine. but local machine, it was working fine. and its through the error like below, while I’m uploading excel sheets in applications. please go through below,

    please help me to resolve the issue, I’m in critical situtaion. any help will be greatly appreciated. i did all cahnges in remote machine even I’m installing the SQl 2005 in remote server and enable the port 1433 in firewall, and enable the database engine to local & remote connections. but still the below errors are appear.

    please help me to solve the issue, its my humble request.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849719
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
    System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4863021
    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90
    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
    System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
    System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
    System.Data.SqlClient.SqlConnection.Open() +122
    Zakat.PhoneBook.Contacts.XLUpload(DataTable dt) in D:\Rahman\Clients\Zakat\Zakat\Zakat\PhoneBook\Contacts.aspx.cs:469
    Zakat.PhoneBook.Contacts.UploadXL() in D:\Rahman\Clients\Zakat\Zakat\Zakat\PhoneBook\Contacts.aspx.cs:244
    Zakat.PhoneBook.Contacts.Button1_Click(Object sender, EventArgs e) in D:\Rahman\Clients\Zakat\Zakat\Zakat\PhoneBook\Contacts.aspx.cs:452
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

    Wating for your kind reply guys,

    Regards,
    Mubarak

  120. Mubarak

    Dear linglom,

    I’m checking that SQL server is running, and the connection string also working fine in all other modules. but especially the when i import excel sheets in my application, the instance error throws..

    1. can you please giude me more on this and please giude how can i check that, Is ther any firewall blocking the connection between the SQL Server and the remote machine..??

    2. I’m also checking the instance with conenction string like data source=”zak_db01\zakat,1433…etc”. –> but there is no use of it.

    please help me to reolve this issue.

    Anyhelp will be greatly appreciated. I’m in critical situation.

    Thanks
    Mubarak

  121. Sethu

    Great. It was worked fine. SQL Express 2008 R2 – Remote connection issue has been resolved by followed the steps given. Thanks a lot. :)

  122. Stef

    hi,
    did everything and still not working… suggestion anyone??

    they changed the server and before it was working and now…
    thank you
    Stef

  123. Zahir

    Thank you very much! This tutorial was very effective, everything works in just couple of minutes.
    Thank you,
    Zahir

  124. Amir Yaqoob

    Different version of SQL server may cause to avoid remote connection:
    I struggled around 4 hours, and it did not work. Finally, I realized that I have some installtions of SqlServer 2005 in addition to Sql Server 2008 Express edition. I gave last try by removing Sql 2005 installtions, and then try to connect with SQL Server 2008 Express instance. and got success.

    Thanks!

  125. KW

    What “nonstandard” happened to me when I was configuring remote MSSQL (maybe someone said it above):
    - my SQL Server process didn’t open on standard 1433 port, but some 50000 (check it in netstat)
    - On client I used Server’s port, not Server Browser’s
    - Windows Firewall by default blocks Server’s port! I disabled it totally until I made it work.
    - pay attention to User name and domain you are using – I used same (domain) user remotely, as I installed server on, and it worked

    First make it work at all costs. Then play with setting ports, firewall and so on.

  126. Dave

    I have a Sql express server at my h.office.Im running a application from my brance.i have a static ip at my h.offc.
    how i can connect my appl to my h.office sql express?

  127. Bill

    Thanks! Your article just saved my weekend. Had a client on SQLServer Express, who now wanted to access it on a remote networked computer. When it did not initially connect, I figured I’d be at it all weekend trying to find the solution. It is 8:00A.M. Saturday morning and I’m on my way to the golf course. Thanks a million!!

  128. Murphiks

    A very good statement.
    All but one of the super, nobody faced with connection from Linux hosting via MSSQL or ODBC , port 1433 to Windows server 2008 R2 computer with SQL Express 2008 R2 ?
    All set up correctly with the other computer on Windows server 2003 I’m conecting via XAMPP 1.7.1 and MSSQL.
    host=192.x.x.x,1433
    I no it does not work. Someone tell me or anyone advise? As early as the days of steam no results :(
    On linux Hosting is on FreeTDS ver.8.

  129. rvfigueroa

    Just one think, and elemental!!!!

    You need to verify your Windows Firewall in your machine that run your SQLEXPRESS!!!

    You can add and rule to your firewall or directly deactivate for a few momento while you work with connection.

    Regards!

  130. shabnam

    I have 2 sql server in win server 2003. sql server 2000 and sql server 2008 R2 .I want to remote connection to both of them from the client system. but I could remote to sql serevr 2000 but I could not remote to sql 2008 and show this message:
    Cannot connect to SQL-Server-Instance-Name
    An error has occurred 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: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server)”

    what I am doing?? please help me… thanks alot

  131. Alberto Juliao

    @shabnam,
    1. did you follow every step for this tutorial?
    2. If not, for “SQL Server 2008 Express” you go open Microsoft Visual Studio Management, there will be two features (Database Engine and SQL Server Compact)
    3. To manage “SQL Server 2008 express”, go to “Database Engine”, it’s selected by default you just need to type your instance name in the “Server Name”, also “NameInstance”/SQLEXPRESS can do the trick as people said, by default the instance name is your Computer Name.
    4. If SQL is on different port than default 1433
    SERVERNAME(OR IP)\InstanceNAME,PORT
    example: SQLSRV01\SQL2008,1588
    5. If still no luck, please read this post that includes Firewall configuration and TCP/IP config http://videotutors.net/sqlserver-remote-access.aspx
    Merry Christmas.

  132. Ponnusamy

    Windows 7 OS, I have tried from java to connect MS SQL 2008 server. I am having 2005 also in my machine. Here I was not able to connect 2008 server since 1433 port was assigned to 2005. So I have changed the port in my application to port which is mentioned in SQL Server Configuration Manager ->SQL Server Network Configuration ->Protocols-> TCP/IP properties for All IPs

  133. bogser

    Thanks for this very helpful information.
    After reading this article, it just took me some more minutes to get the external SQL Server connection working !
    Much appreciated.

  134. Xbox One Giveaway

    My brotfher suggested I miught like this website. He was totally right.

    Thhis ppost truly made my day. You cann’t imagine just how much time I hadd
    spent for this info! Thanks!

  135. Latrice

    Quality articleds is the secdet to bbe a focus for the viewers too pay a quick visit the weeb
    site, that’s what this website iss providing.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>