Hello Experts,
When I Open Enterprise Manager and click on my server,
following msg appears:
SQL Server Enterprise Manager
----
A Connection could not be established to (LOCAL).
Reason: Data source name not found and no default driver
specified.
Please Verify SQL Server is running...bla, bla.
----
What Cause this:
1) I have Windows XP with SP1
2) I have had installed MDAC 2.8
3) I uninstall MDAC 2.8 using "dasetup.exe /U" command,
setup found that MDAC 2.6 is referenced to MDAC 2.8 an
had to uninstall this too, I pressed OK and then the
uninstall failed because the default of Windows XP MDAC
is 2.7 SP1 and setup propably found that some other MDAC
had to be the default.
Any way, I ReInstall MDAC 2.6 (Latest), MDAC 2.7 Refresh
and Q323263_MDAC27_x86_en.
What do I have to do having as default "MDAC 2.7 SP1 on
Windows XP SP1" and ODBC Drivers work?
Thanks in advance.Make sure shared memory is enabled in client network utility (start | run |
cliconfg)
Try editing the registration property for the server in Enterprise Manager
(Right click on the server and choose to edit registration properties). Use
the server name instead of (local)
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights|||Thanks for your response, I will do that and let you know.
>--Original Message--
>Make sure shared memory is enabled in client network
utility (start | run |
>cliconfg)
>Try editing the registration property for the server in
Enterprise Manager
>(Right click on the server and choose to edit
registration properties). Use
>the server name instead of (local)
>Thanks
>Deepali
>This posting is provided "AS IS" with no warranties, and
confers no rights
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment