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 |
|
dani2
Starting Member
32 Posts |
 Posted - 2006-10-30 : 01:51:20
|
| Can a database on SQL Express 2005 server be accessed remotely in a network? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-30 : 01:58:05
|
Yes. Just make sure port 1433 is opened in the firewall on the server machine.
Peter Larsson
Helsingborg, Sweden |
 |
|
|
dani2
Starting Member
32 Posts |
Posted - 2006-10-30 : 02:49:06
|
quote:
Originally posted by Peso
Yes. Just make sure port 1433 is opened in the firewall on the server machine.
Peter Larsson
Helsingborg, Sweden
default it is set to 1643 on TCP Dynamic ports |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-30 : 02:50:27
|
If that's the case, you must specify port 1643 in the connection string for every client.
Peter Larsson
Helsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-30 : 02:52:23
|
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer
Peter Larsson
Helsingborg, Sweden |
|
|
|
|
|
|
SQL Express remote access