I know this isnt directly related, but I'm close to the end of my wit here trying to fix this problem. Next thing to do is actually CALL microsoft pay for support.
If anyone would like to take a stab at answering it, please do so.. I'll greatly appreciate it.
I installed SQL 7 successfully on my computer. I'm having an error with SQL 7 when trying to enter "NEW SQL SERVER REGISTRATION". I will go through the process of entering in the needed information into the wizard, but when I get to the last screen and press the "FINISH" button I get the following error:
----------------------
Assertion Failed!
Program C;\WINDOWS\MMC.EXE
File:../src/sqlsspi.c
Line 120
Expression Count
Then it tells me to check out the documentation for Visual C++ for info on asserts.
----------------------
IF I CLICK "IGNORE" I get:
"Memory Allocation Failure|Cannot generate SSPI context"
IF I CLICK "RETRY" I get:
"Code execution exception:EXCEPTION BREAKPOINT"
It also asks me to check my SQL server registration properties - But I'm pretty positive I have everything correct because I was able to login to my SQL web host account with another computer at work. But can there be something easy I'm overlooking?
I have looked on the Microsoft site and found the following:
http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP
http://support.microsoft.com/support/kb/articles/q229/6/08.asp
http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP
I have tried to do what they say, but have had no luck. I have TCP/IP set in the "client network utility", and "Client for Microsoft Networks" selected as my primary login in my control panel (even tried it without it being my primary login). Can I be missing an essential setup/config here? (FYI: I do have a network card for my cable modem installed)
I am using an Intel machine with the first edition of windows 98.
I have tried the two different install types, "STANDARD" and "DESKTOP" (not exactly sure what the difference is, but I haven't had the chance to get too deep into it because of this current problem... I'm new to SQL Server/Database)
I was told perhaps my Microsoft Management Console may be corrupt and to either reinstall SQL or download the MMC from Microsoft's Website. I did find a place online with a link to the MMC and I downloaded it, and installed it. It was version 1.2. However I am still having the same problem. "Assertion Failed!" - I also tried to reinstall SQL but the error continues.
When I UNINSTALL and try again, I want to make sure I get it all out of there, in the registry I have removed or looked to remove all of the below:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 7.0
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?
I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.
Any help is appreciated!
George
gplemos@email.com
If anyone would like to take a stab at answering it, please do so.. I'll greatly appreciate it.
I installed SQL 7 successfully on my computer. I'm having an error with SQL 7 when trying to enter "NEW SQL SERVER REGISTRATION". I will go through the process of entering in the needed information into the wizard, but when I get to the last screen and press the "FINISH" button I get the following error:
----------------------
Assertion Failed!
Program C;\WINDOWS\MMC.EXE
File:../src/sqlsspi.c
Line 120
Expression Count
Then it tells me to check out the documentation for Visual C++ for info on asserts.
----------------------
IF I CLICK "IGNORE" I get:
"Memory Allocation Failure|Cannot generate SSPI context"
IF I CLICK "RETRY" I get:
"Code execution exception:EXCEPTION BREAKPOINT"
It also asks me to check my SQL server registration properties - But I'm pretty positive I have everything correct because I was able to login to my SQL web host account with another computer at work. But can there be something easy I'm overlooking?
I have looked on the Microsoft site and found the following:
http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP
http://support.microsoft.com/support/kb/articles/q229/6/08.asp
http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP
I have tried to do what they say, but have had no luck. I have TCP/IP set in the "client network utility", and "Client for Microsoft Networks" selected as my primary login in my control panel (even tried it without it being my primary login). Can I be missing an essential setup/config here? (FYI: I do have a network card for my cable modem installed)
I am using an Intel machine with the first edition of windows 98.
I have tried the two different install types, "STANDARD" and "DESKTOP" (not exactly sure what the difference is, but I haven't had the chance to get too deep into it because of this current problem... I'm new to SQL Server/Database)
I was told perhaps my Microsoft Management Console may be corrupt and to either reinstall SQL or download the MMC from Microsoft's Website. I did find a place online with a link to the MMC and I downloaded it, and installed it. It was version 1.2. However I am still having the same problem. "Assertion Failed!" - I also tried to reinstall SQL but the error continues.
When I UNINSTALL and try again, I want to make sure I get it all out of there, in the registry I have removed or looked to remove all of the below:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 7.0
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?
I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.
Any help is appreciated!
George
gplemos@email.com
