wolfnibblesJunior Member |
Last Activity: 08/13/2011 18:35
- User Lists
Visitor Messages
Showing Visitor Messages 1 to 3 of 3
-
11/03/2009 04:09 - permalinkwolfnibblesSorry, was thanking you wonted to make an account.
/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';
--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123
This is what is in the config.sql file, put it in the New Query and then Execute, it well load. -
11/03/2009 04:04 - permalinkwolfnibblesIf you used the SHAIYA_SERVER_LITE_v0-12 files to make your server, then you can use login name is admin and password is admin123. If you didn't us it, then you well need to make an account, go ahead and download that file and in the batch dir, there is a config.sql file, you take the last part this:
/* Add to Game User: admin, Password: admin123 */
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END
and in your ms sql, make New Query and put it in there. It should make you a admin account. If this doesn't work let me know and I well give you other ways to make an account. -
what should i put for the server name for SQL server when logging in?