i have installed MSSQL 2008 business edition.while installing i followed all right instrructions and gave mixed authentication mode.but when i am giving my log name and pwd it showing error "connection was succesfully installed with server but error occured
during login process error :233 and error 18452".if i try to enter using windows mode it is working and i executed DB files.here my problem starts i have installed VS2010 in front end,so now i want to run my project which have to run through databse.In my
application web config file in connection strings DB connected through sql autherntication mode (u.name,pwd).in my DB windows mode is working.can i run my project using windows authentication mode or it have any issues??how i have to connect using windows
mode Database to vs 2010?? this problem is presisting for days find me an solution ASAP
no i just have myu project in visual studio and database files seperatley in mssql 2008.when we connect front end and back end in web configfile if it sql authentication mode have to give user name ,pwd but if ti on windows mode what is the connection mode.i
noit using integrated mode provided by vs 2010.so how to connect the windows authentication mode
You may want to connect VS2010 with SQL server 2008. And you can add your database in the SQL Server. Then you can add connection to the Microsoft SQL Server with the username and password. You can refer to the below link for more details.
mohan111
Member
46 Points
132 Posts
i have installed mssql 2008 and i gave mixed mode ??but it is only working in windows authenticat...
May 27, 2012 04:43 AM|LINK
Hello all,
i have installed MSSQL 2008 business edition.while installing i followed all right instrructions and gave mixed authentication mode.but when i am giving my log name and pwd it showing error "connection was succesfully installed with server but error occured during login process error :233 and error 18452".if i try to enter using windows mode it is working and i executed DB files.here my problem starts i have installed VS2010 in front end,so now i want to run my project which have to run through databse.In my application web config file in connection strings DB connected through sql autherntication mode (u.name,pwd).in my DB windows mode is working.can i run my project using windows authentication mode or it have any issues??how i have to connect using windows mode Database to vs 2010?? this problem is presisting for days find me an solution ASAP
THANKS & REGARDS
vs
sreejukg
All-Star
28141 Points
4206 Posts
Re: i have installed mssql 2008 and i gave mixed mode ??but it is only working in windows authent...
May 27, 2012 05:33 AM|LINK
When you develop from Visual studio, you can use database in integrated mode.
e.g.
Data Source=<servername>;Initial Catalog=<databasename>;Integrated Security=SSPI;
For the login error, check this thread
http://social.msdn.microsoft.com/Forums/en-SG/sqldatabaseengine/thread/b9864938-3b9d-46ed-913c-1014d93738d5
My Blog
mohan111
Member
46 Points
132 Posts
Re: i have installed mssql 2008 and i gave mixed mode ??but it is only working in windows authent...
May 27, 2012 05:38 AM|LINK
no i just have myu project in visual studio and database files seperatley in mssql 2008.when we connect front end and back end in web configfile if it sql authentication mode have to give user name ,pwd but if ti on windows mode what is the connection mode.i noit using integrated mode provided by vs 2010.so how to connect the windows authentication mode
Qi Wu - MSFT
Contributor
5794 Points
677 Posts
Re: i have installed mssql 2008 and i gave mixed mode ??but it is only working in windows authent...
May 29, 2012 03:41 AM|LINK
Hi,
You may want to connect VS2010 with SQL server 2008. And you can add your database in the SQL Server. Then you can add connection to the Microsoft SQL Server with the username and password. You can refer to the below link for more details.
http://razibdeb.wordpress.com/2011/01/23/sql-server-2008-basics-connection-with-vs2010/
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework