SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 First Time Connecting To An Online Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Learn2010
Starting Member

11 Posts

Posted - 06/20/2013 :  09:38:06  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3326 Posts

Posted - 06/20/2013 :  11:04:42  Show Profile  Reply with Quote
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.
Go to Top of Page

Learn2010
Starting Member

11 Posts

Posted - 06/20/2013 :  11:15:41  Show Profile  Reply with Quote
I will try that. Thanks.
Go to Top of Page

Learn2010
Starting Member

11 Posts

Posted - 06/21/2013 :  10:28:40  Show Profile  Reply with Quote
It didn't work.
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3326 Posts

Posted - 06/21/2013 :  10:34:03  Show Profile  Reply with Quote
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?
Go to Top of Page

Learn2010
Starting Member

11 Posts

Posted - 06/21/2013 :  14:45:19  Show Profile  Reply with Quote
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 ...?
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3326 Posts

Posted - 06/21/2013 :  14:57:10  Show Profile  Reply with Quote
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.
Go to Top of Page

Learn2010
Starting Member

11 Posts

Posted - 06/21/2013 :  21:23:37  Show Profile  Reply with Quote
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.

Edited by - Learn2010 on 06/24/2013 07:16:06
Go to Top of Page

Learn2010
Starting Member

11 Posts

Posted - 06/25/2013 :  06:59:44  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000