SQL Express remote access - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

SQL Express remote access

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources