user48642 Asked: 2010-07-19 06:12:01 +0800 CST2010-07-19 06:12:01 +0800 CST 2010-07-19 06:12:01 +0800 CST how to configure slq server 2008 to allow remote authentication! 772 by using microsoft sql server management studio sql-server-2008 remote-access 2 Answers Voted mrdenny 2010-07-19T15:50:19+08:002010-07-19T15:50:19+08:00 To enable remote access on an instance, you use the sp_configure system stored procedure. exec sp_configure 'remote access', 1 reconfigure This can be done against any instance from SQL Express to Data Center Edition. Best Answer user48642 2010-07-28T02:25:24+08:002010-07-28T02:25:24+08:00 using design view, using sql server mngmt stdio 08, just right click on the server name, goto security or connections and put a dot on allow mix mode...
To enable remote access on an instance, you use the sp_configure system stored procedure.
This can be done against any instance from SQL Express to Data Center Edition.
using design view, using sql server mngmt stdio 08,
just right click on the server name,
goto security or connections and put a dot on allow mix mode...