Hello!
I'm trying to upgrade old MSDE instances to SQL Server 2005 Express SP1.
The following command fails:
SQLEXPR.EXE /qb UPGRADE=SQL_Engine INSTANCENAME=XXX ADDLOCAL=Client_Components,Connectivity
because the domain\x user cannot login. We have disabled Windows authentication. Is there a way to supply the SA login instead of a domain user?
Problem no #2:
After upgrading with Windows Authentication turned on, current SQL users cannot login (sa). Is Mixed authentication mode turned off during upgrade? Or what else could be the problem?
Our application is distributed around Europe. We have no control over our customers security settings/logins.
Also, the database contains sensitive data. Giving Windows Administrators access to the database is out of the question.
Kind regards
A
Check in the template.ini file that's in the high-level directory of the install media; the options are explained pretty well in there but in brief you can specify accounts, passwords, and security mode.
No comments:
Post a Comment