October 5, 2012 at 9:21 am
Sean Lange (10/5/2012)
Since you mentioned this is a webserver, did you add an exception to this machine for the ports that sql is using (default 1433)? I am guessing that your new server is in the DMZ. Are you referring to the server via name or IP?
Yes, and getting the same messages on two other pcs. Actually one of those pcs have been connecting, but the user just told me that it's been disconnecting. So I thought that I would test it with a laptop that I haven't setup yet. It just so happens to give me the same here as the other pc and new server. I've been referring to the servers name\database
October 5, 2012 at 9:24 am
54.69.6d.20 (10/5/2012)
Sean Lange (10/5/2012)
Since you mentioned this is a webserver, did you add an exception to this machine for the ports that sql is using (default 1433)? I am guessing that your new server is in the DMZ. Are you referring to the server via name or IP?Yes, and getting the same messages on two other pcs. Actually one of those pcs have been connecting, but the user just told me that it's been disconnecting. So I thought that I would test it with a laptop that I haven't setup yet. It just so happens to give me the same here as the other pc and new server. I've been referring to the servers name\database
From the DMZ you may have to refer to it by IP.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2012 at 9:52 am
hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the server now. I'm going to check the permissions, but again that doesn't make sense either if I haven't changed anything
October 5, 2012 at 10:00 am
54.69.6d.20 (10/5/2012)
hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the server now. I'm going to check the permissions, but again that doesn't make sense either if I haven't changed anything
I would really recommend not using System DSN on a production web server. And most important DO NOT use sa from a website!!!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2012 at 10:11 am
Sean Lange (10/5/2012)
54.69.6d.20 (10/5/2012)
hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the server now. I'm going to check the permissions, but again that doesn't make sense either if I haven't changed anythingI would really recommend not using System DSN on a production web server. And most important DO NOT use sa from a website!!!!
Okay.. User DSN? All of my desktops are connected through the system DSN. Is that not correct?
As for sa user.. 🙂 I know that. i was just trying to connect to the server. I've created another user in SQL for the site. But in order to connect with that user from the webserver. I have to create a odbc connection. Which is still giving me that error..
October 5, 2012 at 10:23 am
54.69.6d.20 (10/5/2012)
Sean Lange (10/5/2012)
54.69.6d.20 (10/5/2012)
hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the server now. I'm going to check the permissions, but again that doesn't make sense either if I haven't changed anythingI would really recommend not using System DSN on a production web server. And most important DO NOT use sa from a website!!!!
Okay.. User DSN? All of my desktops are connected through the system DSN. Is that not correct?
As for sa user.. 🙂 I know that. i was just trying to connect to the server. I've created another user in SQL for the site. But in order to connect with that user from the webserver. I have to create a odbc connection. Which is still giving me that error..
I don't use DSN at all. Instead establish a connection in your application. That of course may not be possible at this point. This of course is somewhat offtopic.
It is pretty difficult to figure these things out remotely but I can do my best to help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 5, 2012 at 1:00 pm
Nothing against you, but I'd rather do some more research. However, I am open to other idea's! It doesn't make since when other pcs are connecting just fine.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply