Access 2003 App and SA Account
I inherited an Access application which appear on the SQL side to only
be accessed by the "sa" account. There is not code that uses the
login. How is this possible? The database owner is the sa account
but other than that how do the users authenticate to SQL?
.
Relevant Pages
- Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
(microsoft.public.sqlserver.clustering) - Re: SQL Server on XP Home Network
... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
(microsoft.public.sqlserver.setup) - Re: SQL Connection with .udl and domain accounts
... work because it's not recognised by SQL-Server as a valid User Id. ... difference between a SQL account and a domain account. ... Login account using a SQL Login name and password that will ...
(microsoft.public.sqlserver.connect) - Re: sql problem
... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
(comp.databases.oracle.server) - Re: sql problem
... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
(comp.databases.oracle.server) |
|
