SQL setup RMS 2.0

I am setting up a new system with 3 registers (Win XP SP2), two back office 
computers (Win XP SP2 and SQL 2005 Express), and Windows SBS 2003 with SQL 
Server 2005 Professional.  The problem: Can't get the back office 
workstations to connect to the SQL Server.  I installed RMS on the server, it 
connects to SQL and run perfectly.  When I try from the workstation using RMS 
Admin, I get a time out error.  I did everything in KB932078 without success.

Must be something very minor with major consequences that I've missed.  Can 
anyone help?

Thanks 
Rich
0
Rich (271)
6/19/2007 6:10:00 PM
pos 14173 articles. 0 followers. Follow

3 Replies
450 Views

Similar Articles

[PageSpeed] 56

-firewall
-sql surface area config (allow remote connections)
-client config tool on client cpu's - alias and ip address rather than name
-proper sa password

"Rich" <Rich@discussions.microsoft.com> wrote in message 
news:AC2D487E-F55D-47BA-95F3-05DDE24BA6F5@microsoft.com...
>I am setting up a new system with 3 registers (Win XP SP2), two back office
> computers (Win XP SP2 and SQL 2005 Express), and Windows SBS 2003 with SQL
> Server 2005 Professional.  The problem: Can't get the back office
> workstations to connect to the SQL Server.  I installed RMS on the server, 
> it
> connects to SQL and run perfectly.  When I try from the workstation using 
> RMS
> Admin, I get a time out error.  I did everything in KB932078 without 
> success.
>
> Must be something very minor with major consequences that I've missed. 
> Can
> anyone help?
>
> Thanks
> Rich 


0
anonymous (74722)
6/19/2007 6:59:45 PM
Have you tried testing the database connection again immediately after you 
receive the timeout error?
Is the Timeout set to 60?
Did you configure the full version of SQL 2005 on the server for backward 
compatibility to support RMS?

Greg
Digital Retail Solutions
www.digitalretailer.com/rmsaddins
"Save a million keystrokes."

"Rich" <Rich@discussions.microsoft.com> wrote in message 
news:AC2D487E-F55D-47BA-95F3-05DDE24BA6F5@microsoft.com...
>I am setting up a new system with 3 registers (Win XP SP2), two back office
> computers (Win XP SP2 and SQL 2005 Express), and Windows SBS 2003 with SQL
> Server 2005 Professional.  The problem: Can't get the back office
> workstations to connect to the SQL Server.  I installed RMS on the server, 
> it
> connects to SQL and run perfectly.  When I try from the workstation using 
> RMS
> Admin, I get a time out error.  I did everything in KB932078 without 
> success.
>
> Must be something very minor with major consequences that I've missed. 
> Can
> anyone help?
>
> Thanks
> Rich 


0
support7094 (156)
6/19/2007 9:57:57 PM
Thanks root and Greg-

One of root's comments led me to check the ip of the server.  The vendor set 
it up with a dynamic ip.  I changed it to a static ip, created an alias to 
the ip and was up and running in minutes.

Thanks again for taking the time to reply. 
Rich


"Rich" wrote:

> I am setting up a new system with 3 registers (Win XP SP2), two back office 
> computers (Win XP SP2 and SQL 2005 Express), and Windows SBS 2003 with SQL 
> Server 2005 Professional.  The problem: Can't get the back office 
> workstations to connect to the SQL Server.  I installed RMS on the server, it 
> connects to SQL and run perfectly.  When I try from the workstation using RMS 
> Admin, I get a time out error.  I did everything in KB932078 without success.
> 
> Must be something very minor with major consequences that I've missed.  Can 
> anyone help?
> 
> Thanks 
> Rich
0
Rich (271)
6/23/2007 3:06:00 AM
Reply:

Similar Artilces:

