web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Sql server 2008 r2 and...
Microsoft Dynamics RMS (Archived)

Sql server 2008 r2 and Back office

(0) ShareShare
ReportReport
Posted on by Community Member

I just replaced sql server 2000 to sql server 2008 r2 express and now I cant connect to back office.

Is special  instruction on r2 ? I can see al the shared file on same pc and I also can ping from back office. But I cant connect to RMS.

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Here is full error,  2147467259 dbnetlib , connection open handshake, general network error,check your network decumention. source; msoledb provider for sql server, sql state;08001

    native error:11

  • SpeedJet Profile Picture
    SpeedJet 110 on at

    What version of RMS are you using?

    Named pipes or TCP/IP?

  • Verified answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at

    Did you open the TCP/IP and Named Pipes protocols after the install?   They are turned off by default now starting with 2005.

  • Community Member Profile Picture
    Community Member on at

    Mr Jeff , thanks for helping

    Fixed, When I installed sql server 2008r2 I think I didn't enable sql server browser, But I found article on google which helped me to solve the problem. On the SQL studio I connected like that and It start working. servername: REGPC\192.168.1.5,1433

  • Community Member Profile Picture
    Community Member on at

    How did you fix it? I have a same issue. Please ~~~~

  • Community Member Profile Picture
    Community Member on at

    download.pro.parallels.com/10.3.1/docs/windows/Guides/pcpw_upgrade_guide/7351.htm

    this is for 2005 but same step as 2008 as well.

    Hope this help.

  • RMS Goddess Profile Picture
    RMS Goddess 172 on at

    Had the same issue and just had to restart the SQL Server Browser

    Thanks to everyone who has posted on this issue.  Turned a long process into a very short one to resolve.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans