Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Sql server 2008 r2 and Back office

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • RMS Goddess Profile Picture
    RMS Goddess 170 on at
    RE: Sql server 2008 r2 and Back office

    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.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sql server 2008 r2 and Back office

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sql server 2008 r2 and Back office

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sql server 2008 r2 and Back office

    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

  • Verified answer
    Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Sql server 2008 r2 and Back office

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

  • SpeedJet Profile Picture
    SpeedJet 110 on at
    Re: Sql server 2008 r2 and Back office

    What version of RMS are you using?

    Named pipes or TCP/IP?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sql server 2008 r2 and Back office

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,440 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans