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 |
|
beerbsh316
Starting Member
6 Posts |
 Posted - 2007-01-10 : 11:25:07
|
| I am developing an application in VB.NET that is using a sql database. I am trying to start testing with multiple computers running the app while the database is on a remote computer. I have 2 desktop computers networked right now with 1 of them having the database and the other I want to run the program on. I am trying to figure out how to use windows authentication to login to sql server from the remote computer. I can login using Sql authentication but it is taking forever and I keep getting timeout errors so I wanted to try Windows Authentication to see if it is faster. If someone could walk me through the steps I need to take or give me some suggestions to fix my problems I would greatly appreciate it. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-01-10 : 12:32:17
|
what auth mode you use has nothing to do with query perf. the perf of a query has to do with the query itself, and what indexes are on the tables/views you are hitting.
www.elsasoft.org |
 |
|
|
beerbsh316
Starting Member
6 Posts |
Posted - 2007-01-10 : 12:48:10
|
| Well what would cause it to take so much longer on the remote computer as opposed to when I am running the program on the same computer as the sql server database. When I use the local computer it is very fast but on the remote computer it times out. |
|
|
|
|
|
|
Creating logins for SQL Server 2005