Cant Connect To SQL Server -- Error Pops Up!

<i><b>Originally posted by : G. Lemos (gplemos@email.com)</b></i><br /><br />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:<br /><br />----------------------<br />Assertion Failed! <br />Program C;WINDOWSMMC.EXE <br />File:../src/sqlsspi.c <br />Line 120 <br /><br />Expression Count <br /><br />Then it tells me to check out the documentation for Visual C++ for info on asserts.<br />----------------------<br /><br /><br />IF I CLICK "IGNORE" I get:<br />"Memory Allocation Failure|Cannot generate SSPI context"<br /><br />IF I CLICK "RETRY" I get:<br />"Code execution exception:EXCEPTION BREAKPOINT"<br /><br />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?<br /><br /><br />I have looked on the Microsoft site and found the following:<br />http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP<br />http://support.microsoft.com/support/kb/articles/q229/6/08.asp <br />http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP<br /><br />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)<br /><br />I am using an Intel machine with the first edition of windows 98.<br /><br />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)<br /><br /><br />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.<br /><br /><br />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:<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7.0<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesM SSQLServer<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesS QLServerAgent<br /><br />Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?<br />I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.<br /><br /><br /><br />Any help is appreciated!<br />George<br />gplemos@email.com<br /><br /><br />

<i><b>Originally posted by : Mark (Mark.Johns@issolutions.co.uk)</b></i><br />Hi,<br /><br />Are you running the development version of SQL Server or the full version ? The full version does not run correctly on Win 98, you see.<br /><br />Mark<br /><br /><br />------------<br />G. Lemos at 9/7/2000 9:45:19 PM<br /><br /><br />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:<br /><br />----------------------<br />Assertion Failed! <br />Program C;WINDOWSMMC.EXE <br />File:../src/sqlsspi.c <br />Line 120 <br /><br />Expression Count <br /><br />Then it tells me to check out the documentation for Visual C++ for info on asserts.<br />----------------------<br /><br /><br />IF I CLICK "IGNORE" I get:<br />"Memory Allocation Failure|Cannot generate SSPI context"<br /><br />IF I CLICK "RETRY" I get:<br />"Code execution exception:EXCEPTION BREAKPOINT"<br /><br />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?<br /><br /><br />I have looked on the Microsoft site and found the following:<br />http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP<br />http://support.microsoft.com/support/kb/articles/q229/6/08.asp <br />http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP<br /><br />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)<br /><br />I am using an Intel machine with the first edition of windows 98.<br /><br />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)<br /><br /><br />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.<br /><br /><br />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:<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7.0<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesM SSQLServer<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesS QLServerAgent<br /><br />Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?<br />I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.<br /><br /><br /><br />Any help is appreciated!<br />George<br />gplemos@email.com<br /><br /><br />

<i><b>Originally posted by : George (gplemos@email.com)</b></i><br />This is the FULL version.<br />george<br /><br /><br />------------<br />Mark at 9/8/2000 11:01:00 AM<br /><br />Hi,<br /><br />Are you running the development version of SQL Server or the full version ? The full version does not run correctly on Win 98, you see.<br /><br />Mark<br /><br /><br />------------<br />G. Lemos at 9/7/2000 9:45:19 PM<br /><br /><br />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:<br /><br />----------------------<br />Assertion Failed! <br />Program C;WINDOWSMMC.EXE <br />File:../src/sqlsspi.c <br />Line 120 <br /><br />Expression Count <br /><br />Then it tells me to check out the documentation for Visual C++ for info on asserts.<br />----------------------<br /><br /><br />IF I CLICK "IGNORE" I get:<br />"Memory Allocation Failure|Cannot generate SSPI context"<br /><br />IF I CLICK "RETRY" I get:<br />"Code execution exception:EXCEPTION BREAKPOINT"<br /><br />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?<br /><br /><br />I have looked on the Microsoft site and found the following:<br />http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP<br />http://support.microsoft.com/support/kb/articles/q229/6/08.asp <br />http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP<br /><br />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)<br /><br />I am using an Intel machine with the first edition of windows 98.<br /><br />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)<br /><br /><br />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.<br /><br /><br />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:<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7.0<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesM SSQLServer<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesS QLServerAgent<br /><br />Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?<br />I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.<br /><br /><br /><br />Any help is appreciated!<br />George<br />gplemos@email.com<br /><br /><br />

