Open SQL Configuration Manager:
IMAGE1
Enable the following protocols for the instance:
TCP/IP
Named Pipes
Shared Memory
Don't enable VIA protocol
Enable the following client protocols:
TCP/IP
Named Pipes
Shared Memory
Don't enable VIA protocol
The default port to connect to SQL is 1433, you can change it in TCP/IP Properties
IMAGE2
You should reset SQL service to apply changes
Open Surface Configuration:
IMAGE3
Select "Surface Area Configuration for Services and Connections" and then go to "Remote Connections"
IMAGE4
Select "Using both TCP/IP and Named Pipes"
Everything should be right now to allow Remote Connections to databases in SQL 2005
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment