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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Vista / SQL Server issue

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.
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -