RSS

Re: Connecting to a SQL server on another XP computer

Please support our VB.NET advertiser: Programming Forums

Connecting to a SQL server on another XP computer

•

Join Date: Feb 2005

Location: Braintree, UK

Posts: 1,166

Reputation: hollystyles will become famous soon enough

Rep Power: 7

Solved Threads: 59

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: Connecting to a SQL server on another XP computer

Apr 27th, 2007

is the XP machine with Sql server running windows firewall? or Norton or <fill in firewall here> ?

If so you need to allow TCP/IP connections on port 1433

Also althoiugh you're using Sql Login, Sql Server iuses mixed mode by default (windows and sql login) meaning windows authentication is required for a login somehow that's where I get a bit vague as I havn't dealt with peer to peer networks for too long.

==========================================
Yadda yadda yadda...
Web junky, fevered monkey

DaniWeb Home > Forums > Software Development > VB.NET > Connecting to a SQL...

Re: Connecting to a SQL server on another XP computer

Connecting to a SQL server on another XP computer

Re: Connecting to a SQL server on another XP computer