Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Struggling to connect to a SQL Server 2008 R2 Express named instance

Hi there,
I'm trying to create my first DB connection via the wizard, but I can't seem to connect.
SQL Server is running locally on my laptop; Open Profiler is also installed on my laptop.
My computer name is 'Carl-THINK'
The instance name is 'SQLExpress'
SQL Server is running in mixed authentication mode and the 'sa' account is enabled.
I'm not sure how to determine what port number the instance is running on?
I'm trying to connect to the 'AdventureWorks2008R2' database.
Please help... thanks,
Carl

Labels (2)
10 Replies
Pooja_kataria
Contributor III
Contributor III

This helped me thanks !