Anyone that can help me maybe I can also help you somehow. My host just says use that ip and username and password to connect...doesn't work. I downloaded the trial version of sql server 2008 r2 and trying to connect to my dedicated server database. I installed the web edition of sql server, well they did. I created a database. I added named pipes and tcp to sql server manager studio. But it just won't connect. How the bleep do I get it to connect to my database so I can load my tables. I think the trial edition is full featured. I hate databases.
You're most likely dealing with firewall issues. Also, is the DB server and the computer that's trying to connect to it on the same network, internal or external? Can you ping the DB server from the connecting server? Named pipes is probably not what you want unless you are specifically setting it up that way. Connecting via IP is normally a lot easier to configure.
I'm at hom in virginia. The dedicated server is in chicago. The database is probably on the dedicated server. Since they said use the same ip as the control panel is. They didn't even say a port so I assume it uses the default sql server port. I shut down my firewall to see if it would connect. I have zone alarm. Still didn't connect.
You need to contact your host to get the correct details which are IP - the one needed to connect to SQL Server remotely Port - the port they are using to allow connections DB Login details - you have them. Just ask them to clarify the first 2 points, and ask if they have a firewall policy for that IP and Port that might stop external connections. You might also want to ask them if they have anything set-up on their SQL server that stops connections from SQL Server Management Studio or Visual Studio (that can be done). You DO NOT need to install MS SQL locally - unless you plan to use it at a later stage. Make sure you have the correct version of SQL Server Management Studio. It must be SSMS 2008 if you are connecting to a 2008 DB (it will work with earlier versions too), but older versions of this software (e.g. SSMS 2005) will not work with SQL Server 2008. You can also use Visual Studio to connect. The free version "Visual Web Developer 2010 Express" is your best bet and a nice development platform. When using SSMS 2008, you need the following information in the "Connect to Server" window... - Server Type: Database Engine - Server Name: The remote IP address of the database. - Authentication: SQL Server Authentication - Login: The Database Username for the database - Password: The Password for the Database Username It should connect immediately. If you definitely have no firewall on your end, and you still can't conect, then it's one of two things. 1. Your ISP might be blocking the connection on the standard SQL port (possible) 2. There is a config problem at the hosts end either with SQL server or their firewall (more likely). It should be a simple process.
That is what I thought. It must be something on their end. I thought SQL Server Management Studio was part of sql server and you couldn't get it any other way. I will check out Visual Web Developer 2010 Express. Maybe that will work with it. They initially didn't even install the database which makes me think they didn't configure it right. Thanks!
Ron was right. you need detail information and make sure you could connect the internet and the database server was running
Not trying to be a smart ass - but how did you connect initially to create the remote database in the first place? Reckon if it allowed you create it initially then firewall and port configurations are not going to be the issue. Have you created the database locally in the trial version software you downloaded?