How do i configure my payroll program in SQL server 2000.?

Question

I want to run my payroll program have a server, that why i choice an SQL server 2000.

Answer 1

Much too vague to answer, I'm afraid... Does your payroll program support SQL Server 2000? (Is this payroll program something you've bought? In which case what is it called? Or is it something you're writing?)



How does the payroll program connect to its database - ODBC? Are you just wanting the ODBC connec string? More details please and/or feel free to email me...

----



Got your email but can't reply as your email address hasn't been confirmed by Yahoo - please fix and we can correspond to help fix your problem.

Answer 2

Since we don't know which program do you run, I will state :

3 Typical settings for programs running on MS SQL server.

1. You must have installed and Patched (with last service pack) MS SQL server.

2. You must be sure that you can connect to MS SQL server from your workstation - typical example for this is using Query Analyzer to make sure that you can connect to master database. This means that you have set ted user name and password with rights for creation and drop database on server. Also you must check payroll program manual to see how its is connect to MS SQL and do it - typical example is trough ODBC (in this case you set ODBC connection string and check it to see if it works.Slow method) or trough native MS SQL connections (you must configure MS SQL Server and Client Network Utility.Faster method)

3. You must again read payroll manual and check how it uses MS SQL databases - typical example here is that in most cases you must manually create database for your program on server, using script, which you run trough Query Analyzer.

After you finished these steps you can start your payroll program and see if it work good - i.e., program can access her own database on MS SQL server and can fill and read data from it

Hope This help. Best Luck.

Answer 3

considering sq. 2008 has been out for a lengthy time period i'd stay faraway from 2000 and concentrate on 2005 and 2008. do not anticipate any save would have a unmarried version of the DB round. we are presently deploying 2008 for brand spanking new platforms we setup and latest 2005 platforms will be migrated over the subsequent 3 hundred and sixty 5 days. i does not waste any time on 2000 until eventually there's a particular pastime you're going for that makes use of it.