Printable View
Yes you must open all the server files ,
You have this error because you havent open your odbc and you havent put the name-of-your-pc/sqlserver to rangame1 , ranlog , ranshop and ran user
You dont need mdf files , you just need to open the sql files with sql manager and execute the query .
can someone show me a link from where can i download MSSQL 2000 or 2005
for vista home premium?
i did put the rangame1 , ranlog , ranshop (also ranuser) .. how do i put name-of-your-pc/sqlserver on those?Quote:
Originally Posted by hatake kakashi
http://i185.photobucket.com/albums/x...rck_02/osd.jpg
you can find/search it here..Quote:
Originally Posted by aysid0016
Double clique in rangame1 for example (you need to do it with rashop ran user and ranlog too)
you'll see that
http://www.imagehost.ro/pict/03003937484468998dddd.jpg
Replace the line in blue by yours
ok ive managed to correct that part (thanks to you ^^)
i started the server with no errors, but there was these.. and it didnt start the server..
http://i185.photobucket.com/albums/x...k_02/start.jpg
i pressed ok and there was this errors
http://i185.photobucket.com/albums/x...ranstartss.jpg
it continued until SERVER:9..
OK, 2 things:Quote:
Originally Posted by Mark_Xtian
First, you have managed to have some success launching some of the servers. Since you're getting the 'period' error, I would suggest using a different glogicserver (or a new client altogether). Copy the data folder from your new client to your server folder.
Second, on the latter part of your screenshots, it did say 'Server Start OK' on all four of it. One question though, were you able to connect to your server? If yes, what errors did you receive? If no, what message appears when you attempt to connect to the server?
Dude, just so you know, you're almost done. Double check your CFG files, especially the [ran][ran] part. Also, check if your ODBC's are testing successfully.
Keep me posted.
well according to previews posts, it says the server is on...
and i can create an account thru mssql or rancp... how can i do that?
and how can i be a GM offline?
MS SQL, I'll teach you. Not the RAN CP one. It's kinda long winded.Quote:
Originally Posted by Mark_Xtian
Here you go.
How to create a GM Account
1. Open up SQL2k/2005 and connect using SQL Server Authentication
2. Log-in with your SQL Server Authentication details (usually sa, 1234)
3. Double-click Databases on the left.
4. Double-click RanUser -> Tables
5. Right-click dbo.UserInfo -> Open Table
6. Fill-up the fields with your user name and password and then enter 30 (some say 23 would work) for the UserType.
7. Save the DB. You may now log-in as a GM to your server or to your GMCharEdit.
GM Commands? Look it up under sir Smarkies' FAQ's.
(I am assuming you have already altered the other Tables as the guide has outlined - dbo.ServerGroup and dbo.ServerInfo)
Keep me posted.
ok.. what should i do with this files? (field0,sagent,sconfig,sesion,slogin) its spellings are wrong, is it ok? and what shoul i edit inside it.. i havent edited anything in it cause i first have to play offline, which marlo15 said..
ok now i replaced the data file to the server files i have..
this was when im trying to login on mssql using - sa and 1234
http://i185.photobucket.com/albums/x...ck_02/1123.jpg
now that i replaced the data folder, the period errors was gone and the server started fine.. only problem is ^ and when i opened gmcharedit.exe is says "User DB open failed".
Check these:Quote:
Originally Posted by Mark_Xtian
1. Go to your ODBC (Control Panel -> Admininistrative Tools -> ODBC)
2. Check if you have the 4 necessary connections. If you do, check if it has the correct input for "Server" (mine says PCNAME\SQLEXPRESS)
3. On the second window after the previous one, check if SQL Server Authentication is selected rather than Windows NT authentication.
4. Make sure that you have entered the SQL Server Authentication details as you have indicated during the installation of MS SQL2005 (remember? the sa password?)
5. Lastly, on the last window, it would allow you to test the connection. If it does say connection was tested successfully, then you're set to go.
Keep me posted.
this part is done.. and ive tested it succesfully
http://i185.photobucket.com/albums/x...rck_02/osd.jpgQuote:
Check these:
1. Go to your ODBC (Control Panel -> Admininistrative Tools -> ODBC)
2. Check if you have the 4 necessary connections. If you do, check if it has the correct input for "Server" (mine says PCNAME\SQLEXPRESS)
sorry but icant understand this partQuote:
Microsoft SQL Native Client Version 09.00.3042
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
what second window? is it when i clicked next? second tab?Quote:
3. On the second window after the previous one, check if SQL Server Authentication is selected rather than Windows NT authentication.
4. Make sure that you have entered the SQL Server Authentication details as you have indicated during the installation of MS SQL2005 (remember? the sa password?)
5. Lastly, on the last window, it would allow you to test the connection. If it does say connection was tested successfully, then you're set to go.
Yes, the second tab. Well, even though it does say connection was successfully tested, double check if SQL Server authentication is selected and the correct Login ID and Password is entered. See this image:Quote:
Originally Posted by Mark_Xtian
http://i25.tinypic.com/29ncig0.jpg
After that, try testing the connection again. Now once that's successful, you can now check if you can connect using GMCharEdit. I would suggest you delete the GMCharEdit.cfg file first so that you can start fresh.
Keep me posted.
on system DNS tab, i havent put systems data yet.. should i do it the same with rangame, ranlog, ranuser, ranshop on system DNS tab?
http://i185.photobucket.com/albums/x...k_02/11234.jpg
cant make one on system DNS with this login and password... sa, 1234
http://i185.photobucket.com/albums/x..._02/112345.jpg
is my username and password wrong? should i reinstall mssql? cause i cant remember it the time i installed...
reinstalling you sql might be a greater problem...
BTW what your specs??
Hey,
I downloaded 2000 SQL
and 2005 SQL
and Extracted Both on one folder
then when I open 2005 SQL Folder
then Open RanGame1_2k5
then connect then I execute then somethings tell me:
this one:
Msg 1801, Level 16, State 3, Line 2
Database 'RanGame1' already exists. Choose a different database name.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
even the RanLogin1_2k5
and the RanShop1_2k5....................
and I deleted the SQL 2000 Folder
I tried
then still don't work?
Can someone help?,
and what will I use as msSQL Manager?
MS SQL Maestro?
How will I go to
the ODBC Data Source Administrator?
................................................
can someone answer plz?
I'm a filipino
so you can talk to me tagalog.
thank you.
salamat s mga sasagot
It's not necessary to install 2 sql you only need one..Quote:
Originally Posted by SeraphiPod
in Tagalog: "di na kailangan mag install ng dalawang SQL ^ _^
detach the attached database and delete the files located here.
C:\Program Files\microsoftsql\sql.1. something\data
there u can find the stored data delete the content that is related to the Ran database not all. OK
in Tagalog: "
e datach mo ung nka attach na databsa tpos delete mo ung files na nka locate d2.
C:\Program Files\microsoftsql\sql.1. something\data
jan makikita mo ung mga nka stored na data delete mo lang ung mga content na related sa Ran Databse.. ^_^
teka
need pa b un??????????????????
tska
bat Failed to connect to DB daw sabi sa may Session, Agent at Field0
eh, sa login di nmn!,
nkagwa n ako ng db sa microsoft sql server.
tapos yung sa:
ganun rin nangyayari sakin, eROR!Quote:
Originally Posted by Mark_Xtian
ano b m3r0n?
!!!!!!!!!!!!!!!!!
tska yun sabi ko
yung sa isang folder
yung may query!
hindi installeR!
i2 more info pa
Hey,
Can you help me IaN?
at the ODBC
I added SQL native client
and on the first step here's what I did:
Question: What name do you want to use to refer to the data source?
Name: RanGame 1
Question: How do you want to describe the data source?
Description: [I've left this blank]
Question: Which SQL Server d you want to connect to?
Answer: [I can choose (local) and PHEYBLES[my pc name], My question: What will i choose?]
then
second step:
Note to Ian:
I've just putted on the sql server to connect on PHEYBLES[my pc name]
Question:
Note to Ian - It wants me to choose 1
*1st Circle[Checked]*With Intergrated Windows authentication
*2nd Circle[Unchecked]*With SQL Server authentication using Login ID and Password entered by user
Note To Ian-
I put check on the 1st Circle
Then a ERROR POPPED UP[OH NO! SHIT]
Code:Connection Failed!
SQL State
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes PRovidER: Could not open a connection to SQL SerVER!
Connection Failed!
Then Bla Blah
Then,
on the Microsoft SQL Server Management Studio Express[2005]
I already the RanGame1_DATA.mfs or .mds blablah it's .m[the 2 ones can't remember]
and the RanShop, RanUser and RanLog
and then
When I open SESSION, FIELD0, AGENT, LOGIN
It says
Session:
DB Connection Failed[Error]
Field0
and agent too.
but on login it isn't failed, it's peRFECT!
pls help me,
tq.
and one on the RanGAME1_[blahblah can' rem][2005 and 2000 SQL Folder, not installer]
it's a query file
I got one 2000v of it
and one 2005v of it.
When I extracted both of it.
I'd have just See when I open the one at the 2005
I see the error
I've tried 2000 SQL folder[the queries][NOT INSTALLER]too and deleted it, cause maybe it's the solutionCode:Msg 1801, Level 16, State 3, Line 2
Database 'RanGame1' already exists. Choose a different database name.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
then It wasn't
the solution but it's ok cause I use 2005!
Then I don't know the ANSWER!.........................
P4 2.0GHzQuote:
Originally Posted by daydeedare
512 RAM
65mb RAM (i can play ran online just fine with this)
well how can i solve that error? is it my login and password? cause whenever i put different login and password, the error pops out fast..
these errors keeps giving me bad lucks