OSQL-connect only with sa possible???

[joeka77]

Hello, big problem: If i use the osql.exe-Tool to connect to a server, its only possible by uing an SQL-Account. But if i use a Windows-Account (SQL runs in mixed mode) i get the "access denied"-message. In order to install Projectserver with Teamservices (complicated) i need a Windows-Account. I tested it with the Administrator-Account and gave it all rights to the database!! But: SQL-Accounts work, Windows-Accounts does not!
Anybody can help me fix this problem?

 

[sguslan]

First do not use -u and -p options. Second make sure there are no environment variables set for OSQL. These variables are set using dos SET commands. The variables are OSQLUSer and OSQLPASSWORD, and OSQLSERVER....

________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[joeka77]

Thanks, but i have to supply -U or -E. And using -E doesnt work ... :-(

 

[sguslan]

According to Book Online, If you do not set any environment variables, then OSQL will connect using Windows accounts, i.e. the currently logged on user...Search book online for "osql" ... ________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[JamesLean]

1)Open a command prompt and type:

set

Check the list of env variables and make sure the ones relating to SQL (as above) are not set.

2)If none set, try simply connecting with osql:

osql -Sservername -E

If this doesn't work then make sure your NT account actually has permissions to connect to the server!

If it does work then there must be a problem with the specific procedure you are trying to execute. --James