up vote 0 down vote favorite
share [g+] share [fb]

by using microsoft sql server management studio

link|improve this question
50% accept rate
not statements by visual... like we used to do for sql 2005 express – user48642 Jul 18 '10 at 14:12
Could you be more specific? You want to enable Remote Connection for an SQL Server? If it's Express Edition, this is not possible, only connections from the local host will be accepted. – Chris S♦ Jul 18 '10 at 14:36
its evalution version. – user48642 Jul 18 '10 at 17:48
cannot find the option which use enable mix mode authentication – user48642 Jul 18 '10 at 17:48
feedback

2 Answers

up vote 2 down vote

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.

link|improve this answer
feedback
up vote 0 down vote accepted

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...

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.