trying to connect to SQL Server ...
- From: "wbsurfver@xxxxxxxxx" <wbsurfver@xxxxxxxxx>
- Date: Wed, 07 Nov 2007 20:07:24 -0000
We have a dev and a production box. I can connect to the dev box fine
with my Ruby program either using and ODBC connection, or through
win32ole. I specify the host as of the form dev.office.mycompany.com
which is on our intranet.
The prod machine environment is very similar if not identical, these
machines are running an older version of SQL Server. I did not know
the password for the prod box, so the admin said he set up an ODBC
connection. If I log onto the machine, I can connect to it through
Query Analyzer, it gives me a server selection and the server is
called something like: 'prod\vendor' . Having a backslash in the name
seems odd, but I can't connect using the password or account he gave
me remotely using my script which works on the dev box fine. I've
tried prod.office.mycompany.com 'prod\vendor.office.mycompany.com',
'prod\\vendor.office.mycompany.com'. I'm not sure what to try. I found
some kind of password cracking tool for sql server, it is able to
locate the login account on the dev machine, but not the password. I
don't know that I can run it on the prod machine.
If anyone can help me as far as what INI files or anything to look at
to try to figure this out, thanks alot ...
.
- Prev by Date: SQL 2000: VPN "Server Does Not Exist"
- Next by Date: RE: Tracing SQL Server 2000 Connections
- Previous by thread: SQL 2000: VPN "Server Does Not Exist"
- Next by thread: SQLSERVER2005 64 bit linked server problem
- Index(es):
Relevant Pages
|
