Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

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?
0
kenabbott
Asked:
kenabbott
1 Solution
 
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
 
sm394Commented:
type in Server Dropdown
ServerName\SqlServerInstanceName
i.e
localhost\SQLEXPRESS
or
(local)\SQLEXPRESS

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now