I am getting error message on login as follows:
K:\>isql -U BSCI\ziegelmd
Password:
Msg 18456, Level 14, State 1:
Login failed for user 'BSCI\ziegelmd'.
DB-Library: Login incorrect.
I can login using isqlw, and the test connection via Visual Studio 2003
works. The security is set up for SQL Server and Windows. Starts in system
account. User BSCI\ziegelmd is set up for the master database. I am using
the same password as Windows domain logon. Everything is on XP professional
OS. This problem is stopping me dead in my tracks. Any suggestions would be
highly appreciated.
ISQL -E
The -E indicates trusted connection and will use the currently logged on
user's NT credentials.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dziegel" wrote:
> I am getting error message on login as follows:
> K:\>isql -U BSCI\ziegelmd
> Password:
> Msg 18456, Level 14, State 1:
> Login failed for user 'BSCI\ziegelmd'.
> DB-Library: Login incorrect.
> I can login using isqlw, and the test connection via Visual Studio 2003
> works. The security is set up for SQL Server and Windows. Starts in system
> account. User BSCI\ziegelmd is set up for the master database. I am using
> the same password as Windows domain logon. Everything is on XP professional
> OS. This problem is stopping me dead in my tracks. Any suggestions would be
> highly appreciated.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment