Linglom's blog

Enable Remote Connection on SQL Server 2008 Express

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

1. Robert Says:
   April 2nd, 2009 at 3:15 am

   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 Says:
   April 7th, 2009 at 7:59 pm

   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. Matt Says:
   April 8th, 2009 at 10:45 am

   Thank you very much for putting this tutorial together. It has been very helpful!

4. Ronald Says:
   April 22nd, 2009 at 1:47 pm

   Thanks!

5. SGR Says:
   April 22nd, 2009 at 6:33 pm

   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.

6. Richard Says:
   April 30th, 2009 at 8:54 pm

   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

7. Jason Says:
   May 5th, 2009 at 2:09 pm

   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?

8. Sakoda Says:
   May 7th, 2009 at 9:47 am

   It’s so great and very helpful!

9. linglom Says:
   May 12th, 2009 at 9:30 am

   Hi, Jason
   There may be a login problem. You should observe error state in the error message. See the post below for more detail.
   Understanding “login failed” (Error 18456) error messages in SQL Server 2005

10. eiad Says:
    May 23rd, 2009 at 8:39 am

    You are a good person. Thanks so much!

    Eiad

11. Jampa Says:
    June 4th, 2009 at 4:42 am

    Thanx a lot mate, your tutorial helped me a lot…

12. Vadim Says:
    June 4th, 2009 at 3:12 pm

    Thanx man, it was very helpfull for me
    keep the same way

13. Ben Says:
    June 15th, 2009 at 6:05 pm

    Fantastic – you have saved me a lot of time – many thanks!

14. Thurein Says:
    June 17th, 2009 at 5:40 pm

    Thanks for this post. It is really helpful.

15. Azec Says:
    June 18th, 2009 at 10:25 pm

    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

16. MrGreek Says:
    June 24th, 2009 at 4:19 pm

    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

17. linglom Says:
    June 25th, 2009 at 9:20 am

    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?

18. Geraint Says:
    June 30th, 2009 at 7:23 pm

    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.

19. Pooya Zandevakili Says:
    July 2nd, 2009 at 12:25 am

    Thanks so so much

20. Renee Kraft Says:
    July 9th, 2009 at 5:52 am

    Thank you so much! Your posting was a huge help.

21. Marius Says:
    July 21st, 2009 at 4:29 pm

    Thank you for both the 2005 and 2008 guide! Helped me with both as we have both at work!

22. ig4 Says:
    July 23rd, 2009 at 5:23 am

    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.

23. jeff Says:
    August 7th, 2009 at 3:11 am

    excatly what i needed. you are awesome.

24. Engin Says:
    August 9th, 2009 at 7:10 am

    Thanx to Turkey

25. fer Says:
    August 15th, 2009 at 2:08 pm

    Thanks. It is very helpful.

26. Serdar Says:
    August 19th, 2009 at 5:28 pm

    Thanks so so much to Turkey

27. IS Thakur Says:
    August 23rd, 2009 at 7:14 pm

    Thanks a lot for such a valuable info.

28. matthew Says:
    August 28th, 2009 at 2:23 am

    WOW! thank you, thank you, thank you!!

29. Ken Says:
    September 8th, 2009 at 8:10 am

    This is such a great write-up. Thanks!! so much for taking the time to pull this together.

30. ali Says:
    September 14th, 2009 at 3:36 pm

    Thank you so much!

31. sayoni Says:
    October 7th, 2009 at 11:56 am

    Thanks a lot… it solved my issue…..

32. MAsk Says:
    October 8th, 2009 at 7:00 pm

    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.

33. rctaubert Says:
    October 18th, 2009 at 9:48 pm

    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.

34. linglom Says:
    October 19th, 2009 at 8:12 am

    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.

35. rctaubert Says:
    October 19th, 2009 at 8:24 am

    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???

36. Shoikat Says:
    October 25th, 2009 at 10:54 pm

    Thanks.
    It is very simple but very helpful.

37. J.Ackerman Says:
    October 26th, 2009 at 11:41 pm

    @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!

38. linglom Says:
    October 27th, 2009 at 10:33 am

    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.

39. Sareesh Says:
    November 6th, 2009 at 3:30 pm

    Thank you for your nice and clean article.

40. Panwar Says:
    November 19th, 2009 at 12:28 am

    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.

41. Jyothsna Says:
    November 20th, 2009 at 10:43 am

    Hi,

    Thanks a lot for this well explained tutorial along with screenshots. Appreciate your patience.

42. David Says:
    November 24th, 2009 at 12:31 pm

    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…)

