From the You Can Not Be Serious file
I was poking around the web today and found a nice post from Doug Hughes about an SQL server issue. The post was commented 88 times. Many people showed their gratitude to Doug for posting the solution to a vexing problem. One commenter takes the cake however:
Hi
I have a same problem.
I am Using SQL Server 2000 in my computer.
I try to access the sql server 2000 from another computer. Its gives error.
"unale to connect to server"
Please fix it
Thanks
Posted By Jenkins on Jun. 21, 2006 at 7:16 AM
I have a same problem.
I am Using SQL Server 2000 in my computer.
I try to access the sql server 2000 from another computer. Its gives error.
"unale to connect to server"
Please fix it
Thanks
Posted By Jenkins on Jun. 21, 2006 at 7:16 AM
To which Joe Reinhart replied to, rather Tongue in Cheek:
Jenkins,
Care to send the IP addres and SA password?
Posted By Joe Rinehart on Jun. 21, 2006 at 8:31 AM
Care to send the IP addres and SA password?
Posted By Joe Rinehart on Jun. 21, 2006 at 8:31 AM
Then I laughed even harder when I read: (I placed the x's in there. I have a conscience.)
Hi Joe
In "connect to SQL Server" Window.
SQL Server : IP Address(114.x9.130.13)
I select SQL Server authentication
Login name : User Name (jenkins)
Password : pwd (*****)
Then i click ok.
Its gives error.
"unale to connect to server 114.x9.130.13"
Please fix it
Thanks
Jenkins
Posted By Jenkins on Jun. 21, 2006 at 8:55 AM
In "connect to SQL Server" Window.
SQL Server : IP Address(114.x9.130.13)
I select SQL Server authentication
Login name : User Name (jenkins)
Password : pwd (*****)
Then i click ok.
Its gives error.
"unale to connect to server 114.x9.130.13"
Please fix it
Thanks
Jenkins
Posted By Jenkins on Jun. 21, 2006 at 8:55 AM
Wow! I'd love to know what happened to that server.....
I have a hard time believing that people like this actually get paid to work in this industry.
BTW, Cannot is one word ;)
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=72.41.255.238;user id=flexida_creditscore;password=liontel"
cookieless="false"
timeout="20"
This is my connection string in web.config file..
When i click on next I get an error as: SQL Server NOT Found / Access Denied
link: http://www.creditscore4u.co.uk/web/customer_info.a...
Posted By Prinson on Jan. 20, 2007 at 7:28 AM
Oh sweet crap on a crutch!
I guess I stopped reading the comments because I was laughing too hard. I wouldn't have dreamed there was a moron # 2. Thanks for sending that......
DW
I do take my hat off to Doug when it comes to SQL server connectivity. Every year or so when I do a MS SQL project he gently fields a phone call from me helping me with the latest series of hoops and hurdles that MS throws in...