Accessing local instance of SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a file DSN using an SQL Server driver.
When I open the server list to select the RDBMS server, no
servers appear (not even local or netbios name). If I type in
'local', proceed to the next screen (to select Win NT authen-
tication) and click on 'next', I get a message that access to
SQL Server is denied - I can't access the 'local' instance of my
SQL Server even though the SQL Server is running (green
light is on in task bar icon). Do I need to do some configuring
to enable access to the 'local' instance of my SQL Server?
Thank you, Edward.
 
Hi,

When you configure the parameters of CliConfg, did you create a alias.
Because it is the alias it use in this parameter of ODBC.
 
It's (local), with the *parenthesis*. You can also create an alias, as
suggested by the other post.

S. L.
 
By the way, using a DSN is not a good idea, as this mean that you must
either use ODBC or the Microsoft OLEDB provider; which is an hybrid between
ODBC and OLEDB.

You should use the OLEDB provider for SQL-Server instead.

S. L.
 
Back
Top