Search this forum like:
Asp.net login for beginner etc
try it on Google as well
The best way would be to download some books on asp.net and cover the chapters that
deal in login management or simple database Insert, Update, Delete etc operations
i create a database his backend is sql and the frontend is access that uses sql login user like sa and i created login interface to users via access form ok now i have a smal part that use asp.net i need the users loging throw asp.net pages and do some thing
like inserting data.
i create a database his backend is sql and the frontend is access that uses sql login user like sa and i created login interface to users via access form ok now i have a smal part that use asp.net i need the users loging throw asp.net pages and do some thing
like inserting data.
Hi,
Do you means you want to create a database by using a asp.net user account and this account has full controls of created database? If so, please make sure the user account is added in your security logins in SQL Server instance, otherwise, it cannot login
successfully.
database2
Member
1 Points
14 Posts
Login with sql server user
Dec 27, 2012 09:55 AM|LINK
Hi,
I want to use sql server login user for example sa to login to asp.net pages
usman400
Contributor
3513 Points
721 Posts
Re: Login with sql server user
Dec 27, 2012 09:57 AM|LINK
it does not work like that
you must write the code to detect what is id and password, there you can handle (even via hardcode)
for login id: sa
database2
Member
1 Points
14 Posts
Re: Login with sql server user
Dec 27, 2012 09:58 AM|LINK
ok did you know any tutorial to do what i want?
farooque84
Participant
1358 Points
321 Posts
Re: Login with sql server user
Dec 27, 2012 10:09 AM|LINK
See the Below Links that will help you,
http://stackoverflow.com/questions/1134319/difference-between-a-user-and-a-login-in-sql-server
http://msdn.microsoft.com/en-us/library/aa337562.aspx
http://www.akadia.com/services/sqlsrv_logins_and_users.html
usman400
Contributor
3513 Points
721 Posts
Re: Login with sql server user
Dec 27, 2012 10:09 AM|LINK
Search this forum like:
Asp.net login for beginner etc
try it on Google as well
The best way would be to download some books on asp.net and cover the chapters that
deal in login management or simple database Insert, Update, Delete etc operations
database2
Member
1 Points
14 Posts
Re: Login with sql server user
Dec 27, 2012 11:01 AM|LINK
Dear Thanks a lot,
but let me explain to you what i need i want my asp.net users log with sql server login user
i need this interface in asp.net in the same database that i used
is this possible?
usman400
Contributor
3513 Points
721 Posts
Re: Login with sql server user
Dec 27, 2012 02:19 PM|LINK
u are targetting a web application i.e. a web page
So what do you want after that ?
You can mimic this interface by placing the controls appropriately
But it is not clear what you want to do after log in
SQL Server is a seaparate software application
starving for more detailis I
database2
Member
1 Points
14 Posts
Re: Login with sql server user
Dec 27, 2012 03:47 PM|LINK
i create a database his backend is sql and the frontend is access that uses sql login user like sa and i created login interface to users via access form ok now i have a smal part that use asp.net i need the users loging throw asp.net pages and do some thing like inserting data.
usman400
Contributor
3513 Points
721 Posts
Re: Login with sql server user
Dec 27, 2012 04:01 PM|LINK
Access forms is a windows application using which you can show typical windows controls like the screenshot you have used above
This is not the case with web application, a web application is not intended to run like a desktop application, it must
run inside a web browser.
I am sorry but I am unable to undersand ur requirement here, I am opting out
Chen Yu - MS...
All-Star
21569 Points
2493 Posts
Microsoft
Re: Login with sql server user
Dec 31, 2012 07:24 AM|LINK
Hi,
Do you means you want to create a database by using a asp.net user account and this account has full controls of created database? If so, please make sure the user account is added in your security logins in SQL Server instance, otherwise, it cannot login successfully.
Create login in T- SQL: http://msdn.microsoft.com/en-us/library/ms189751.aspx
You could follow below thread to dynamic change your connection string.
http://stackoverflow.com/questions/3537680/how-can-i-dynamically-change-the-connection-string
If I misunderstand your requirements, please describle your issue again, Thanks a lot.
Best Regards,
Feedback to us
Develop and promote your apps in Windows Store