Ask SQLTeam Question
Posted - 12/12/2005 : 07:27:14
| Biswa writes "I used the following at command line to start and connect SQL Profiler at a remote server;
profiler.exe /Sservername /Ddatabase /Usa /Psapassword
The profiler started and connected perfectly.
But when I used the same line inside a batch file and tried to run the batch file, it could not connect and the error message said "Login failed for user 'sa'".
For your information, I used all the environments identical for both the tests.
Is it a bug in SQL Server 2000 ?
I have SP3 applied to my server.