finding out WHY the app won''t connect

Question

finding out WHY the app won''t connect

yogiberr

Hall of Fame

Points: 3679
More actions
June 20, 2005 at 2:41 am

#167504

hiya,
I've got a sample C# VS2005 app that connects to sqlServer 2005 dev.Well, that's the problem, it doesn't.Is it possible for me to view some sort of yukon log / something that will tell me exactly why it won't connect?Been starring at this for ages 🙁
Many thanks,
yogi

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 1

Do you get an error, or just a blank screen? I ask because I've been getting network packet size errors when trying to connect and found that there's apparently an issue with trusted connections in the current CTP. I switched to SQL Server connections (I'm only doing testing, so it's no big deal) on the 2005 server and that connection issue went away.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

yogiberr Hall of Fame Points: 3679 More actions · Answer 2

hiya,

I'm actually using a sample nHibernate app.I have tried using integrated security and standard.

the error is actually nHibernate specific:

"could not create connection from driver" but I was wondering if yukon could also provide some debug info to help me find out WHY the connection couldn't be created from the driver.

cheers,

yogi

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

Ah, well, you've just gone past my knowledge of the topic.

Good luck.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Bikeman Ten Centuries Points: 1207 More actions · Answer 4

what kind of environment? Are you using integrated security in AD/Kerborose environment? Are you getting SPPI error?

Is the error the same with sql and NT authentication?

look at sql logs as well as Event Viewer logs on the server....

yogiberr Hall of Fame Points: 3679 More actions · Answer 5

hiya,

I got it working with integrated security for the moment.It was probably a connString thing.Thats said, I'll have to familiarise myself with all the logging functionality so that I can better diagnose thes things in future.

many thanks all.

yogi