Subject:Can't Connect to DB - SQL 2005 Express Author:(Deleted User) 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)?
Subject:Can't Connect to DB - SQL 2005 Express Author:(Deleted User) Date:25 May 2007 10:26 PM
This was resolved with the use of a significantly different URL string, for Windows Authentication connection to Microsoft SQL Server 2005 Express -
//localhost\SQLEXPRESS;AuthenticationMethod=Type2
and for user-name - just a space (leaving the password blank).
I suspect that the
;AuthenticationMethod=Type2
can be used for SQL Server 2005 (other versions than Express) when Windows Authentication is used - rather than the Port 1433 that the URL defaults to.
I will be interested to know the correct connect string (URL) for Microsoft SQL Server 2005 CE (Compact Edition).
Subject:Can't Connect to DB - SQL 2005 Express Author:Ivan Pedruzzi Date:25 May 2007 11:22 PM
SQLServer Express Edition installs by default as named instance called SQLExpress.
Stylus Studio can access SQLServer Express using either Windows Security
//localhost\SQLEXPRESS;AuthenticationMethod=Type2
or the database built-in security
//localhost\SQLEXPRESS
SQLServer Compact Edition is a SQL engine library designed to be embedded in desktop applications therefore it cannot be accessed by Stylus Studio or any other SQL clients.