Hi,

I was able to install the databases (ReportServer and ReportServerTempDB) on a another SQL Server. It could have been the reason that the original server I was intended to install had...

You can create a replica making your database as the design master. You can synchronize the replica and the design master too, but to schedule the synchronization, you will need...

I ran into this issue many times. It's an invalid date senario. In Access you can enter enything you want in a date field unless it has a input mask. Sort...

We are using a different solution to schedule the package using dtsrun utility in the command prompt and scheduling the bat file on windows scheduler. It's working fine so far.

Do you want to move the tables to MSDE and leave everything else on the Access so that the data remains on the MSDE and Access will be front end?

If...

Peter, we use ASP.Net and SQL Server as well, which I beleive is a N-tier because of using a browser, webserver(business logic) and database.

Now if I am using windows...

You will need a ASPNET user account to login to the server or Windows Integrated security. 

Hi,

We have some applications use MS Access 2000 front end and SQL Server 2000 back end. All the tables and views are linked using DSN-less ODBC connections. We have the Access front...