login
-
Hi all I install microsoft sql 2005 and it is in windows authentication mode; but now i want to set password on my database;I mean that when i want to have connection to my database i should enter password; What should i do? what differences is necessary to do this? I try some ways but i can't get answer!?
-
Hi all I install microsoft sql 2005 and it is in windows authentication mode; but now i want to set password on my database;I mean that when i want to have connection to my database i should enter password; What should i do? what differences is necessary to do this? I try some ways but i can't get answer!?
-
Hi all I install microsoft sql 2005 and it is in windows authentication mode; but now i want to set password on my database;I mean that when i want to have connection to my database i should enter password; What should i do? what differences is necessary to do this? I try some ways but i can't get answer!?
Have you gone to Security/Logins to Add/Change a User/Login? Here's a link that might help: http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sqlserver2005logins/2474/[^]
-
Thanks alot for your attention; I change server authentication form windows authentication mode to sql server and windows authentication mode;and after that i create new login and i set password and i enabled login . but these changes doesn't done and when i want to ok these changes , an error occured:(what should i do) TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Login ''. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name. (Microsoft SQL Server, Error: 1038) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1038&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------