SSMSE not Working on Vista (Even as Admin w Latest Patches and Updates)
I am trying to get SQL Server Managment Studio Express running on Vista Business. I've read many of the posts from a while back explaining how it needs to be run in admin mode, etc.
I've also seen that SP2 for SQL server andVisual Studio 2005 Service Pack 1 Update for Windows Vista are supposed to address compatibility issues with the Vista OS.Windows update kindly installed both of these for me successfully. However, the latter never seems to be registered as complete, because if I run "check for updates" again, it always shows up.
I tried running the installer manually from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=90e2942d-3ad1-4873-a2ee-4acc0aace5b6&displaylang=en
And it also completes successfully, but I still can't use SSMSE or VS2005 Premier Partner Edition, even "as administrator"
Error in SSMSE is "The operation could not be completed. No such interface supported". Followed by close.
Error in VS2005 is "The application cannot start." Followed by close.
[1082 byte] By [
KarlD] at [2008-1-10]
Have you tried for the error "Common IDE Package Failed to load" error, try the following:Open a command prompt.
Run the following command and hit "y" when prompted.
reg delete HKLM\Software\Microsoft\MSDN\8.0\Packages\{6E87CFAD-6C05-4adf-9CD7-3B7943875B7C} /v CodeBase
Running in a command prompt as Administrator:
C:\Windows\system32>reg delete HKLM\Software\Microsoft\MSDN\8.0\Packages\{6E87CF
AD-6C05-4adf-9CD7-3B7943875B7C} /v CodeBase
Delete the registry value CodeBase (Yes/No)? y
ERROR: The system was unable to find the specified registry key or value.
I am not trying to update from sp1 to sp2. However, I did just completely remove my SQL Server 2005 Express SP2 install and tried re-installing. I cannot get SQL Server 2005 Express SP2 to install now due to this error:
TITLE: Microsoft SQL Server 2005 Setup
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40xea75
BUTTONS:
&Retry
Cancel
Sam Lester's comments in
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=983904&SiteID=1
were helpful in pointing out it is probably something with my SQL Server Native Client install, but I am still not able to get Express installed.When I take his advice and install SNAC alone, it says successfully installed, but it obviously isn't.
Error Code: 60021
MSI (s) (04!F0) [13:38:37:182]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Sep 28 13:38:37 2007
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Fri Sep 28 13:38:37 2007
Attempt to start service when it is already running
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
Service MSSQL$SQLEXPRESS started at Fri Sep 28 13:38:37 2007
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=IM002, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error Code: 0x8007ea75 (60021)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcConnection::connect@connect
Source Line Number: 148
- Context --
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 8007ea75 (60021)
Do_sqlScript
SqlScriptHlpr
Error Code: 60021
Thanks for your help and suggestions.
Just got done removing and re-adding .net to my system. (I guess in Vista, you have to do it as a windows component, so that's what I did.)
Still same error...
