Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

SqlConnection is not responding to password

morde

There is a database on Sql Server 2012. The database contains a user of TestUser designed to:

CREATE LOGIN TestUser
    WITH PASSWORD = '123';
USE Банк;
GO
CREATE USER TestUser FOR LOGIN TestUser;
GO

I'm going to the base through the C# application using SqlConnection.

String ConnectionString = "Data Source=Computer;Initial Catalog=Банк;Persist Security Info=False;Integrated Security=SSPI;User ID=TestUser;Password=123;";
SqlConnection con = new SqlConnection();
con.ConnectionString = ConnectionString;
con.Open();

The problem is, even if the password is incorrect, the connection will still be established and requests can be sent. Show me how to fix it.

C
Cleofas last edited by

Try removing Integrated Security=SSPI. I think it's logical through a system logic and sooso ignores the laser and password. So you don't come in like TestUser.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

K

SSH password transmission
Software Programming • linux qt ssh administration • • Kadir

2

0
Votes

2
Posts

0
Views

Y

On the server, any editor, vim /etc/ssh/sshd_config RSAAuthentication yes PasswordAuthentication no /указать NO HostKey /root/.ssh/rsa_key.pub /указать путь к ключу
B

Password generation is not working.
Software Programming • javascript php jquery ajax • • Burma

2

0
Votes

2
Posts

0
Views

Z

return json from the violin:$ans= [ 'pass' => $pass, ]; return json_encode($ans) and get json on the client:$('#genpass').click(function(){ $.ajax({ url: "/functions/genpass.php", cache: false, dataType: 'json', success: function(data.pass) { $('#reg_pass').val(data.pass); }, error: function() { alert('Error'); } }); });
Ask the file name WriteXML
Software Programming • c sharp xml • • jeanid

2

0
Votes

2
Posts

0
Views

S

Method WriteXMLin principle, nothing. The road is transmitted in the form of a line, and the lines can be condensed, including with variables:string myValue = "Hello, world"; Console.WriteLine("Текст из переменно myValue: " + myValue); Accordingly, the line will be in your case:string name = DateTime.Today.ToString(); sRDataSet.WriteXml("C:/sanbak/" + name + ".xml"); Don't forget to subform the date as you're interested. Because in cheese, that's when you write. DateTime.Today.ToString(); or DateTime.Now.ToString(); etc. - The date will be marked 6/18/2016 5:07:03 PM/AM♪ As it sees, it will have the slashes, as well as the two-tracks that are inadmissible in the name of the file. It'll make mistakes that This format is not supported♪So we have to force ourselves to the correct format.For example:string name = DateTime.Today.ToString("d-MM-yyyy"); For a day-month-old formatOr more complicated.string name = DateTime.Now.ToString("dd.MM.yyyy HH'h'mm'm'ss's'"); Something like that: 19.06.2016 10h23m38sWhat formats are - you can look straight at MSDN, for example https://msdn.microsoft.com/ru-ru/library/zdtaw1bw(v=vs.110).aspx https://msdn.microsoft.com/ru-ru/library/az4se3k1(v=vs.110).aspx Or http://www.csharp-examples.net/string-format-datetime/
D

How to check the current password and change the password itself
Software Programming • yii2 • • Duquan

2

0
Votes

2
Posts

0
Views

E

There's a teller in yii2 to compare the values. Add the model rule: public function rules() { return [ ... ['new_passwordRepeat', 'compare', 'compareAttribute' => 'new_password'], ]; } And if all the rules didn't make any mistakes, make a new password. if ($this->validatePassword($this->current_password)) { $this->setPassword($this->new_password); $this->save(); } But it's best to create a separate model. There's an example of the form: https://github.com/ElisDN/seokeys/blob/master/modules/user/forms/frontend/PasswordChangeForm.php
O

Get more than two lines to report: QUERY CASE, GROUP BY and MAX
Software Programming • sql server sql • • obi

2

0
Votes

2
Posts

0
Views

M

Although you're not being 100% clear, I understand what you want is to add the column transacciones and that this looting its record value that has the maximum date (MAX(fecha)).In this case, the most appropriate thing is to use the window function row_number():select CASE area WHEN 'GER' THEN 'Gerenecia' WHEN 'MRKTNG' THEN 'Marketing' WHEN 'RBMAY' THEN 'Riesg. Banca Mayorista' WHEN 'RBMIN' THEN 'Riesg. Banca Minorista' WHEN 'RMRC' THEN 'Riesg. Mercado' WHEN 'RRHH' THEN 'Recursos Humanos' ELSE 'Ventas' END AS AREA, fecha, transacciones from (select area, fecha, transacciones, rn = row_number() over ( partition by area order by fecha desc) from Hoja$) t where rn = 1
Y

