SQL Server 2008 Express Connection Error on client PC

[v5652]

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.

 

[gmmastros]

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

 

[v5652]

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?