help needed with installing SQL Server 7 on Win2000 Proffessional
S_H_
machine.
At the end of installing, SQL server tries to connenct to the server
(IIS) on my machine, but everytime the connection failes and the
installation abort.
In my logs I get the following:
Starting Service ...
Connecting to Server ...
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not
exist or access denied.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(Connect()).
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not
exist or access denied.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(Connect()).
driver={sql server};server=SALAMANDER2K;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
SQL Server configuration failed.
Can anyone give me some advice?
Thanks in advance,
Hans
Dana Burnell
How are you logged on? You need to be an admin.
"S_H_" <n...@email.address> wrote in message
news:qvijvs0q7ne79d7af...@4ax.com...
mming
I'd first determine if it is truly a connectivity problem or if the server
failed to start. setup does a rollback and leaves cnfgsvr.out and ERRORLOG.
Next time don't dismiss the "failed to configure server" popup otherwise
setup will rollback. Start sql from command prompt
sqlservr -c -m (you'll also need -T3608 unless you installed to c:\mssql7).
then use osql.exe to try to connect.
Since with server=. it used named pipes but with server=SALAMANDER2K used
shared memory perhaps there is an alias setup to the machine name in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
that is causing the connectivity problem.
"S_H_" <n...@email.address> wrote in message
news:qvijvs0q7ne79d7af...@4ax.com...
S_H_
I didn't succeed to install SQL Server 7 but this is what I found.
- I'm logged on as an admin
- Tried to start SQL Server with osql.exe from the prompt gives:
F:\MSSQL7\Binn\osql.exe
password ****
[Microsoft][ODBC SQL Driver][Shared Memory]SQL Server does not
exisit
acces denied
[Microsoft][ODBC SQL Driver][Shared Memory]
- When I look in the registry (after stopping the install) :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
I see the following:
(default) REG_SZ (Value not set)
DSQUERY REG_SZ DBNMPNTW
There is also another key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
Is it a smart idea just to delete these two SQL Server keys?
Or is there something else that I can do?
Hans
Mike Maringas
I'm not sure of the steps you have taken. You described trying to start SQL
Server with osql. osql doesn't start the server and would give this same
error message if the server was not started and you tried to connect. Can
you clarify that prior to connecting you verified sqlservr.exe is running?
The DSQUERY registry entry should be fine.
It looks like SQL 2000 has been on this machine? Do you have an registry
entry "SharedMemoryOn" (it would be under one of the keys you mentioned I
forget which)?
Do you get different result if you do and do not pass
-S <servername> command line argument to osql?
Assuming you don't have any other installs then deleting
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
and
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
would be a fine idea.
"S_H_" <n...@email.address> wrote in message
news:nh8nvs4i3c0lpr7rj...@4ax.com...
S_H_
What I see when I try to start SQL Server from the prompt is:
First some things are starting up, F:\MSSQL7\data\master.mdf is
opened, and then it tries to open "C:\MSSQL7\data\model.mdf"
This fails logically because I try to install SQL Server on my
F-drive, not on C:
After that nothing happens and sqlservr.exe isn't running.
Why is it trying to open this database file from my C-drive and how
can I change that?
I have looked under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
and under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
but I don't have a registry entry "SharedMemoryOn"
The other things I didn't checked yet because I assume that it is
necessary that SQL Server is running before I can go on.
Hans
On Fri, 27 Oct 2000 11:40:48 -0700, S_H_ <n...@email.address> wrote:
Mike Maringas
From the original message:
sqlservr -c -m -T3608
will get the server started so you can work out the connectivity kinks. it
will not start if you installed to F:drive without the -T3608.
"S_H_" <n...@email.address> wrote in message
news:ia9pvsgtgrp4ioop0...@4ax.com...
S_H_
Well, I got i litle bit further now.
After install with the popup box "failed to configure server" open I
try to start SQL Server with: sqlserver.exe -c -m -T3608 from the
prompt.
There are things starting but it stops with:
"kernel Warning: override, autoexec procedures skipped"
It's the last line in the ERRORLOG file beneath.
Are there some other things to do for me?
ERRORLOG:
2000-10-31 19:36:31.74 kernel Microsoft SQL Server 7.00 - 7.00.623
(Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
2000-10-31 19:36:31.78 kernel Copyright (C) 1988-1997 Microsoft
Corporation.
2000-10-31 19:36:31.78 kernel All rights reserved.
2000-10-31 19:36:31.78 kernel Logging SQL Server messages in file
'F:\MSSQL7\log\ERRORLOG'.
2000-10-31 19:36:31.86 kernel initconfig: Number of user connections
limited to 32767.
2000-10-31 19:36:31.86 kernel SQL Server is starting at priority
class 'normal'(1 CPU detected).
2000-10-31 19:36:31.93 kernel User Mode Scheduler configured for
thread processing
2000-10-31 19:36:33.19 server Directory Size: 5391
2000-10-31 19:36:33.25 spid1 Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks
2000-10-31 19:36:33.27 spid1 Warning ******************
2000-10-31 19:36:33.28 spid1 SQL Server started in single user
mode. Updates allowed to system catalogs.
2000-10-31 19:36:33.28 spid1 Warning ******************
2000-10-31 19:36:33.29 spid1 Recovering only master database
2000-10-31 19:36:33.29 spid1 Starting up database 'master'.
2000-10-31 19:36:33.29 spid1 Opening file
F:\MSSQL7\data\master.mdf.
2000-10-31 19:36:33.37 spid1 Opening file
F:\MSSQL7\data\mastlog.ldf.
2000-10-31 19:36:33.47 spid1 Loading SQL Server's Unicode
collation.
2000-10-31 19:36:33.50 spid1 Loading SQL Server's non-Unicode sort
order and character set.
2000-10-31 19:36:33.62 spid1 4 transactions rolled forward in
database 'master' (1).
2000-10-31 19:36:33.65 spid1 0 transactions rolled back in database
'master' (1).
2000-10-31 19:36:33.84 spid1 Server is unnamed.
2000-10-31 19:36:33.85 kernel Using 'SQLEVN70.DLL' version
'7.00.623'.
2000-10-31 19:36:33.85 kernel Using 'OPENDS60.DLL' version
'7.00.00.0623'.
2000-10-31 19:36:33.91 ods Using 'SSNMPN70.DLL' version '7.0.623'
to listen on '\\.\pipe\sql\query'.
2000-10-31 19:36:33.91 ods Using 'SSMSSO70.DLL' version '7.0.623'
to listen on '1433'.
2000-10-31 19:36:33.99 ods Using 'SSMSRP70.DLL' version '7.0.623'
to listen on 'SALAMANDER2K'.
2000-10-31 19:36:34.08 spid1 SQL Server's Unicode collation is:
2000-10-31 19:36:34.08 spid1 'English' (ID = 1033).
2000-10-31 19:36:34.08 spid1 comparison style = 196609.
2000-10-31 19:36:34.09 spid1 SQL Server's non-Unicode sort order
is:
2000-10-31 19:36:34.09 spid1 'nocase_iso' (ID = 52).
2000-10-31 19:36:34.09 spid1 SQL Server's non-Unicode character set
is:
2000-10-31 19:36:34.10 spid1 'iso_1' (ID = 1).
2000-10-31 19:36:34.14 kernel Warning: override, autoexec procedures
skipped.
Hans
On Fri, 27 Oct 2000 11:40:48 -0700, S_H_ <n...@email.address> wrote:
mji...@my-deja.com
am having the most incredibly hard time trying to find a copy of SQL
Server 7. Everyone involved in this discussion seems to have it or
knows where to get it. I NEED either the full version, or would even
be most incredibly happy with the 120 trial edition. I am looking for
either a working link to where I can download the program (it's no
longer available on Microsoft's site), or someone who can e-mail it to
me, or upload it to my freedrive account or something. If anyone
reading this can help me, please post here, or preferably e-mail me at
mj...@hotmail.com.
HELP!!!!!!!!!
Thanks,
Sent via Deja.com http://www.deja.com/
Before you buy.
S_H_
Thanks, it's working now!!!!
Hans
On Fri, 27 Oct 2000 11:40:48 -0700, S_H_ <n...@email.address> wrote:
Mike Maringas
is sql 2000 an option?
microsoft.com/sql has an evaluation edition available.
<mji...@my-deja.com> wrote in message news:8to2mr$d8$1...@nnrp1.deja.com...
Kalen Delaney
Also, there are a lot of books out there that include a evaluation copy of
SQL 7.
Maybe you can find someone who has one of those books.
HTH
--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
www.TheHungerSite.com
Mike Maringas <mm...@email.msn.com> wrote in message
news:uE$#etURAHA.248@cppssbbsa05...