What is password encoding in Drupal?
Software Programming • php md5 drupal • • yajahira

2

0
Votes

2
Posts

0
Views

T

Complete implementation is found in the file includes/password.inc of your installation: https://github.com/drupal/drupal/blob/7.x/includes/password.inc Basically uses SHA512, here an extract from that file:/** * Hash a password using a secure stretched hash. * * By using a salt and repeated hashing the password is "stretched". Its * security is increased because it becomes much more computationally costly * for an attacker to try to break the hash by brute-force computation of the * hashes of a large number of plain-text words or strings to find a match. * * @param $algo * The string name of a hashing algorithm usable by hash(), like 'sha256'. * @param $password * Plain-text password up to 512 bytes (128 to 512 UTF-8 characters) to hash. * @param $setting * An existing hash or the output of _password_generate_salt(). Must be * at least 12 characters (the settings and salt). * * @return * A string containing the hashed password (and salt) or FALSE on failure. * The return string will be truncated at DRUPAL_HASH_LENGTH characters max. */ function _password_crypt($algo, $password, $setting) { // Prevent DoS attacks by refusing to hash large passwords. if (strlen($password) > 512) { return FALSE; } // The first 12 characters of an existing hash are its setting string. $setting = substr($setting, 0, 12); if ($setting[0] != '$' || $setting[2] != '$') { return FALSE; } $count_log2 = _password_get_count_log2($setting); // Hashes may be imported from elsewhere, so we allow != DRUPAL_HASH_COUNT if ($count_log2 < DRUPAL_MIN_HASH_COUNT || $count_log2 > DRUPAL_MAX_HASH_COUNT) { return FALSE; } $salt = substr($setting, 4, 8); // Hashes must have an 8 character salt. if (strlen($salt) != 8) { return FALSE; } // Convert the base 2 logarithm into an integer. $count = 1 << $count_log2; // We rely on the hash() function being available in PHP 5.2+. $hash = hash($algo, $salt . $password, TRUE); do { $hash = hash($algo, $hash . $password, TRUE); } while (--$count); $len = strlen($hash); $output = $setting . _password_base64_encode($hash, $len); // _password_base64_encode() of a 16 byte MD5 will always be 22 characters. // _password_base64_encode() of a 64 byte sha512 will always be 86 characters. $expected = 12 + ceil((8 * $len) / 6); return (strlen($output) == $expected) ? substr($output, 0, DRUPAL_HASH_LENGTH) : FALSE; }
C

List C# WinForms
Software Programming • c sharp net • • courtlanda

2

0
Votes

2
Posts

0
Views

T

Try the following:var procList = new List<string>(); foreach (var winProc in System.Diagnostics.Process.GetProcesses()) { procList.Add(string.Format("Process: {0}, Name: {1}",winProc.Id, winProc.ProcessName)); }
K

Reorder records in table
SQL, Database Testing • sql server performance query performance update sorting • • Kadyn

2

0
Votes

2
Posts

0
Views

