1)The default database is set by login. See sp_defaultdb in the books online.

Not sure if they can still login when the default database is offline.

(can somebody confirm or correct this?)

2)They...

perhaps you should trace the route the pakket that ping sends.

in a "dosbox"  ( execute cmd)

tracert 10.0.0.5

should deliver an output (or similiar):

tracing route to 10.0.1.5 over a maximum of 30 hops

1) <10...

Thats right.

Restore would be:

*restore full backup of saturday with norecovery

*restore differential backup of wednesday with norecovery

(this instead of applying all transactionlogs since saterday, which would take a long time)

*apply...

1) adding an access database :

EXEC sp_addlinkedsrvlogin

    @rmtsrvname = 'MyAccessTable',

    @useself = false,

    @locallogin = 'loginame',

    @rmtuser = 'admin', /*default access account*/

    @rmtpassword = NULL /*always NULL, see the link below*/

2)...

If adhoc queries would be permitted, your original select will most likely work.

I personally haven't any experience querying access tables through sql server.

Vijay, mind to share the solution for future reference?

You can find a list of connectionstrings at

http://www.connectionstrings.com/

Can be a standalone server without a domain.

For windows authentication it needs a domain except if you run the application on the server itself.

See the books online (sql server help...

Is the database being protected by access user security?

In this case you probably have to copy the mdw file to your sql server.

A Workgroup Information File (*.MDW) stores information to...

Looks they have service pack 4 of sql server where the issue should be resolved.

If adhoc queries of your access databases isn't allowed, you can still refer to them if...

cvsql1\administrator should be correct

My account in SQLServerAgent service got abbreviated to

.\administrator

I hope this helps.

if the number of transactions isn't too great.

SELECT StockTransactions.StockID

,ISNULL(Tran1.AvgAmount,0) AS AvgAmountforTransactionid1 ,ISNULL(Tran2.AvgAmount,0) AS AvgAmountforTransactionid2

from ( /*All distinct StockIDs to join*/

select distinct StockID

from test.dbo.StockTransactions StockTransactions

) StockTransactions

left join /*Calculate transaction 1 */

(SELECT...

Normally it is computername\administrator.

You can find a valid list of users in usermanagement in windows.

(Start->Settings->Control Panel->Users & Passwords)

Can you change the sql agent service account to the administrator account instead of NT AUTHORITY\SYSTEM? So far I know local system account has no rights on any networking stuff.

If you...

Starting the profiler and tracing for any delete / truncate table / drop table statements?