Subject:Can't Connect to DB - SQL 2005 Express Author:Ian Thomas Date:24 May 2007 01:10 PM
Stylus Studio 2007 Ent R2
I'm having a problem. My MS SQL Server 2005 Express is set up for Windows Authentication, and the instance name is the usual (XP120\SQLEXPRESS - where the machine name is XP120).
I normally logon the management studio with a username like XP120\logon_name.
(I see some threads here about using \\ - I'm not sure of that, either)
When I try to set up a new server (right-click on Relational DB), what I see is a choice of 5 database types, including Microsoft SQL Server.
I don't see SQL Native Client - which is required for SQL Server 2005, I believe.
I may be a bit dense here, but does this mean that I cannot connect to a SQL Server 2005 database (either Express or its big brothers)?