[RESOLVED] re-send SQL Server 2005
hello there!
i have a question regarding authentication in SQL2005
i am using MS SQL Server Management Studio Express
and also created a username same privelege as "sa"
why is it when logging in to the database there are "Windows Authentication" and "SQL Server Authentication" i need only the SQL Server Authentication because it requires password but in Windows Authentication it will automatically connect to the dataabase, my worry is that what if the user change the value of the database?
and when deploying sthe program since i have created a new username do i still to install MS SQL Server Management Studio Express? just to create the the new username on the client?(client means it will be the server in deployment not my PC)
unlike in MS access just set the password nobody will open the database.
tnx.-
Re: re-send SQL Server 2005
Quote:
why is it when logging in to the database there are "Windows Authentication" and "SQL Server Authentication" i need only the SQL Server Authentication because it requires password but in Windows Authentication it will automatically connect to the dataabase, my worry is that what if the user change the value of the database?
You can disable BUILTIN\Users group access to your database.
Quote:
and when deploying sthe program since i have created a new username do i still to install MS SQL Server Management Studio Express? just to create the the new username on the client?(client means it will be the server in deployment not my PC)
unlike in MS access just set the password nobody will open the database.
Yes, you have to install an SQL server instance and create the user account used in you application
Re: re-send SQL Server 2005
