[problem] SQL Server = Create atum user

[Ezoman]

Please help me. I got problem with SQL Server. If I make user atum(pw. callweb) in SQL server 2008 R2, it's not working if a try to log with this id/pw.


If I try to login with "Windows Authentication" there is no problem. What is the solve?

In ODBC, there is this same problem.


If i try use new user - test this gives the same result.

SCREENS:

You must be registered to see links

Please make tutorial how to create new user in SQL server - There is'nt any information about it.

 

[WARonline]

Please help me. I got problem with SQL Server. If I make user atum(pw. callweb) in SQL server 2008 R2, it's not working if a try to log with this id/pw.


If I try to login with "Windows Authentication" there is no problem. What is the solve?

In ODBC, there is this same problem.


If i try use new user - test this gives the same result.

SCREENS:

You must be registered to see links

Please make tutorial how to create new user in SQL server - There is'nt any information about it.

You didn't gave to "ATUM" the "sysadmin" in Security> Users. You need to edit the ATUM user and make it "sysadmin"

 

[mKeey]

You must be registered to see links

 

[Ezoman]

Security/Logins or atum2_db_1(atum2_db_account)/Security/users?

If security/logins I have sysadmin...

If security/users I don't see sysadmin...

Screens:

You must be registered to see links

@edit.

I give all rights to atum and test(new user) in Security/usrers db_1 and db_account. In secutiry/logins i give sysadmin to atum and test.

PS: In atum I don't can add db_1 db_account db_arena in user mapping. Atum alerdy exist... this is problem? What's solve?

but if it's problem, then why test(in this i can add all bases in user mapping) don't working(failed to login)?



EDIT:

I find this:
http://forum.ragezone.com/f614/guide-screwed-mssql-users-logins-717947/

but this isn't help me ;/

PS: i give new atum user sysadmin, rest unchanged relative tthis(up link) guide




EDIIIT:
OK. Server Working. The solution is "Mixed mode" in SQL Server installation...

,but NPCServer don't working. IOCPInit error ;/ 0,5s before start this. Log:

03-27 10:49:57|[Notify] elapsed time after turn on !!  0Day 16h:32m:12s 
03-27 10:49:57|NPC Server Start

03-27 10:49:57|CVMem::AllocVMem VirtualAlloc() success, TypeSize[   20] PoolCnt[ 7577] CommitSize[  151552] vectorSize[1] Address Range(0x7EF80000 ~ 0x7EFA5000)
03-27 10:49:57|CVMem::AllocVMem VirtualAlloc() success, TypeSize[   36] PoolCnt[34019] CommitSize[ 1224704] vectorSize[1] Address Range(0x7EE50000 ~ 0x7EF7B000)
03-27 10:49:57|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 1002] CommitSize[ 1511424] vectorSize[1] Address Range(0x7ECD0000 ~ 0x7EE41000)
03-27 10:49:57|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[  101] CommitSize[  155648] vectorSize[1] Address Range(0x7ECA0000 ~ 0x7ECC6000)
03-27 10:49:57|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[ 3401] CommitSize[ 5279744] vectorSize[1] Address Range(0x7E790000 ~ 0x7EC99000)
03-27 10:49:58|  [Notify] CNPCGlobal::InitServerSocket# Starting... 
03-27 10:49:58|[Notify] CNPCIOCP::IOCPInit# 60000! InfinityModeInfoListCnt(2) ArenaMapIndexListCnt(3) 
03-27 10:49:58|[Error] NPCServer IOCPInit Error
03-27 10:50:00|  [Notify] CNPCGlobal::EndServerSocket# 
03-27 10:50:00|CGlobalGameServer::EndServerSocket_1
03-27 10:50:00|CNPCIOCP::IOCPClean_1
03-27 10:50:00|########################	Server IOCPClean	########################

Any solution? I do this:

Fix NPCServer.

1.Run-> Pre, Im, Log, Field Servers.
2.Open MSSQL 2008 R2 and open atum2_db_account.
3.Open ti_Cinema and delete all lines from that table but don't delete table!!!
4.Close Field Server.
5.Run FieldServer And NPCServer.
6.Then that work's !!!

but it isn't help me.



ALL PROBLEMS SOLVED.

 

[WARonline]

SQL Server Configuration Manager. Try to add there your Local IP, restart MSSQLSERVER, and when you log in SQL Server, log in to Server: LOCAL IP, ID: ATUM and PW: YOUR PASSWORD.
I think ODBC is fucked up at your configuration also

 

[Ezoman]

Problem solved.

Solution: Mixed mode in SQL Serv installation.

Solution for NPCServer: Windows 7 firewall off <facepalm>

 

[WARonline]

Lol. Don't close your firewall... just make permissions for all of your Bins in Windows Firewall and that's it.