Inventory Control Question


U

ucsutah

I have Microsoft RMS setup in the front for sales and i have one in the back
on the server just for scanning inventory and no sales.

What i need is the back server to be able to pull from the same database as
the front?

How do i do this?

thanks
 
Ad

Advertisements

U

ucsutah

Never Mind, I have posted several times with know replies on any of my posts
and its been months. So i figured how to do this and will post for anybody
else that needs it because i am here to help others if they need it.

1) start, all programs, Microsoft dynamics rms. and client network utility.
alias, type in a name for an alias on your network.
2) On the server computer where your database resides. start, all programs,
sql server configuration manager, sql native client configuration, and
aliases. Right Click and create a new Alias. In Alias type the same name you
created on the network client network utility under aliases. Port No i left
blank, Protocol used TCP/IP. (Note if you use a different protocol you need
to keep both the same). And on server I typed in localhost unless you
actually have a database server name.
3) Start Store Operations Administrator
File connect, use sql server authentication, username you created on your
database, then password. Enter your database name the one you created for the
store, then under the drop down you should see your Alias you created click
on that and then you should have database connected.
4) Click on Database then select and then select your database.

thats it you should be able to connect.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top