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 |
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-23 : 16:39:44
|
| Vista forces us to install SQL Server as an administrator.If we log in as a non-administrator we can't see or connect to the database from our application.Any ideas? |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-01-23 : 16:52:15
|
| Have you tried granting permission to the non-administrator account in SQL Server?What error message do you get?=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
 |
|
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-23 : 17:08:58
|
quote: Originally posted by graz Have you tried granting permission to the non-administrator account in SQL Server?What error message do you get?=================================================Creating tomorrow's legacy systems today. One crisis at a time.
We're using SQL Server Authentication. The user/login created is a system administrator.If our users run our application once as an administrator, they can then run the application as a non-administrator. COM object registration problem? |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2008-01-23 : 17:31:16
|
| No idea on the COM stuff. You can have SQL Server log failed login attempts. That will tell you if it's a login failure.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
 |
|
|
|
|
|