Connecting to SQL Server Express

Hi

I have just installed SQL Server Express 2005 onto an XP pro machine.  I have created a database and tables etc via Studio Express.  

I am now trying to create a data source so I can connect from MS Access.  However when I click on the 'Which SQL Server do you want to connect to' dropdown, it is blank.  

What is likely to be causing this?
kenabbottAsked:
Who is Participating?
 
sm394Connect With a Mentor Commented:
type in Server Dropdown
ServerName\SqlServerInstanceName
i.e
localhost\SQLEXPRESS
or
(local)\SQLEXPRESS

0
 
jtdebeerCommented:
Ensure you have enabled TCP IP and disable firewall on required port.

Use SQL Server Configuration manager under Network Configuration and then Protocols, enable the TCP/IP protocol, set the port you want to use and ensure the firewall on the xp box is not blocking the port (Normally Port1444)

Tip: Enable the Firewall totally and retry the connection as a first step.
0
 
kenabbottAuthor Commented:
Thanks for this but no luck.  I've enabled TCP IP but still same problem
0
 
randy_knightCommented:
Could be the SQL Browser service.  But in general don't use the drop down.  Just type the name\instance in the box.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.