Author |
Topic |
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-20 : 09:38:06
|
Here is everything I know. I work where we have a very large secure network. I can log onto a teammate's computer with my login credentials, open SQL Server 2012 Management Studio, enter #############.us into the filed for the database engine, select SQL Server Authentication, enter the login ID, enter the password, and log onto the database.I try this on my computer and it doesn't work. It errors out. I have searched the internet, along with some IT people, for solutions using the error messages, and to no avail.I know there is more to logging into a new SQL database if you haven't connected to it before, especially with the database engine name that I am using. Can you guys offer some suggestions as to what I need to know or do?Thank you. |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-20 : 11:04:42
|
quote: Originally posted by Learn2010 Here is everything I know. I work where we have a very large secure network. I can log onto a teammate's computer with my login credentials, open SQL Server 2012 Management Studio, enter #############.us into the filed for the database engine, select SQL Server Authentication, enter the login ID, enter the password, and log onto the database.I try this on my computer and it doesn't work. It errors out. I have searched the internet, along with some IT people, for solutions using the error messages, and to no avail.I know there is more to logging into a new SQL database if you haven't connected to it before, especially with the database engine name that I am using. Can you guys offer some suggestions as to what I need to know or do?Thank you.
That sounds like the firewall on the server side is set up to let only specific IP addresses to connect to it. That is not an uncommon set up; so you might want to ask the network support (on the server side). They should be able to watch the traffic coming into them and tell you whether you are knocking on their door and they are turning you away. |
|
|
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-20 : 11:15:41
|
I will try that. Thanks. |
|
|
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-21 : 10:28:40
|
It didn't work. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-21 : 10:34:03
|
quote: Originally posted by Learn2010 It didn't work.
What did the server side networking people tell you? Are they seeing your requests coming through at all? |
|
|
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-21 : 14:45:19
|
I was told to uninstall sql and try again. So, I posted another question but you may be able to answer it here. What should I download to be able to connect to a web based sql database? Should I use SQL Server 2012 Management Studio Express, SQL Server 2012 Express, Or ...? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-21 : 14:57:10
|
Not quite sure what you meant by "web-based database" Do you have an Azure database? If so can connect to it using SSMS http://www.windowsazure.com/en-us/develop/net/common-tasks/sql-azure-management/If it is a database that is at a remote location then, again, you can connect using SSMS.Are you able to connect to any servers within your domain from your computer?Assuming you have a good installation of SSMS, and if your colleague is able to connect, then that means your connection is getting blocked somewhere along the way, but his is not. It may be at your end, but if you are able to connect to the outside world, that may not be the case. The other possibility is that the remote location may have opened their ports to only specific IP addresses. If that is the case, then they will need to open them up for you as well. |
|
|
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-21 : 21:23:37
|
We have a SQL database that is hosted on the web by a .Net company. Another company developed it for us. I also used telnet to try and connect to it and another database and both failed. |
|
|
Learn2010
Starting Member
12 Posts |
Posted - 2013-06-25 : 06:59:44
|
I finally got a support person that was able to figure out that something was hijacking my connection. I searched through my programs and found one name Sendori. I read up on it and found that it was malware and that is what it does, hijacks your connections. I deleted it and the problem was solved.Thanks for all your help. |
|
|
|