Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Just trying to make ODBC connection..
Message
 
À
30/08/2011 05:32:47
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01522203
Message ID:
01522205
Vues:
42
>Hello all;
>
>I have a Sqlserver installation running on machine A. I can login on that machine as a windows (server 2008) user as User U1 and I can do everything I want with Sql Server. I have added Windows user U2 and granted him priviliges for Sql Server.
>
>On workstation B, I made an ODBC-connection with Windows User priiliges as user U2, and the connection is ok, everything works fine.
>On workstation C, which as a machine and OS is a copy of B, i try to make an ODBC connection being logged in as user U1, but the login during ODBC-check is rejected.
>I try with the priviliges of user U2: login rejected. I try as a SQL-user: login rejected. Everything I try: login rejected.
>
>I have made at least 100 ODBC connections on different machines during the last 15 years, but I'm stuck. Any idea?
>
>TIA,
>
>Lennert

What is the error message?
Try to use different network library - Named Pipes or TCP/IP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform