When you start SQL Server with the -f parameter, you are pretty much left
with command line only.
From the command line though you could do the following:
isql /Usa /P<password> /S<servername>
1> EXEC sp_configure xxxxxxxxxxxxxxxxxxxxxxx
Use the sp_configure with the appropriate arguments to change whatever
configurations you need to.
Rick Sawtell MCP, MCT, MCSD
10 Million Lemmings Can't Be Wrong
try login as SA using ISQL/w or ISQL
check out the BOL with how to use the sp_configure
On Fri, 26 Feb 1999 13:38:58 +0300, "Srinivas Gudala"
?? .oooO?? Oooo.??
====(? )=====(? )===============
???? \ (???? ) /
????? \_)?? (_/ ????????? ??????????????????????????????????
Hello, I'm trying to setup a dts package to recieve
updated from tables in an oracle database. I keep getting
the following error message when i select my data source
and type in my credentials for the oracle server from the
dts package wizard:
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [Microsoft] [ODBC Driver Manager]
Driver's SQLSetConnectAttr failed Context: Error during
initialization of the provider.
I am running SQL Server 7.0 with SP4, and have already
loaded MDAC 2.7. I have Oracle 8i loaded, and I have
tested my connection to the Oracle server, and it succeeds
there. But it wont connect for me in the dts package
wizard. I have tried this same process on a different
machine, and the connection succeeds in the dts package
wizard. So there is something incorrect on my server. My
driver versions are:
Oracle v8.01.07.00 sqora32.dll 5/11/2000
Microsoft ODBC for Oracle v2.573.9001.00 msorcl32.dll
SQL Server v2000.81.9001.00 sqlsrv32.dll 2/19/02.
I already have a system dsn setup with the attributes to
the oracle server in the odbc data sources section in the
control panel. This is a Windows NT Server 4.0 SP6a
machine. Does anyone have any suggestions that I have