Changing password #2
Hi, If I change a domain user's password, will that user's Exchange Server 2003 mailbox's pssword be changed too? I mean, does Active Directory share the same password with Exchange Server 2003? Thanks! Exchange never had passwords separate from domain, not even in Exchange 4-5.5 era. So you would change just one password, which belongs to AD account. Michael wrote: > Hi, > > If I change a domain user's password, will that user's > Exchange Server 2003 mailbox's pssword be changed too? > I mean, does Active Directory share the same password > w...

CRM 3.0 Mobile & Lead Entity
Why is the Lead entity not included as part of CRM 3.0 Mobile? You would think a sales rep in the field would want to have his "Leads" on his pda, so he could work them and sync back to the host. Any thoughts? Will it be included in a future release? Thanks... Agreed, this is the biggest request I get from my mobile users. I do understand there may be a problem keeping the lead list to a manageable size... -- Len Ott Socket Communications "bw" wrote: > Why is the Lead entity not included as part of CRM 3.0 Mobile? You would > think a sales rep in the fi...

Customizing 3.0 Router
Is there a way to "turn off" the email router for certain users or contacts? For example, I do not want emails from CRM contacts to our CEO to be created as activities in CRM. Another example, I do not want emails from our attorney (a CRM Contact) to be open to everyone in CRM either. Any suggestions? Thank you, it would help me a lot. My understanding is that you can enable/disable specific recipients (read: crm users) from having their e-mail promoted to CRM (by using the CRM EMail Rule Deployment Wizard), but I don't think there is a way to filter based on the send...

CRM DMF 3.0 and error code 0x80040225
We want to migrate some data from a non-CRM system into CRM 3.0 using DMF 3.0. The CDF database has been initialized, so that the current users in the target CRM system are in the cdf_systemusers table. We've written a program that reads the inhouse system's data and maps it into CRM/CDF records, relating records to the correct CDF system user ids (by matching the domainnames to get the systemuser ids). The net result is that we want DMF to migrate the following CDF tables (including their ext and info tables): account contact opportunity opportunityproduct product quote quotedetail ...

Opportunity Products in 4.0
Is there a bug in 4.0 with regards to the addition of opportunity products to the opportunity? I can't figure this out but I've done all the set up of units, unit groups, price list items just as it was in 3.0, but yet when I try and add a price list to the opportunity in 4.0 the lookup list is empty. It seems hard to believe there's a bug in the product as it worked in 3.0 but then again I've analyzed this from every angle and I cannot see that I'm doing anything wrong in terms of set up. Help is appreciated! It should work. I think that CRM filters the available price ...

Learning Multicurrency in GP 10.0
I'm plan to start implementing Multicurrency with a customer that has basic Multicurrency needs. They need to print out PO's in Euros and then record payments made in Euros. What's the basic steps to go about this? What's the best place to get training on Multicurrency? -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com There is a manual in either printable manuals or off customercource. There might be an e-learning course. I would say first you should be comfortable doing currency translation in general on paper or in your ...

Field dependent on 2 other fields
Hi, I have 2 fields, Nature_of_advice1 and Nature_of_advice2. Either of these fields can select the option "other" which will then show fields Other1 or Other2 for completion. This part works fine! However, if the user selects "other infection state" in either of the first 2 fields mentioned then they need to complete a third field which I would like to be hidden unless needed. I have an after update event for both fields to show/hide the secondary fields, and have put the same info into the form's OnCurrent field. It all seems to work OK unless I select &qu...

How to set include files in wince subproject 6.0
Hi I am creating application in wince 6.0, while build the source code I received build error. C:\WINCE600\public\common\sdk\inc\fsdmgr.h(35) : fatal error C1083: Cannot open include file: 'diskio.h': No such file or directory Since i include the following path C:\WINCE600\PUBLIC\COMMON\OAK\INC to Tools->option->ProjectSolution->VC++Directory, Still i got the same error. Pls any one advise me how to add the include file in the root. Regards Venkat Set your include path in the following dialog Project-->Properties-->Configuration Properties-->...

