logo
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error
How to configure SQL Server to remote connection
Options
Go to last post Go to first unread
Previous Topic Next Topic
gregfd  
#1 Posted : Tuesday, March 30, 2010 12:53:21 AM(UTC)
gregfd

Rank: Advanced Member

Reputation:

Groups: Member
Joined: 2/6/2009(UTC)
Posts: 55
Man
Location: Wroclaw
Hi Everybody,

How to configure SQL Server to make connection for ex. with Visual Studio 2010/2008?

I've got alert that my server can't be found or SQL Server don't allow to make connection.

I use sqlDataSource...

There is something on server...
Certico Websolutions - www.certico.pl
Back to top
WWW

Wanna join the discussion?! Login to your Sienn Forum forum account. New Registrations are disabled.
Back to top  
Joey  
#2 Posted : Wednesday, March 31, 2010 11:05:29 AM(UTC)
Joey

Rank: Administration

Reputation:

Groups: Moderators, Administration, Member
Joined: 7/16/2009(UTC)
Posts: 30
Man
Netherlands
Location: Groesbeek

Thanks: 1 times
Hi Greg, do you want to connect to a SQL Server on the same machine you are running Visual Studio on or an external machine?
Back to top
bart  
#3 Posted : Wednesday, March 31, 2010 11:42:06 AM(UTC)
bart

Rank: Administration

Reputation:

Groups: Administration
Joined: 10/8/2008(UTC)
Posts: 190
Man

Was thanked: 1 time(s) in 1 post(s)
I think you have to configure your firewall to allow the external IP,
And the connection goes the other way around,
You connect VS.NET to SQL.
Back to top
gregfd  
#4 Posted : Friday, April 2, 2010 1:03:56 AM(UTC)
gregfd

Rank: Advanced Member

Reputation:

Groups: Member
Joined: 2/6/2009(UTC)
Posts: 55
Man
Location: Wroclaw
Hi Bart,

It was helpful. I allow connections with SQL Manager in Windows Server firewall. I also have to open some ports to work on it.

Thx a lot.

Certico Websolutions - www.certico.pl
Back to top
WWW
gregfd  
#5 Posted : Friday, April 2, 2010 1:05:18 AM(UTC)
gregfd

Rank: Advanced Member

Reputation:

Groups: Member
Joined: 2/6/2009(UTC)
Posts: 55
Man
Location: Wroclaw
Joey it was on external machine. But I think firewall blocking it.
Certico Websolutions - www.certico.pl
Back to top
WWW
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.15 | YAF.NET © 2003-2022, Yet Another Forum.NET
This page was generated in 0.088 seconds.