SQLTeam.com | Weblogs | Forums

Is it possible that a user login is failed due to DNS

sql2008r2
sql2012
sql2014

#1

Hi Guru's

I'm facing issue for user login failure on the server, user is not able to connect to the database.
I'm getting following error msg

"Msg 8152, Level 16, State 14, Line 13
String or binary data would be truncated.
The statement has been terminated.
"
Just want to confirm, is it possible that user login failed due to DNS entry on the server ?

Please reply me for this query.

Thanks in advance!

Shekhar


#2

Hi,
The error seems to indicate that it did connected, but the statement fail (either an update or insert), I would try to run a track on the server and try to simulate it again, that way, you can capture all the login info and what is actually running that generate this error.
Hope this helps


#3

Many thanks Dennisc for the reply,

Actual users were trying to connect database from application & DNS on server is not accepting character string as the database name was long, latter on i have modified the DNS and put in DBID in place of database name. after tweaking application users were able to connect to the database.
Your idea of tracking will also worked to actually locate/ diagnose the issue.

Thanks once again !