| Author |
SQL server upgrade problems
|
|
| dinosaw 2005-06-22, 3:23 am |
| Trying to install SLP SP3A and will not log on as sa to do the upgrade. WHen
I run enterprise manager from the server I get the following connection error:
" A connection could not be established to OurServerName
Drivers SQLAllocHandle on SQL_HANDLE_ENV Failed"
I can however connect to the server from a workstation running enterprise
manager. Server is running windows 2000 server SP4.
| |
| Mike Hodgson 2005-06-22, 3:23 am |
| Are you using a trusted connection from SQLEM running on your
workstation? Have you got SQL connections disabled, thereby only
allowing Windows Authentication (out of the box default settings)? If
yes then you won't be able to connect to your SQL instance with the 'sa'
login - you'll have to either enable mixed authentication or use a
trusted login to connect to the SQL instance during the upgrade.
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com
dinosaw wrote:
>Trying to install SLP SP3A and will not log on as sa to do the upgrade. WHen
>I run enterprise manager from the server I get the following connection error:
>" A connection could not be established to OurServerName
>Drivers SQLAllocHandle on SQL_HANDLE_ENV Failed"
>
>I can however connect to the server from a workstation running enterprise
>manager. Server is running windows 2000 server SP4.
>
>
>
| |
| dinosaw 2005-06-22, 3:23 am |
| Server is running in mixed mode authentication I can connect from a
workstation using both sa and windows authentication. One other this is the
SQL server agent wont run on the server either.
"Mike Hodgson" wrote:
> Are you using a trusted connection from SQLEM running on your
> workstation? Have you got SQL connections disabled, thereby only
> allowing Windows Authentication (out of the box default settings)? If
> yes then you won't be able to connect to your SQL instance with the 'sa'
> login - you'll have to either enable mixed authentication or use a
> trusted login to connect to the SQL instance during the upgrade.
>
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com
>
>
>
> dinosaw wrote:
>
>
| |
| Mark Allison 2005-06-22, 3:23 am |
| dinosaw,
This is normally a problem with the ODBC driver. I would recommend
reinstalling MDAC and then trying again.
MDAC
http://msdn.microsoft.com/data/mdac...ds/default.aspx
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
dinosaw wrote:
> Trying to install SLP SP3A and will not log on as sa to do the upgrade. WHen
> I run enterprise manager from the server I get the following connection error:
> " A connection could not be established to OurServerName
> Drivers SQLAllocHandle on SQL_HANDLE_ENV Failed"
>
> I can however connect to the server from a workstation running enterprise
> manager. Server is running windows 2000 server SP4.
>
| |
|
|
| oliver9905 2006-02-28, 8:23 pm |
|
dinosaw,
I've have the same error in SQL Server. how did u uninstalled MDAC?
oliver9905
dinosaw wrote:[color=darkred
]
> *Mark
>
> Love your work.
>
> Uninstall MDAC and reinstalled all worked fine.
>
> Thanks for this.
>
> "Mark Allison" wrote:
>
--
oliver9905
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1689503.html
|
|
|
|