i have a problem in login in to the MS SQL server 2008,
i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not the same as for when looing in to the windows operating system,
and when i start MS SQL server and then i change the mode to mixed mode and then i restart the server,
then when i try to login as SQL server authentication the user name is the name that i selected in the installation process of the authentication mode, and what is the password that i should use,
is it the one i specified in the installation process of the one used for loogin in to windows,
can please someone help me with this,
and also i have another question, i have a desktop application which is written in visual studio 2008 C#, and i copied that project to a shared folder in the network and when i try to connect tto the server do i have to give the username and the password of the windoes login which the MS SQL server is????
can some one help me in this to situation or please give me some guidelines