Unable to access SQL server via active x account

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leighton.d - 27 Jul 2006 16:51 GMT

On one of our SQL Server 2000 machines, I've created a SQL server account
using an Active X directory account. I did this by adding a new login,
navigating to the Active X account. I've granted the account the same
permissions as a local SQL server account that I've been using to access the
server both from query analyzer as well as ODBC connections.

When I attempt to connect to the server via query analyzer, I receive the
message:

Unable to connect to server DASLSQL
Server: Msg 18456, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'leighton_d'

I've setup this account with identical permissions as the local SQL server
account that works.

What did I miss?

Thanks!

Doug

Reply to this Message

Sue Hoegemeier - 28 Jul 2006 00:53 GMT

Hi Doug,
I'm having a hard time following what the existing account
is that you were using - what do you mean by a local SQL
server account?
You can use Windows Authentication or SQL Server
authentication to access a SQL Server box. Windows
authentication uses the users Windows login account and SQL
Server authentication uses SQL Logins.
If you had been entering a user name and password, you were
using SQL Server authentication. If you have now added
another login for yourself that is a windows login in the
domain (that is where you can add a login from Active
Directory), then you would want to connect using Windows
Authentication and not enter a user name and password. In
Query Analyzer when you try to connect, make sure you select
Windows Authentication in the Connect Using section of the
login dialog box. In this case you don't enter a user name
and password. You also need to be logged into the domain on
the PC or server that you are using to log into SQL Server.

-Sue

>On one of our SQL Server 2000 machines, I've created a SQL server account
>using an Active X directory account. I did this by adding a new login,
[quoted text clipped - 18 lines]
>
>Doug

Reply to this Message

Leighton.d - 28 Jul 2006 02:01 GMT

OK, you just gave me a quick education on the differences between the two
types of accounts. Now that I know more, I think I can provide you the
necessary elements of what I'm attempting to do.

We have a web-based student software package that uses active directory
accounts as the method of authentication. Aside from using these accounts to
logon to the web software, I also want to be able to use the same accounts to
establish ODBC connections so that they can extract their own data into MS
Access or MS Excel. I've been using SQL server accounts, but figured that if
I could eliminate a username/password combination from their lives, they'd be
a little happier. I wrote an addon utility for MS Access that allows users
to select and extract data from virtually any type of database server in a
point-n-click environment. They've been using it to connect to our older VMS
servers, and now to our SQL servers as they migrate from one to the other.
It's become a popular tool in school districts all across Ohio.

Any direction you can provide will be greatly appreciated.

Thanks...

> Hi Doug,
> I'm having a hard time following what the existing account
[quoted text clipped - 40 lines]
> >
> >Doug

Reply to this Message