Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2008 Express Connection Error on client PC

Status
Not open for further replies.

v5652

Programmer
Mar 19, 2008
76
IN
hello friends,

I am new to SQL Server.

I have two PCs with Windows XP with sp3 installed.Both are connected with LAN.
On 1 PC i have installed SQL Server 2008 express edition.
also i have created a DSN on the same pc.
but when i am going to Create a DSN on other pc, it gives the connection error.
I have also added SQLServer.exe in Firewall exceptions. and also added TCP/IP port no 1433 in sql server configuration Manager.
is there i am doing some mistake or i have to do any other settings to do this.

if anybody has the solution, please reply.

thanks.

 
You have to enable TCP/IP protocol.

Click Start->Run->Microsoft SQL Server 2008-> Configuration Tools -> SQL Server Configuration Manager

Expand the stuff on the left until you see "Protocols For SQLExpress". On the right side of the screen, make sure TCP/IP is enabled.

Right click on TCP/IP and click properties. Enabled should be YES. Then click on "IP Addresses" tab, scroll to the bottom. You should see IPALL and the port number it is using. This is the port that you need to make an exception in the firewall for.




-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Thanks George for your reply.

I have already enabled TCP/IP.
Is it because of that i am using Windows Authentication?
should i have to use SQL Authentication?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top