43. jim s Says:
    November 29th, 2009 at 4:48 am

    Thanks! This was causing me much consternation.

44. Moonheart Says:
    November 30th, 2009 at 3:54 pm

    thx for this solution
    but i have WMI provider error
    plz how can i connect to SQL server 2008 in my PC

45. Gerry Says:
    December 10th, 2009 at 3:21 am

    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

46. joyhan Says:
    December 14th, 2009 at 3:15 pm

    Thanks a lot. It is very helpful!

47. imtiaz Says:
    December 16th, 2009 at 9:42 pm

    after your setting cannot my native client and sql service start

    solve my problime

48. Abdiel Says:
    December 18th, 2009 at 11:24 pm

    Thanks! I was about to reinstalll the whole sql 2008.

49. KMBrewer Says:
    December 19th, 2009 at 2:50 am

    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

50. linglom Says:
    December 30th, 2009 at 8:49 am

    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.

51. ALI Says:
    December 30th, 2009 at 5:40 pm

    Thank you very much… very nice and successful presentation.

52. Orin Hooverson Says:
    January 3rd, 2010 at 9:00 am

    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

53. Arun Says:
    January 8th, 2010 at 1:36 pm

    Thanks…

54. NKO Says:
    January 11th, 2010 at 3:53 pm

    thanks! very helpful indeed

55. leo Says:
    January 15th, 2010 at 5:10 pm

    I can enable the sql browser
    btw im seeing two instance. a sqlexpress and mssqlserver

56. Aaron Says:
    January 18th, 2010 at 12:11 am

    thanks..

57. DJeffer Says:
    January 27th, 2010 at 1:19 am

    Thanks a lot! Very helpful.

58. gelder Says:
    February 2nd, 2010 at 1:44 am

    Thanks my friend!

59. abhineet komal Says:
    February 5th, 2010 at 1:18 pm

    thanx, u have explained it brilliantly

60. Ulyana Arsov Says:
    February 5th, 2010 at 7:15 pm

    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

61. charles Says:
    February 6th, 2010 at 5:36 am

    Very Good Thanks

62. Gautam Says:
    February 7th, 2010 at 12:35 am

    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

63. JVillamil Says:
    February 7th, 2010 at 1:53 am

    Gautam:
    You need a user in SQLServer to login and the pass off course

64. Gautam Says:
    February 7th, 2010 at 7:59 am

    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

65. JVillamil Says:
    February 7th, 2010 at 10:27 am

    Gautam that’s rigth, I’m sorry I should say: change of

66. JVillamil Says:
    February 7th, 2010 at 10:29 am

    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)

67. Daniel Says:
    February 7th, 2010 at 8:34 pm

    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)”.

68. JVillamil Says:
    February 8th, 2010 at 1:51 pm

    Daniel: why no connect by TCP / IP ???

69. Discount Code Says:
    February 8th, 2010 at 10:47 pm

    Thanks a lot.. It was exactly what I was looking for. Much appreciated..

70. Gautam Says:
    February 8th, 2010 at 11:09 pm

    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.

71. linglom Says:
    February 11th, 2010 at 10:34 am

    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.

72. dilip Says:
    February 18th, 2010 at 3:12 pm

    http://localhost:8080/reportserver but i want to use only http://localhost/reportserver but it not connect because port number require but how can connect without port number.

73. JVillamil Says:
    February 19th, 2010 at 1:41 am

    mhmhmh, you should configurate the IIS to run the ReportServer to the port 80

74. Sinbad1 Says:
    February 23rd, 2010 at 10:40 am

    I can’t thank you enough !
    Excellent walkthrough .

75. PBC Says:
    February 25th, 2010 at 2:29 am

    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 …

76. terirog Says:
    February 26th, 2010 at 5:53 am

    Thanks! Clear and very helpful.

77. Agus Says:
    March 17th, 2010 at 1:33 pm

    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…

78. GIJack Says:
    March 17th, 2010 at 10:55 pm

    I still cant connect using ipaddress

79. Andy Says:
    March 19th, 2010 at 5:47 am

    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.

80. Gojko Says:
    March 19th, 2010 at 9:27 pm

    It’s awesome, thnaks….

81. kv Says:
    April 7th, 2010 at 12:24 am

    thx for the info that was what i was looking for

82. Deepika Says:
    April 14th, 2010 at 1:26 am

    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.

83. linglom Says:
    April 14th, 2010 at 12:33 pm

    Hi, Deepika

    You can use Microsoft SQL Server Management Studio from other pc to connect to the SQL Server. Or you can download and install the tool – Microsoft SQL Server Management Studio Express.

84. Mike Says:
    April 20th, 2010 at 6:55 am

    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.

85. Ravi Says:
    April 20th, 2010 at 6:07 pm

    thanks a lot buddy,. it helped me a lot

86. Vibgy Joseph Says:
    April 22nd, 2010 at 7:18 pm

    @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”

87. wn Says:
    April 26th, 2010 at 6:50 pm

    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

88. paramsrikant Says:
    April 28th, 2010 at 4:08 pm

    Thanks a lot. It is very helpful!

89. itl Says:
    May 6th, 2010 at 9:34 pm

    The “,” saved my day!!

    So, if SQL is on different port then default 1433

    SERVERNAME(OR IP)\InstanceNAME,PORT

    ex: SQLSRV01\SQL2008,1588

    thx!!

90. Keren Says:
    May 17th, 2010 at 6:07 pm

    THank you deeply!!! great article – helped a lot!

91. Edward Says:
    May 17th, 2010 at 10:59 pm

    I owe you one! This is sheer gold. Got it running v. quickly.

92. Andy Says:
    May 19th, 2010 at 9:27 am

    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.

93. Kepa Says:
    May 19th, 2010 at 3:51 pm

    Thank you very much, is a perfect guide!!

94. RahulR Says:
    May 20th, 2010 at 6:37 pm

    Thanks a Lot! It worked for me!

95. Puroh Says:
    May 20th, 2010 at 11:55 pm

    Thanks.. This is how all guides should be written! Nice work

96. Jan Says:
    May 31st, 2010 at 8:04 pm

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

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

    Thanks!

97. Derrick Says:
    June 3rd, 2010 at 3:22 pm

    thank you so much..

    it help me a lot..

    thanks..

98. SQL Server 2008 R2 Express remotely - IT Consultant Says:
    June 7th, 2010 at 8:30 am

    [...] Server 2008 R2 Express remotely Jun.06, 2010 in Tweaks and Tricks If you’re trying to connect to SQL Server 2008 Express remotely without enable remote connection first, you may see these error [...]

99. Bud Aaron Says:
    June 16th, 2010 at 2:38 am

    The post above is very complete but falls down at step 7. You need to click properties and enable specific IP addresses. Check here for details:
    http://videotutors.net/SQLServer2008RemoteAccess.aspx

100. Sarmad Says:
     June 18th, 2010 at 4:46 am

     Thanks a lot man !! it is very Helpfull.

101. Sarath Says:
     June 21st, 2010 at 8:45 pm

     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.

102. Mehboob Says:
     June 24th, 2010 at 11:25 pm

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

103. Sundar Says:
     July 1st, 2010 at 1:02 pm

     Great Thanks.

104. Robbie Reyes Says:
     July 1st, 2010 at 10:06 pm

     VERY NICE!! EXACTLY WHAT I NEED! THANKS!

105. Dave Says:
     July 2nd, 2010 at 3:18 am

     Thank you, Thank you, Thank you, Thank you, Thank you, Thank you…………….

106. Dams75 Says:
     July 7th, 2010 at 6:37 pm

     Thank you Mask for connection format.
     You just saved me.

107. Cathy Ooi Says:
     July 8th, 2010 at 5:15 pm

     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”.

108. Indoril Nerervar Says:
     July 11th, 2010 at 10:26 pm

     “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.

109. Asifali Kannattil Says:
     July 16th, 2010 at 7:29 pm

     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…

110. Asifali Kannattil Says:
     July 17th, 2010 at 1:22 pm

     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…….

111. Manish Jaiswal Says:
     July 22nd, 2010 at 5:17 pm

     This is a great great post…

     Thanks

112. Jmunoz Says:
     July 23rd, 2010 at 6:31 am

     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?

113. victor Says:
     July 23rd, 2010 at 8:03 am

     thanks from maputo!!!!

114. Enable to create ODBC Connection to SQL Server 2008 Express « Network PC Tech Blog Says:
     July 25th, 2010 at 10:39 am

     [...] while trying to make an ODBC connection to your SQL Server, take a look at the steps on this post. It helped [...]

115. Rakesh Says:
     July 27th, 2010 at 5:29 am

     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

116. Traci Says:
     July 30th, 2010 at 7:29 am

     Thank you! Saved me a ton of time!

117. Farshad Says:
     July 30th, 2010 at 3:23 pm

     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

118. Bruno Says:
     July 30th, 2010 at 8:43 pm

     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

Leave a Reply