Accessing local instance of SQL Server

[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.

 

[labc]

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.

 

[Sylvain Lafontaine]

It's (local), with the *parenthesis*. You can also create an alias, as
suggested by the other post.

S. L.

 

[Sylvain Lafontaine]

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.