Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hardblink
Starting Member
3 Posts |
 Posted - 2007-03-29 : 11:51:00
|
| Hi everyone I'm very new in sql server and I'm trying to connect a database "mydatabase" that is in a server xx.xxx.xxx.xx with my application that is in another server ddd.ddd.ddd.dd, the servers are not in the same network one is in Brazil and the other in DC, I'm using sql server 2005 and VC# .net 2005 but, I'm can't create the correct connection string :(, using a table the username and password that I have, somebody help me, with resources or an example.Thanx.:G |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-29 : 11:52:39
|
http://www.connectionstrings.com
www.elsasoft.org |
 |
|
|
hardblink
Starting Member
3 Posts |
Posted - 2007-04-09 : 11:59:55
|
| Thanks for the answer but, I have a little problem in the middle, A firewall is a watch guard fire box x in one of the servers so the connection through the firewall is not so easy, any suggestions or comments? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-09 : 12:35:07
|
| you have to open the port you want in the middle firewall._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
hardblink
Starting Member
3 Posts |
Posted - 2007-04-09 : 12:45:32
|
| Am I right that the tcp port is 1433? or there are more ports? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-09 : 12:47:30
|
| yes the default one is 1433. but since it is the default port i'd suggest you change it._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
.net Connection String