Setting password to my own SQL database.
-
Hi, I want to protect my database with ID & Password. How it will be done. :)
-
Hi, I want to protect my database with ID & Password. How it will be done. :)
Sometimes its difficult to answer questions like this in the Forums , because people don't give us enough information. We have to help them and think what they are trying to achieve. let me tell you what came into my mind when i saw your question. Because if you are having an SQL Database is Hosted into the SQl Server and that Server is Protected by a sa password or you can add more users or restrict other users from accessing your database from the permission of your Database. So you see , you did not give us enough information.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Sometimes its difficult to answer questions like this in the Forums , because people don't give us enough information. We have to help them and think what they are trying to achieve. let me tell you what came into my mind when i saw your question. Because if you are having an SQL Database is Hosted into the SQl Server and that Server is Protected by a sa password or you can add more users or restrict other users from accessing your database from the permission of your Database. So you see , you did not give us enough information.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
i dont want my client will access my database in server. now tel me is there any way to avoid this?
-
i dont want my client will access my database in server. now tel me is there any way to avoid this?
Its Simple, Dont give the Password to the Server, if they know it change it
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Hi, I want to protect my database with ID & Password. How it will be done. :)
Many Time I am Also Suffer From this Problem but at a long time i find a solution about this problem's. First you Have To Change Window Authentication mode to mix mode authentication. use Done this by Done From Inside SQL Server Object Explore\Properties\Security\Server Authentication Change to mix mode Authentication or by using Query run in Window Authentication mode 1)EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2 2)Alter login sa enable 3)Alter login sa with password ='[abc]' --any Password 4)EXEC sp_revokelogin 'BUILTIN\Administrators' 5)Restart you'r SQL Server Service and Batch File in C#.NEt is int iChar = 34; char aChar = (char)iChar; StreamWriter sStr = new StreamWriter(GetWorkingDir + "//SQLSEREVR.Bat"); sStr.WriteLine("@echo off "); sStr.WriteLine(@"CD\"); sStr.WriteLine(@"osql -E -S .\sqlexpress -Q "+aChar.ToString()+"Alter login sa enable"+aChar.ToString()+""); sStr.WriteLine(@"osql -E -S .\sqlexpress -Q " + aChar.ToString() + "Alter login sa with password ='[abc]'" + aChar.ToString() + ""); sStr.WriteLine("Net stop " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + ""); sStr.WriteLine("Net start " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + ""); sStr.WriteLine(@"osql -E -S .\sqlexpress -Q " + aChar.ToString() + @"EXEC sp_revokelogin 'BUILTIN\Administrators'" + aChar.ToString() + ""); sStr.WriteLine("Net stop " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + ""); sStr.WriteLine("Net start " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + ""); string sBatchFileName = GetWorkingDir + "//SQLSEREVR.Bat";
-
Hi, I want to protect my database with ID & Password. How it will be done. :)
Your DB? Is this DB on a server you do not own/admin? Have you asked the srvadmin?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
-
i dont want my client will access my database in server. now tel me is there any way to avoid this?
You're not the dbowner?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
-
Sometimes its difficult to answer questions like this in the Forums , because people don't give us enough information. We have to help them and think what they are trying to achieve. let me tell you what came into my mind when i saw your question. Because if you are having an SQL Database is Hosted into the SQl Server and that Server is Protected by a sa password or you can add more users or restrict other users from accessing your database from the permission of your Database. So you see , you did not give us enough information.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Hi, Sir, I m using SQL SERVER 2005 in Windows authentication mode. Anybody on my PC can access the server by using same authentication. That means they can access their own database but they also can access my own too & I don't want to have access to them. I want to secure my particular on ;) ly. I think it is more clesr now. Please help.
-
Hi, Sir, I m using SQL SERVER 2005 in Windows authentication mode. Anybody on my PC can access the server by using same authentication. That means they can access their own database but they also can access my own too & I don't want to have access to them. I want to secure my particular on ;) ly. I think it is more clesr now. Please help.
Now in that case , Change the Authentication and use SQL Authentication. This means you have to give up Windows Authentication and have a spacial credentials for your Database Remove your Windows username from the Permissions of the Database and Add a new username that can only be used by you, then in that case you and only you can access the DB. remember the Windows Authentication does not even ask you for a password as long as you have the correct username the user can enter and that is not advisable in a secure environment. Hope it helps
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/