- Aslamo Alikum
- As the picture bellow , there is a problem to access by defualt user "sa" I don't know why ?
- please, Could anyone tell me !!?
I have problem to access by "sa" user
السلام عليكم
المشكله هي في الكنشن سترنق Connection String لو تضع لنا نص Connection String الموجود في Web.config و ان شاء الله نجاوبك او ممكن تستخدم
<add name="DB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\YourDatabase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
أو اذا تريد باٍستخدام اسم المستخدم و كلمة المرور بحيث تغير كلمة السر و اسم المستخدم و اسم قاعدة البيانات
<add name="DB" connectionString="Data Source=localhost;Initial Catalog=YourDatabase;Connection Timeout=15;Packet Size=4096;Integrated Security=no;User Id=sa;Password=admin" providerName="System.Data.SqlClient"/>
اتمنى ان يساعدك هذا
Just a small comment, SQL authentication is very weak compared to Windows Authentication, and the direction is to disable it in the future (many new SQL Server features already don't support SQL Authentication)
Mohamed Meshref
Software Design Engineer
SQL Server Team
Microsoft Corporation, Redmond HQ
Phone: +1-(425)704-8684
Mobile: +1-(425)445-7386