Account Problems

Joined
Apr 6, 2004
Messages
0
Reaction score
0
Ok I got the entire database shit fixed I found out that lol u dont create the database manually in MSSQL but instead go directly into cmd and do that shit so thats a tip for some n00bs but now I open TB1BillID shit and go to query and I try to make an account I pasted this into the text field (BillID,Password) VALUES('username','password') and I got this error. "Unable to parse query text." Anyone know what im doing wrong should their be any checks in the little TB1BillID box or can someone give me more specific instructions.
 
no, you can use Enterprise Manager, I personally never use query unless im making an account on Mu (because of all teh damned parts taht need created)



all you need are 2 areas, your username and pass, then right click and hit the 'Run' command
 
The query you'll want to use for adding an account is;

Code:
INSERT INTO tblBillID (BillID,Password) VALUES ('USERNAME','PASSWORD')

As long as you have the redmoon database selected from the drop down menu at the top of the program, and you don't highlight any of the text in the query, it should go through successfully.

Also, for attaching the DB, you can go into Enterprise Manager and right click on the databases object under your server, then point to All Tasks & click on Attach Database, browse to where your redmoon_Data.MDF file is at, select it hit ok and viola, your database is attached. Much simpler than the whole Start -> Run -> CMD -> CD C:\Path to your server files approach.

I think the reason m4rky wrote the instructions like that was probably to make sure that anyone who was going to try running a server, would at least have enough computer knowledge to understand how to use text based commands. Not that in this day in age, many people use the command prompt anymore.
 
Last edited:
Back