Table CREATE TABLE dbo.Records ( id integer NOT NULL CONSTRAINT [PK dbo.Records id] PRIMARY KEY CLUSTERED (id), [type] character(1) NOT NULL, [value] integer NOT NULL, [order] smallint NOT NULL, [user] integer NOT NULL, -- order is unique CONSTRAINT [UQ dbo.Records order] UNIQUE NONCLUSTERED ([order] DESC) ); Indexes -- type is unique per user, useful to include order CREATE UNIQUE INDEX [UQ dbo.Records user, type (order)] ON dbo.Records ([user], [type]) INCLUDE ([order]); -- useful index on user, order CREATE NONCLUSTERED INDEX [UQ dbo.Records user, order] ON dbo.Records ([user] ASC, [order] DESC); Sample data INSERT dbo.Records (id, [type], [value], [order], [user]) VALUES (1, 'A', 123, 1, 1), (2, 'B', 231, 2, 1), (3, 'B', 213, 3, 2), (4, 'A', 222, 4, 2), (5, 'A', 22, 5, 3), (6, 'B', 11, 6, 4), (7, 'C', 99, 7, 1); Solution The following is similar to other answers in outline (joining two sets of numbered rows), but it optimizes the join (avoiding nested loops), and avoids changing rows where the order is not changed by the application of the algorithm. Comments inline: WITH Existing AS ( -- Number existing rows in order, per user SELECT R.[user], R.[order], rn = ROW_NUMBER() OVER ( PARTITION BY R.[user] ORDER BY R.[order] DESC) FROM dbo.Records AS R ), New AS ( -- Number existing rows by type, per user SELECT R.[user], R.[order], rn = ROW_NUMBER() OVER ( PARTITION BY R.[user] ORDER BY R.[type] ASC) FROM dbo.Records AS R ), OptNew AS ( -- Help the optimizer see that New.rn is unique per user SELECT New.[user], [order] = MAX(New.[order]), -- Meaningless, but required New.rn FROM New GROUP BY New.[user], New.rn ) UPDATE E SET [order] = N.[order] FROM Existing AS E JOIN OptNew AS N ON N.[user] = E.[user] AND N.rn = E.rn WHERE -- Only update if changed N.[order] <> E.[order]; db<>fiddle Execution plan
N

C# - GET or POST request in UWP annexes
Software Programming • c sharp json visual studio uwp • • Nykeriab

2

0
Votes

2
Posts

0
Views

B

You can use the library. https://msdn.microsoft.com/ru-ru/library/system.net.http.httpclient(v=vs.118).aspx I used it to write a portable library, which, among other things, has to support UWP, so it's likely that it'll fit you.Also for the JSON-Responsive Parsing https://www.nuget.org/packages/newtonsoft.json/ Established easily by searching for NuGet packages or a team: Install-Package Newtonsoft.JsonYou can also see examples of writing in https://github.com/MrModest/ShikiApiLib/blob/master/ShikiApiLib/ApiQuery.cs ♪ In particular, in order to deal with requests, the following are connected:using System.Net.Http; using Newtonsoft.Json; using System.Net;
A

MySQL passwords
Software Programming • php password hash • • authera

2

0
Votes

2
Posts

0
Views

T

No, because the jashing is what's done, so the password can't be decoded by accessing the adminnel.
B

Makes a mistake in reading xml of the file.
Software Programming • c sharp • • baileigh

2

0
Votes

2
Posts

0
Views

P

Решил проблему так: StreamReader reader = File.OpenText(pathXmlFile); string streamContents; streamContents = reader.ReadToEnd(); var xDoc= XDocument.Parse(streamContents);
A

Regular Password Expression
Software Programming • javascript regex • • Anderson

2

0
Votes

2
Posts

0
Views

D

You can use the following regex /\d.\d|\d{2}./ she says she should marry a number followed by anything and then another number or (|) two numbers followed by anything.Examples:/\d.\d|\d{2}./.test('1bab22') //false, não tem nada depois dos dois números seguidos /\d.\d|\d{2}./.test('1b1') //true, casa o primeiro padrão (lado esquerdo) /\d.\d|\d{2}./.test('1baaa') //false /\d.\d|\d{2}./.test('11') //false /\d.\d|\d{2}./.test('111') //true, devido ao ponto casar qualquer coisa If it is necessary to return false to three consecutive numbers change the point by \D which means no digit./\d\D\d|\d{2}\D/.test('111') //false Can identify 2 or more numbers with '2aaaa1a'.match(/\d+/g), in this case the approach changes to validate to capture and then check if it hits with the expected.var temNumero = '2aaaa1a'.match(/\d+/g); if(temNumero.length >=2){ console.log('válido'); }else{ console.log('não atende o padrão'); }
N

How to group a repeat record, showing all different records that are associated with it?
Software Programming • sql • • nishika

2

0
Votes

2
Posts

0
Views

K

The relation of the tables, you should make it Personas Personas_Empresa EmpresasIn this way your query would remain as follows:SELECT P.nombre_persona, E.dni_empresa, E.nombre_empresa FROM Personas P INNER JOIN Personas_Empresas PE ON P.dni_persona = PE.dni_persona INNER JOIN Empresas E ON PE.dni_empresa = E.dni_empresa The result would be as follows:+----------------+-------------+----------------+ | nombre_persona | dni_empresa | nombre_empresa | +----------------+-------------+----------------+ | Juan | 12345 | cocaloca | +----------------+-------------+----------------+ | Juan | 54321 | pipse cola | +----------------+-------------+----------------+ Here you can see the http://rextester.com/JMF51109 .Note: SQL has many flavors and between one and the other can change the syntax, so it will be necessary to add the label you currently use. Some are SQL Server, MySQL Oracle, among others. The example displayed works for SQL Server, but I think it can work for you in other database engines.
C

