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 b
e
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 syst
em
> account. User BSCI\ziegelmd is set up for the master database. I am usin
g
> the same password as Windows domain logon. Everything is on XP profession
al
> 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