that's correct, just verified it.I should have checked it first.

Thanks Gail for all your help and reply....

Thanks Lowell, the issue is not because of performance but because of having data and log file spread across the system....

Unless you're planning to move things like sqlservr.exe and it's related executable files and resource files, leave resource DB. It should be treated exactly like one of the application dll...

Thanks Gail, so what the best approach you suggest?

did you configured that windows account on secondary server as well?

If not then configure the account on secondary server and...

Sorry cant understand, your server is sql 2005(as per screenshot) or 2008R2.

same logshipping implemented in...

Assuming there is no change in policy for this account in server, i will like to know:-

were you ever able to access the sql server via the mentioned windows login?

The...

C2 audit will be able to do this.

and this query will help

EXEC sys.sp_configure N'c2 audit mode', N'1'

GO

RECONFIGURE WITH OVERRIDE

GO

is the windows account active? Check the status of windows account in active directory.

you need to use a batch file for this. Logic will be something like :-

1) run this on cmd :- sqlcmd -l > c:\serverlist.txt

you will get server list.

2) create...

as long both id have their dedicated server defined, they will not contractdict with each ohter on their unique sid.

yes, create same login and pwd in both server and give required permission.

You will be able to connect the database.

Its like you can have same name and password for your...

what type of permission for user2. But be the case the case that he have some high level permission which inherit these base level permission automatically.

Assuming you able to ping both server from each other. Then

1) yes with sql login. To connect sql box with sql authentication, mention the full instance name. If you get...

This is also written in same language