Problems connecting to SQL Server

Good afternoon!

I am a complete newbie when it comes to SQL, so please be gentle!

We have a mission-critical application that runs on a WINNT 4 SP6a/SQL 7 SP4
PDC (This was setup several years ago - way before my time). There are
three clients that use this application - but they use it a ton!!!! One of
the clients suffered from a hard drive crash.

Anyway, I replaced the hard drive and loaded WIN2000 Pro SP4 with all
patches. I am trying to install the ODBC driver but do not know the SA
password (a whole other issue). Not sure that we know the SYSADM password
either (not sure if this is a SQL account or a Maximo account - I think that
later). So, I can not connect from this machine to the SQL Server.

I have seen in the documentation for Maximo that I need to install the SQL
Client software. I assume that this is on the SQL Server CD (another
problem is that I have the SQL 7.0 Installation Media but do not have the
Product Key....it just keeps getting better!). I do not see that the SQL
Client software was installed on the other two stations (one WIN2000 and one
WINXP). Is this necessary (I told you that I am a complete newbie!)? Does
installing the SQL Client software help in establishing a connection from
client to server?

Also, I want to make sure that in my attempts to resolve this connection
issue that I do not break the connection for the other two. That would be
really bad!

Maximo (read: MRO Software) has been very helpful but, rightly so, states
that this part of the problem is a SQL issue and not a Maximo issue.

Can anyone offer any advice? I would be most grateful. I find myself in a
rather difficult situation and the affected user is starting to loose his
patience. As are the other two (because he needs to sit on their computers
to use Maximo).

--
Cary W. Shultz
Roanoke, VA 24012


.

Relevant Pages

  • Re: Problems connecting to SQL Server
    ... I am a complete newbie when it comes to SQL, ... You should not need to know the sa password to install the ODBC driver. ... SQL Server Authentication and Windows NT ... The manual for Maximo specifically ...
    (microsoft.public.sqlserver.clients)
  • Cant connect to databases through Enterprise Manager
    ... We have client software that uses SQL 7 as a database. ... registration properties (by right-clicking on the COMPUTER ...
    (microsoft.public.sqlserver.connect)
  • XP Access problems
    ... I've just recently started to evaluate SQL Server2000. ... couple of DTS packages which I would like users to try. ... client software on Win2000 PC's everything works fine. ... Win2000 Pc's I get straight onto my PC. ...
    (microsoft.public.sqlserver.security)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)