Problem connecting to MSSQL

I am trying to connect to a MSSQL database. I can access to tables using MS tools but I cannot set up an alias in the BDE administrator. The error I get is server not availible. What am I doing wrong? What parameters are important when setting up a MSSQL alias and where do they come from?
LVL 2
CalvinDayAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Faruk Onder YerliConnect With a Mentor OwnerCommented:
Please Write on the bDE

Database Name : master
USERNAME      : sa
SQLQUERYMODE  : Server
SERVERNAME    : yourservername or
                         IP adress

You must copy Ntwdblib.dll files in windows\system directory.

it is enough ...
0
 
CalvinDayAuthor Commented:
equalizer

I have two users. One is dbo. Do you know its password.
0
 
CalvinDayAuthor Commented:
equalizer

I have two users. One is dbo. Do you know its password.
0
 
CalvinDayAuthor Commented:
Or, do you know the password for sa in the master database?
0
 
CalvinDayAuthor Commented:
Never mind, there is no password.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.