Determine whether the symbol in the line is Latin
Software Programming • c sharp lines • • courtlanda

2

0
Votes

2
Posts

0
Views

R

using System; namespace Program { class Program { static void Main(string[] args) { string str = Console.ReadLine().ToLower(); string res = "Нет"; foreach(char ch in str) { if((int)ch>=97&&(int)ch<=122) { res = "Есть"; } } Console.Write(res); } } }
D

RegEx for password in js
Software Programming • javascript regex • • derk

2

0
Votes

2
Posts

0
Views

T

You don't put an example of entry into your post, it would be good for you to include it. I would use the function. testinstead of match. Function test It'll give you a boolean, the function match an arrangement.let arr = "Java es mejor que Javascript".match(/Java/gi); This will give me an arrangement, because the chain complies with the pattern to (Java).let nombreConJ = /^J|j/; let resultado = nombreConJ.test("Juan Jacobo Rosseau"); This will result in a true, as it fulfills the pattern that the string starts with a j letter in capital or lowercase. in your code I think using test would be better than using match.var strongRegex = /^(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[!@#\\$%\^&\*])(?=.{8,})/; /* Si test da false es que la entrada no cumple con el patrón definido */ if(!strongRegex.test(this.form.password)){ this.error.show = true; this.error.message = 'La contraseña no cumple los requisitos'; alert('La contraseña no cumple los requisitos') } An entrance like this gene$R4l09544 It's valid. An entrance like this 1233 It wouldn't be valid. I hope I helped.

SqlConnection is not responding to password

Suggested Topics

SSH password transmission Software Programming • linux qt ssh administration • • Kadir

Password generation is not working. Software Programming • javascript php jquery ajax • • Burma

Ask the file name WriteXML Software Programming • c sharp xml • • jeanid

How to check the current password and change the password itself Software Programming • yii2 • • Duquan

Get more than two lines to report: QUERY CASE, GROUP BY and MAX Software Programming • sql server sql • • obi

What is password encoding in Drupal? Software Programming • php md5 drupal • • yajahira

List C# WinForms Software Programming • c sharp net • • courtlanda

Reorder records in table SQL, Database Testing • sql server performance query performance update sorting • • Kadyn

C# - GET or POST request in UWP annexes Software Programming • c sharp json visual studio uwp • • Nykeriab

MySQL passwords Software Programming • php password hash • • authera

Makes a mistake in reading xml of the file. Software Programming • c sharp • • baileigh

Regular Password Expression Software Programming • javascript regex • • Anderson

How to group a repeat record, showing all different records that are associated with it? Software Programming • sql • • nishika

Determine whether the symbol in the line is Latin Software Programming • c sharp lines • • courtlanda

RegEx for password in js Software Programming • javascript regex • • derk

SSH password transmission
Software Programming • linux qt ssh administration • • Kadir

Password generation is not working.
Software Programming • javascript php jquery ajax • • Burma

Ask the file name WriteXML
Software Programming • c sharp xml • • jeanid

How to check the current password and change the password itself
Software Programming • yii2 • • Duquan

Get more than two lines to report: QUERY CASE, GROUP BY and MAX
Software Programming • sql server sql • • obi

What is password encoding in Drupal?
Software Programming • php md5 drupal • • yajahira

List C# WinForms
Software Programming • c sharp net • • courtlanda

Reorder records in table
SQL, Database Testing • sql server performance query performance update sorting • • Kadyn

C# - GET or POST request in UWP annexes
Software Programming • c sharp json visual studio uwp • • Nykeriab

MySQL passwords
Software Programming • php password hash • • authera

Makes a mistake in reading xml of the file.
Software Programming • c sharp • • baileigh

Regular Password Expression
Software Programming • javascript regex • • Anderson

How to group a repeat record, showing all different records that are associated with it?
Software Programming • sql • • nishika

Determine whether the symbol in the line is Latin
Software Programming • c sharp lines • • courtlanda

RegEx for password in js
Software Programming • javascript regex • • derk