Clan system error

Quote:

---

Originally Posted by bobsobol

Gahg! You won't like it. Re-install Windows, unless you can log in to SQL with another account, delete SA, and recreate it.

Theoretically, uninstalling SQL and re-installing it should work... but it's uninstall is buggy, and leaves behind the problem which causes this to happen... so, a restore point, system wide backup, or restore from the install monitor you run may do the trick... if you have any of those.

---

awww man that sucks,
i'll get my friend contact the host providers,
thanks bobsobol :*:

Thanks for the bad news... well, it's good to see you "don't shoot the messenger" :wink:

You're not the only one to get bit by this. Not the first and won't be the last.

You'll note that my Personal PT Setup, and Automated PT database install don't require you to do anything with the ODBC connection applet... this is because 9 times out of 10, when I try that way MS SQL locks me out of even my admin account. :(:

It seems to be that the ODBC connection applet connects several times in quick succession, which MS SQL thinks looks like an attack, and therefore locks the account out to secure the database. Nice, but you just locked out the root administrator. If you have an alternate admin account in SQL before you attempt, you can at least unlock SA before trying again... but I just circumvent the chance of the error by importing a registry like this:-

Code:

---

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"c8master"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\c8master]
"Driver"="C:\\WINNT\\system32\\SQLSRV32.dll"
"Description"="PT Server DB"
"Server"="[MYSQLSERVER]\\SQLEXPRESS"
"Database"="AccountDB"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

---

Replace [MYSQLSERVER] with your servers name... what ever it says in System Properties. And... obviously, change the "LastUser" if you have a different Admin user to "Administrator" on your system.

if you cant login your SQL,
you can add another SQL login name,

oh, i forgot you cant login at SQL,
well you can Reinstall your MS SQL,

also, be sure you are using MS SQL 2005,
sometimes DediServers, use SQL 2008,

Quote:

---

Originally Posted by xiangsho

if you cant login your SQL,
you can add another SQL login name,

oh, i forgot you cant login at SQL,
well you can Reinstall your MS SQL,

also, be sure you are using MS SQL 2005,
sometimes DediServers, use SQL 2008,

---

@bob: i'll try your installer bro,
@xiangho: i made another user but i forgot the id also i reinstalled the sql server since then,

also i'm using the sql server in mike's (sik)'s thread
thank you both for your constant help in this topic it's much appreciated.
Also to conclude i'm still waiting for my friend to logon msn to contact the host provider lols