IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> How do I connect to my MSSQL server thru visual studio 2005
captain_wizz
post Sep 27 2007, 04:12 AM
Post #1


Junior Member


Group: Members
Posts: 3
Joined: 1-December 06
Member No.: 3192



I have setup a remote mssql server at my house and I can access it just fine. But when I try to connect to my hostony mssql server, I get an error that states that the server does not allow remote connections. What couls be the problem. It sounds like to me that the server roles are not set properly. Anybody with any ideals ? Thanks
Go to the top of the page
 
+Quote Post
MartinB
post Sep 27 2007, 06:32 PM
Post #2


Super Member


Group: Members
Posts: 1804
Joined: 10-March 04
From: Cordoba, Argentina
Member No.: 554



QUOTE(captain_wizz @ Sep 27 2007, 01:12 AM) *
I have setup a remote mssql server at my house and I can access it just fine. But when I try to connect to my hostony mssql server, I get an error that states that the server does not allow remote connections. What couls be the problem. It sounds like to me that the server roles are not set properly. Anybody with any ideals ? Thanks



They do not allow remote connections to the databases due to security issues, they only allow local connections or connectios between his servers.
If you want them allowing you remote access to a database, you must provide them with the 'dedicated ip' of your connection point (provided by your ISP) and the full details of the database name, user, password, etc.

(Please, Correct me if I'm wrong, these requeriments are for linux servers but surely they apply for windows servers too.)

greetings!


--------------------
Go to the top of the page
 
+Quote Post
captain_wizz
post Sep 29 2007, 01:45 AM
Post #3


Junior Member


Group: Members
Posts: 3
Joined: 1-December 06
Member No.: 3192



Ok I have tried vb connection string config as localhost.

This is the string format I used:

connectionString="Data Source=localhost;
Initial Catalog=Database_Name(provided by Hostony);
Persist Security Info=True;
User ID=User_Name(provided by Hostony);
Password=Password(provided by Hostony)"

The Error I get back is :

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)


should I use windows Authentication?

Any suggestions.
Go to the top of the page
 
+Quote Post
Lehrer
post Oct 5 2007, 08:38 AM
Post #4


Hostony staff


Group: Members
Posts: 1093
Joined: 7-October 04
Member No.: 1105



captain_wizz,

you have mixed up Mysql and MSsql, which is a Microsoft product. You should be using server's IP address, if you have the MSsql db setup the IP will be as follows:

208.116.16.5

Please let me know if you need any further assistance.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



Lo-Fi Version Time is now: 18th January 2018 - 05:45 PM