• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

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?
0
CalvinDay
Asked:
CalvinDay
  • 4
1 Solution
 
Faruk Onder YerliOwnerCommented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now