Need Help :)

[LPOssy]

Hello,
I need your help.
I have created a local server and I can somehow not create an account ...
I have tested two KOAM, one gets no connection to ssql and the other connect and show that account is created but i try login there this would not exist.
Please help me

 

[PerfektFA2]

if your doing it on windows 10 or similar try running it as admin it worked for me

 

[LPOssy]

Tryed it but it didn’t work :/

 

[Chelios1985]

Tryed it but it didn’t work :/

check odbc.

 

[RevEngKal]

.....

 

[LPOssy]

Thanks for ur reply
I dont understand this



So Server is already Running i only need Account



So what i can check? Server is running

 

[R3volutioN]

SET IDENTITY_INSERT [Login] On INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000')

SQL Server Management Studio -> kal_auth -> tables -> right click to Login -> script table as -> insert to -> new query editor window then copy paste and execute

 

[LPOssy]

So what must i do with this Code.. im newbie sorry ������
Idk where I must put in this code or whatever

SET IDENTITY_INSERT [Login] On INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000')

SQL Server Management Studio -> kal_auth -> tables -> right click to Login -> script table as -> insert to -> new query editor window then copy paste and execute

Done It
USE [kal_auth]
GO

INSERT INTO [dbo].[Login]
([ID]
,[PWD]
,[Birth]
,[Type]
,[ExpTime]
,[Info]
,[PWD2ND]
,[hello])
VALUES
(<ID, varchar(16),>
,<PWD, varbinary(16),>
,<Birth, smalldatetime,>
,<Type, tinyint,>
,<ExpTime, int,>
,<Info, int,>
,<PWD2ND, int,>
,<hello, int,>)
GO
SET IDENTITY_INSERT [Login] On INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000')
The Failure
Message 102, Level 15, Status 1, Line 14
Incorrect syntax near '<'.
Message 195, Level 15, Status 7, Line 25
'IDENTIT' is not recognized as a SET option.



Idk why there is <hello, int,>) lol, changed hello to login, but didnt work too -.-"

 

[strik3r2k5]

Select kal_auth and just execute INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000')
aaaand don't mess with values you know nothing about.

in german...
(Wähle kal_auth aus, und führe einfach den oberen Befehl aus... INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000').
Spiel nicht mit Variablen wovon du absolut keine Ahnung hast.
Das sind eigentlich nur Felder, wo irgendwas eingefügt werden soll. Vielleicht war es einfach ein Test-Feld, vielleicht auch nicht.. Du musst die Änderung rückgängig machen, falls du den Namen oder Typen geändert hast.
Sollte es nicht klappen mit dem INSERT, google nach deutschen mssql tutorials...
Ich kann dir hier nicht wirklich helfen, weil ich nie die Files von den anderen benutzt habe..)

 

[LPOssy]

Select kal_auth and just execute INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000')
aaaand don't mess with values you know nothing about.

in german...
(Wähle kal_auth aus, und führe einfach den oberen Befehl aus... INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', '1', 0x2C, '19000101', '0', '4000').
Spiel nicht mit Variablen wovon du absolut keine Ahnung hast.
Das sind eigentlich nur Felder, wo irgendwas eingefügt werden soll. Vielleicht war es einfach ein Test-Feld, vielleicht auch nicht.. Du musst die Änderung rückgängig machen, falls du den Namen oder Typen geändert hast.
Sollte es nicht klappen mit dem INSERT, google nach deutschen mssql tutorials...
Ich kann dir hier nicht wirklich helfen, weil ich nie die Files von den anderen benutzt habe..)

If i press Right Click on dbo.login i go to Insert In -> As New > Then It Open a Window with this Code
USE [kal_auth]
GO

INSERT INTO [dbo].[Login]
([ID]
,[PWD]
,[Birth]
,[Type]
,[ExpTime]
,[Info]
,[PWD2ND]
,[Login])
VALUES
(<ID, varchar(16),>
,<PWD, varbinary(16),>
,<Birth, smalldatetime,>
,<Type, tinyint,>
,<ExpTime, int,>
,<Info, int,>
,<PWD2ND, int,>
,<Login, int,>)
GO

 

[strik3r2k5]

Ah okay, then just edit the Values.
[...]
VALUES
(<ID, varchar(16),>
,<PWD, varbinary(16),>
,<Birth, smalldatetime,> [...]
to
VALUES
('1', <--- is your ID
,0x2C, <--- is your PWD which is '0'
,'19000101'[...] <--- is your birthdate
without the <-------
you must fill the other values. pwnd2nd is 000000 or 00000000(idk if it's 6 or 8 numbers for second pw) I dont know what your Login column is. I think it was the "hello" which was maybe the uid?/

Maybe tell us which files and os you're using and what you already tried. Like enable DEP etc.

 

[LPOssy]

/close thanks for help