<i><b>Originally posted by : Mark</b></i><br />There ya go then ! You can't run the full version on Win 98 <br /><br /><br />------------<br />George at 9/8/2000 11:07:14 AM<br /><br />This is the FULL version.<br />george<br /><br /><br />------------<br />Mark at 9/8/2000 11:01:00 AM<br /><br />Hi,<br /><br />Are you running the development version of SQL Server or the full version ? The full version does not run correctly on Win 98, you see.<br /><br />Mark<br /><br /><br />------------<br />G. Lemos at 9/7/2000 9:45:19 PM<br /><br /><br />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:<br /><br />----------------------<br />Assertion Failed! <br />Program C;WINDOWSMMC.EXE <br />File:../src/sqlsspi.c <br />Line 120 <br /><br />Expression Count <br /><br />Then it tells me to check out the documentation for Visual C++ for info on asserts.<br />----------------------<br /><br /><br />IF I CLICK "IGNORE" I get:<br />"Memory Allocation Failure|Cannot generate SSPI context"<br /><br />IF I CLICK "RETRY" I get:<br />"Code execution exception:EXCEPTION BREAKPOINT"<br /><br />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?<br /><br /><br />I have looked on the Microsoft site and found the following:<br />http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP<br />http://support.microsoft.com/support/kb/articles/q229/6/08.asp <br />http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP<br /><br />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)<br /><br />I am using an Intel machine with the first edition of windows 98.<br /><br />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)<br /><br /><br />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.<br /><br /><br />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:<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7.0<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesM SSQLServer<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesS QLServerAgent<br /><br />Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?<br />I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.<br /><br /><br /><br />Any help is appreciated!<br />George<br />gplemos@email.com<br /><br /><br />

<i><b>Originally posted by : Happy George (gplemos@email.com)</b></i><br />Someone gave me some insight...<br />That did it. "The latest ODBC/DCOM drivers can be obtained from MDAC 2.5 and DCOM98 ."<br /><br />Grabbed those, installed them now I can connect to my SQL database do what I need to.<br /><br />Thanks to all that helped!<br /><br /><br /><br /><br /><br /><br />------------<br />Mark at 9/8/2000 11:08:37 AM<br /><br />There ya go then ! You can't run the full version on Win 98 <br /><br /><br />------------<br />George at 9/8/2000 11:07:14 AM<br /><br />This is the FULL version.<br />george<br /><br /><br />------------<br />Mark at 9/8/2000 11:01:00 AM<br /><br />Hi,<br /><br />Are you running the development version of SQL Server or the full version ? The full version does not run correctly on Win 98, you see.<br /><br />Mark<br /><br /><br />------------<br />G. Lemos at 9/7/2000 9:45:19 PM<br /><br /><br />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:<br /><br />----------------------<br />Assertion Failed! <br />Program C;WINDOWSMMC.EXE <br />File:../src/sqlsspi.c <br />Line 120 <br /><br />Expression Count <br /><br />Then it tells me to check out the documentation for Visual C++ for info on asserts.<br />----------------------<br /><br /><br />IF I CLICK "IGNORE" I get:<br />"Memory Allocation Failure|Cannot generate SSPI context"<br /><br />IF I CLICK "RETRY" I get:<br />"Code execution exception:EXCEPTION BREAKPOINT"<br /><br />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?<br /><br /><br />I have looked on the Microsoft site and found the following:<br />http://support.microsoft.com/support/ServiceWare/SQL/SQL70/EAFGBOS8E.ASP<br />http://support.microsoft.com/support/kb/articles/q229/6/08.asp <br />http://support.microsoft.com/support/kb/articles/Q267/5/50.ASP<br /><br />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)<br /><br />I am using an Intel machine with the first edition of windows 98.<br /><br />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)<br /><br /><br />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.<br /><br /><br />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:<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer<br />HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server 7.0<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesM SSQLServer<br />HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesS QLServerAgent<br /><br />Can there be something somewhere else I am missing that may not have been deleted by needs to that may affect a reinstall?<br />I even tried to update SQL 7 with the service pack 2 file, csb70full.exe and still get the same problem.<br /><br /><br /><br />Any help is appreciated!<br />George<br />gplemos@email.com<br /><br /><br />