Emailing as message #2
Hi, I have been facing this problem with publisher lately (more so with the new office version i guess). When I try sending my publisher file as a message email, the alignment is almost never correct. Please suggest what to do. It's urgent. Send the info as a .pdf attachment. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Publisher, email as message" <Publisher, email as message@discussions.microsoft.com> wrote in message news:30CC3CD3-23D1-4E17-86F9-726C29CAEC73@microsoft.com... > Hi, I have been...

How can I open files from a prev. version of Publisher in Pub 2000 #2
Is there a way to open files from an earlier version of Publisher in Publisher 2000? I have a file that I cannot access, that I believe was created in Publisher 97 or 98, that I need to access, but I get an error message that says it cannot be opened. You should be able to open it. Maybe it is a 2002 or 03 document. Do you have Norton? Disable script blocking and in Norton Options Office Plug ins. If that doesn't work send the files to me and I will convert them for you. Remove "my" to reply. -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news:...

mscrm 3.0 "Go Mobile" privilege
The "Go Mobile" privilege as per the available help synchronizes Microsoft CRM information with Microsoft Windows Mobile devices. Does that mean Microsoft is coming out with another CRM mobile implementation for the 3.0 version. I need all the info regarding any mobile crm application that might work with the MSCRM 3.0. And, what exactly is the scope of this privilege. Can it be used for custom applications developed for the same? Download the implementation guide and see http://www.microsoft.com/downloads/details.aspx?FamilyID=e4a7ef88-d6b4-4eea-836c-eed8e174b769&displaylang...

Printing in color #2
I am not able to view or print my document in color. On the screen in the "working" mode it is correct but when I click "view" pr "print preview" it is not in color. Sallygirl wrote: > I am not able to view or print my document in color. On the screen in the > "working" mode it is correct but when I click "view" pr "print preview" it is > not in color. Have you actually tried printing? Publisher 2007's print preview is buggy on some HP printers and will only display black and white. Oh, and you are using a colour ...

Image Preview #2
Hi, for those interested in image previews, the following link might be interesting: http://www.geocities.com/giovanni.dicanio/vc/index.htm There is also a Power-Point presentation explaining something, and there is the full source code with comments (the code needs more tests and also reviews, but it seems in a good state now :) The code implements a custom Win32 image preview control in C++, and also an extension to open file common dialog, which offers image previews using the aforementioned custom control. The DLL is implemented in C++, but it exposes a C interface (so it can be used ...

