Home Page link  

Can connect to HQ database but not Store database

  
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
Can connect to HQ database but not Store database Raymond Cheok 11-16-2005
Posted by Raymond Cheok on November 16, 2005, 12:17 am
Please log in for more thread options
 Hi,

My HQ database and Store database is sitting on different server. HQ on full
SQL 2000 server and Store on MSDE. When using administrator account, I can
connect to both. When using user account, I can only connect to HQ, Store
database is intermittent (most of the time, unable to connect).

I have tried Windows XP Home edition and Windows Pro edition. Both have this
problem. I have to give the user administrator rights to the PC in order to
connect to Store database. HQ does not have this problem.

Please help. Thanks.

Raymond



Posted by Andrea Caldarone on November 15, 2005, 5:32 pm
Please log in for more thread options
 There are some stuff you have to know about Windows XP way to autheticate
users, go to local policy group and set user authentication to classic mode
(default is that all users autheticate himself as guest).
Bad idea to use Xp Home.
Via Enterprise Manager you have to set right for user (Administrators group
are granted by default to access all databases), if have not EM you have to
use the command line tool OSQL (good luck....)

P.S.
Sorry for my english

> Hi,
>
> My HQ database and Store database is sitting on different server. HQ on
full
> SQL 2000 server and Store on MSDE. When using administrator account, I can
> connect to both. When using user account, I can only connect to HQ, Store
> database is intermittent (most of the time, unable to connect).
>
> I have tried Windows XP Home edition and Windows Pro edition. Both have
this
> problem. I have to give the user administrator rights to the PC in order
to
> connect to Store database. HQ does not have this problem.
>
> Please help. Thanks.
>
> Raymond
>




Posted by Raymond Cheok on November 16, 2005, 7:44 pm
Please log in for more thread options
Hi Andrea,

Thanks for your help. It solve my problems.
>On 11/16/05 12:32 AM, in article O96l3Hg6FHA.2192@TK2MSFTNGP14.phx.gbl, "Andrea

> There are some stuff you have to know about Windows XP way to autheticate
> users, go to local policy group and set user authentication to classic mode
> (default is that all users autheticate himself as guest).
> Bad idea to use Xp Home.
> Via Enterprise Manager you have to set right for user (Administrators group
> are granted by default to access all databases), if have not EM you have to
> use the command line tool OSQL (good luck....)
>
> P.S.
> Sorry for my english
>
>> Hi,
>>
>> My HQ database and Store database is sitting on different server. HQ on
> full
>> SQL 2000 server and Store on MSDE. When using administrator account, I can
>> connect to both. When using user account, I can only connect to HQ, Store
>> database is intermittent (most of the time, unable to connect).
>>
>> I have tried Windows XP Home edition and Windows Pro edition. Both have
> this
>> problem. I have to give the user administrator rights to the PC in order
> to
>> connect to Store database. HQ does not have this problem.
>>
>> Please help. Thanks.
>>
>> Raymond
>>
>
>



Similar ThreadsPosted
Worksheet 51 to copy from HQ database to each store database July 8, 2008, 12:07 pm
Could not connect to the database October 24, 2005, 11:22 am
Can't connect to database April 9, 2007, 8:04 am
Connect to Database every power-up? August 19, 2005, 6:18 pm
Unable to connect to database November 4, 2005, 2:10 pm
Unable to Connect to database November 22, 2005, 8:52 pm
Unable to connect to database March 8, 2006, 4:41 pm
does anyone know how to connect RMS database and yahoo web-site? January 19, 2006, 3:41 pm
Setting up second register, how to connect to database October 18, 2006, 2:31 pm
synchronize a store database to another HQ database June 8, 2006, 9:52 am

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