Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-12-12 : 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 /PsapasswordThe 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.Thanks" |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-12 : 13:43:10
|
1) The password may be different of that server. Are you sure it's the same server you tested against?2) Are you sure you don't want to specify a template? You could get quite a bit of useless data back...3) I'm not sure you need to type ".exe". The extention should not be needed.4) Try using "/E" instead of "/U" + "/P". Using "/E" will make sure that no passwords are saved to that plain text batch file of yours. |
|
|
|
|
|