Where is budget ID setup window
When attempting to create a dedicated PO for a Back Ordered item. (The PO is created and saved. When you go into Purchase Order Entry Window and attempt to view/ re-save the document, it gives me the message. "There is no budget ID setup for this fiscal period. Please assign a budget ID using the PO Enhancements Setup Window." We don't need to budget for this item and we haven't set up any budgeting for GP. We don't manfacture it and we are basically a resaler of the item. We just need it to go into inventory, fullfill the order, and go back out through COGS. I'...

Miscalculation of 2 fields?
In a database for a printing company, I've got a form that has a field for "Quantity" ordered and "Finished" total pieces created. When an order is written up the "Quantity" is filled in and the order goes into production. Once production is finished, a final count is taken including all extras and that count is entered into "Finished". Once "Finished" is updated and the user tries to exit the "Finished" box, a calculation is done to make sure the the value of "Finished" is not less than the value of "Quantity&qu...

About CRM 3.0 Speed
We have in our production system delay of 6-7 seconds when opening any CRM pages. It seems that after page reguest from client, nothing happens for this 6-7 seconds, but after this page itself opens wery quickly. Configuration: Client: mainly Core 2 Duo w/ 2G CRM / Exchange: SBS2003 w/2G, no R2 or ISA Separate SQL 2005 3G RAM, 2x72G 10krpm Raid 1 w/battery accelerator. 100Mb LAN When i access CRM, it seems that no stress to SQL server is produced. So I am pretty sure its not SQL that causes this delay. I have read a tons of suggested workarouds, but nothing seens to help. Any further i...

Audit Trails upgrade to 10.0
Want to confirm that there is a direct upgrade path from 8.0 w/service pack 5 to 10.0 for Audit Trails...thanks ...

RMS Signature Capture on Receipt Solution
Dear Partners, We have released our new solution for RMS Signature Capture on receipt. If you are interested please drop a email. Regards, Manick manick.m@hotmail.com ...

Microsoft .NET Framework 2.0 Service Pack 2 Security Update for Wi
i keep getting this update every few min from the automatic updates on xp pro sp3 this update is installed & it appears in the registry & in the add remove programs it installs says it installed succesfully but it keeps coming up i have tryed removing it from the reg & uninstalling it from add remove program & reinstalling it but this update wont stop coming in any ideas on how to stop this from poping up every 2 min "dez" wrote: > i keep getting this update every few min from the automatic updates on xp pro > sp3 > this update is inst...

Button #2
How do I create a simple button to which I can assign a macro to? Hi Felix there's lots of methods, personally i like using the drawing toolbar autoshape objects (stars / rounded squares etc). Display the drawing toolbar (view / toolbars / drawing), click on autoshapes, choose basic shapes (or whatever), click on your workbook ... to assign the macro, right mouse click choose Assign macro Cheers JulieD "Felix" <anonymous@discussions.microsoft.com> wrote in message news:274d001c463f3$c31bd380$a601280a@phx.gbl... > How do I create a simple button to which I can assign...

Outlook security #2
Hi, Is there anyway to findout whether anyone is monitoring my mailbox(e-mail) Also is there any way to find out whether the mail is going to a 3rd person ( not in the list) without my knowledge? Thanks ------------------------------------------------ ~~ Message posted from http://www.OutlookForum.com/ ~~ View and post usenet messages directly from http://www.OutlookForum.com/ ...

Merging columns? #2
::Thanks for responding, Myrna. There is only one row per person-- and no, there is not a blank ro between each filled row. Carol : -- Carolina7870 ----------------------------------------------------------------------- Carolina78703's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1562 View this thread: http://www.excelforum.com/showthread.php?threadid=27225 If you have only one row for each person, I guess I don't understand what you want to do. Combine the entries in A1, B1, C1, and D1, with a space between? If so =A1&" "&B1&&...

Reply rule confustion
Additional questions have arisen from original question that was answered by Peter (original question below). Got the rule setup and working using the "have server reply" option, but can it be made to only respond once to each sender kinda like the out-of-office auto-reply? ORIGINAL POST Instead of Reply Using a specific template in your rule, use Have server reply using a specific message. -Peter "Bill Clark" <billc@no-email.com> wrote in message news:esL6X4glKHA.2132@TK2MSFTNGP05.phx.gbl... > Running Exchange 2007 SP1 w/ Outlook 2003 clients. I...

Microsoft exam for RMS 2.0
Hi I will be trying for certification in RMS 2.0 this Thursday, does anyone have or know where I can get some sample questions which might appear in the exam. Thanks Gareth hi Gaz, Sample I am not sure but I made my own Q&A consider look at the administration database part, license for the evluation, period, restore, backup collation, in SO all things they normally cover security is not that much. and POS also cover a lot. I will see if I can send you the email of my own Q&a send me your email. "Gaz" wrote: > Hi > I will be trying for certification in RMS 2.0 t...

Quicken: Weeks 1 & 2
As a now-ex Microsoft Money customer, this is my review of Quicken after 1 week of usage. -- Background -- I've been using Money daily for 6 years to track our 5 checking and savings accounts, 14 credit cards, 4 retirement accounts, 2 student loan accounts, 2 personal loan accounts, and 2 employee ISO plans. To say I was devastated by the news is an understatement. Unfortunately I was one of the first to buy the Money Plus release, so there was only a mere 8 weeks after the news broke before my copy would expire on August 8th. The big decision was whether or not to stick with Money for ...