February 12, 2017 at 11:05 pm
I installed sqlserver 2012 on a server which runs Sql server 2014.
while i am trying to create DB Objects through SQLCMD i am getting an error
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login failed for user
Any idea why this error
February 12, 2017 at 11:43 pm
Hi,
it is very difficult to help you, because we cant't see the script you use to connect.
Show us the script, and we be albe to help you.
Kind regards,
Andreas
February 13, 2017 at 12:02 am
The login you're using doesn't exist, or the password is wrong, or you're trying to connect to a DB that the login doesn't have access to, or (about 12 other possible causes)
Check the SQL error log, the full message, along with reason, will be in there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply