Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Johnnybee
Starting Member
5 Posts |
 Posted - 2006-05-18 : 22:49:11
|
| Hi Guys. I wanted to know if there is anyway i can access my user name and password, i have locked myself out. I had the database built awhile ago and everything ran fine, However the site was down for a few months and when i loaded it all back up, the back end will not let me in. also no one can register to my site. this message appears....Cannot insert the value NULL into column 'dteCreated', table 'pokerleague.dbo.Registration'; column does not allow nulls. INSERT fails. The statement has been terminated.Any ideas, I know nothing about this stuff.Thank you in advance.John |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-18 : 22:59:57
|
Is this a SQL Server database? If so, try logging in as administrator on the box and changing the password of the account you are using with sp_password. If it's hosted, call the hosting company. They will be able to reset your password.As for the NULL error....you need to rewrite your code to not insert NULL into Registration.dteCreated.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Johnnybee
Starting Member
5 Posts |
Posted - 2006-05-18 : 23:19:04
|
| I had a guy build me a database, then upload it to the SQL Server, i have the passwords for the server. Just not able to get into the database he made for me. and he is no longer living here so can't get him to look at it, i think it has something to do with the tables, but then again who am i kidding, i know nothing about this stuff. I have downloaded SQL server management studio express, loaded the SQL file he gave me to run the database, but its all double dutch to me. Guess i need to have someone do it all over.Thanks anywayJohn |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-18 : 23:28:20
|
| Uhhh.....Okay.Have you considered browsing www.asp.net for a beginning programming/sql server integration project? They have some good starter kits that will get you started. You probably don't need to do anything over. If you need a consultant to walk you through this, shoot me an email.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Johnnybee
Starting Member
5 Posts |
Posted - 2006-05-18 : 23:34:06
|
| Hey I really appreciate that, I will have a look and let you know how I get on. Thanks very much |
|
|
|
Johnnybee
Starting Member
5 Posts |
Posted - 2006-05-18 : 23:40:31
|
| I have to be honest with you, I just looked at that site and I have no idea what I’m looking for, sorry I really am a dummy at this stuff, but willing to try |
|
|
|
|
|
|
|
|
new here