Home Page link  

SQL setup RMS 2.0

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
SQL setup RMS 2.0 Rich 06-19-2007
Posted by Rich on June 19, 2007, 2:10 pm
Please log in for more thread options
 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

Posted by root on June 19, 2007, 2:59 pm
Please log in for more thread options
 -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

>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



Posted by Greg [DRS] on June 19, 2007, 5:57 pm
Please log in for more thread options
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."

>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



Posted by Rich on June 22, 2007, 11:06 pm
Please log in for more thread options
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

Similar ThreadsPosted
POS & EDC Setup April 25, 2006, 8:08 am
RMS & EDC SETUP May 19, 2006, 3:36 pm
POS Setup August 1, 2006, 3:55 am
Need RMS Setup May 4, 2007, 1:20 pm
New setup of RMS December 17, 2008, 11:03 am
Scale Setup July 1, 2005, 7:13 am
How to setup PCCharge Pro with POS December 8, 2005, 11:26 am
security setup December 21, 2005, 4:10 pm
10% Coupon setup May 5, 2006, 11:42 pm
TM88iii setup June 26, 2006, 3:01 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap