Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xort
Starting Member
3 Posts |
 Posted - 2011-12-24 : 09:56:15
|
| Hi,My problem goes like that:I have a Windows 2008 R2 x64 Terminal Server and a Windows 2008 R2 x64 with SQL 2008 database server. I installed an application at the Terminal Server which connects using OLEDB at the database server. If I run the application using an admin account the application works fine. If I run the application using a regular user then I get a sqlstate=HYT00 error. I did some digging and some people suggested to use the database server ip instead of the server DNS. I tried that but I had no luck. The only way that I managed to make the application work using a regular user was when I added the user to the Terminal Server’s administrators group. I would really appreciate it if you could help me with the above issue. Thank you in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-24 : 10:10:07
|
| are the terminal server and SQL 2008 database server in same domain? also is the application using windows credential itself to connect to db?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
xort
Starting Member
3 Posts |
Posted - 2011-12-24 : 11:39:34
|
| Yes, both servers are on the same domain. The application is not using windows credentials. It is using SQL credentials. There are other applications installed at the Terminal Server which are able to connect to the database server. Those applications don’t use OLEDB but they use the same SQL credentials. |
|
|
|
xort
Starting Member
3 Posts |
Posted - 2011-12-26 : 17:59:45
|
| any ideas? |
|
|
|
|
|
|
OLEDB problem