SQL Server Back End

[BillD]

I have an Access 2000 Database with 16 Tables 55 Queries 25 Forms and 60
Reports. The Database has been used to handle from 10,000 up to 50,000
records. This is a Constituents Database that is used by elected members of
the legislature to keep track of their Constituents. To date the database has
been used as a stand-alone desktop or laptop solution. The database has been
networked on up to 3 machines in some offices with Microsoft Home Network.
There is a growing demand for a system that can be accessed from computers in
different locations.
I downloaded SQL Server Express 2005 from Microsoft onto my Desktop PC. The
SQL Server 2005 downloaded and setup with few problems, but I had a problem
using the upsizing wizard from the Access 2000 program. One of the MVPs from
this site recommended I try SQL Server Migration Assistant (SSMA). I
installed the SSMA and the conversion to SQL went flawlessly. All of the SQL
Tables are linked to the Access Front End. I think that most of the queries
were converted also. All of the Reports work. Unbelievable, since I have no
previous experience with SQL Server. I have 3 computers at home networked
using MS Home Network. I placed a copy of the Access Front End on one of the
other computers. When I try to open the Access Front End on the other
computer I get a "Microsoft SQL Server Login" message.
"Connection Failed"
"SQL State: '28000'"
"SQL Server Error: 18542"
[Microsoft][ODBC SQL Driver][SQLServer] login failed for user ". The user is
not associated with a trusted SQL Server Connection.
When I press OK a new message box appears
"SQL Server Login"
Server: BILL/SQLEXPESS
There is a checkbox that is checked for "Use Trusted Connection"
Then Login ID: WRD
Password: is blank
I am using Windows Authenticity.
Question: Where do I go from here? Is this an SQL security issue? If so, how
do I correct the problem?
Thanking you and the microsoft community for the excellent feedback I have
received in the past.

 

[Norman Yuan]

I have an Access 2000 Database with 16 Tables 55 Queries 25 Forms and 60
Reports. The Database has been used to handle from 10,000 up to 50,000
records. This is a Constituents Database that is used by elected members
of
the legislature to keep track of their Constituents. To date the database
has
been used as a stand-alone desktop or laptop solution. The database has
been
networked on up to 3 machines in some offices with Microsoft Home Network.
There is a growing demand for a system that can be accessed from computers
in
different locations.
I downloaded SQL Server Express 2005 from Microsoft onto my Desktop PC.
The
SQL Server 2005 downloaded and setup with few problems, but I had a
problem
using the upsizing wizard from the Access 2000 program. One of the MVPs
from
this site recommended I try SQL Server Migration Assistant (SSMA). I
installed the SSMA and the conversion to SQL went flawlessly. All of the
SQL
Tables are linked to the Access Front End. I think that most of the
queries
were converted also. All of the Reports work. Unbelievable, since I have
no
previous experience with SQL Server.

So far so good only. Very likely you run everything in your computer as
admin. When you install SQL Server/database in a network, you probably do
not want everyone access other computer as admin. And your luck is ended
here. From here on, you need more study on SQL Server: how to set it up
correctly on a network (peer-to-peer or server/client), how the secure SQL
Server/database, i.e. how to create SQL Server logins, map them to Winodws
user account (when using windows security) or enable mixed security mode for
using username/password to connect to SQL Server, asign database user/role
permission to access certain data in certain table,create SQL Server side
objects (view/SP/UDF)...


I have 3 computers at home networked

using MS Home Network. I placed a copy of the Access Front End on one of
the
other computers. When I try to open the Access Front End on the other
computer I get a "Microsoft SQL Server Login" message.
"Connection Failed"
"SQL State: '28000'"
"SQL Server Error: 18542"
[Microsoft][ODBC SQL Driver][SQLServer] login failed for user ". The user
is
not associated with a trusted SQL Server Connection.
When I press OK a new message box appears
"SQL Server Login"
Server: BILL/SQLEXPESS
There is a checkbox that is checked for "Use Trusted Connection"
Then Login ID: WRD
Password: is blank
I am using Windows Authenticity.
Question: Where do I go from here? Is this an SQL security issue? If so,
how
do I correct the problem?
Thanking you and the microsoft community for the excellent feedback I have
received in the past.

 

[BillD]

Actually, I do want my other 2 computers to have Admin control.

I have an Access 2000 Database with 16 Tables 55 Queries 25 Forms and 60
Reports. The Database has been used to handle from 10,000 up to 50,000
records. This is a Constituents Database that is used by elected members
of
the legislature to keep track of their Constituents. To date the database
has
been used as a stand-alone desktop or laptop solution. The database has
been
networked on up to 3 machines in some offices with Microsoft Home Network.
There is a growing demand for a system that can be accessed from computers
in
different locations.
I downloaded SQL Server Express 2005 from Microsoft onto my Desktop PC.
The
SQL Server 2005 downloaded and setup with few problems, but I had a
problem
using the upsizing wizard from the Access 2000 program. One of the MVPs
from
this site recommended I try SQL Server Migration Assistant (SSMA). I
installed the SSMA and the conversion to SQL went flawlessly. All of the
SQL
Tables are linked to the Access Front End. I think that most of the
queries
were converted also. All of the Reports work. Unbelievable, since I have
no
previous experience with SQL Server.

So far so good only. Very likely you run everything in your computer as
admin. When you install SQL Server/database in a network, you probably do
not want everyone access other computer as admin. And your luck is ended
here. From here on, you need more study on SQL Server: how to set it up
correctly on a network (peer-to-peer or server/client), how the secure SQL
Server/database, i.e. how to create SQL Server logins, map them to Winodws
user account (when using windows security) or enable mixed security mode for
using username/password to connect to SQL Server, asign database user/role
permission to access certain data in certain table,create SQL Server side
objects (view/SP/UDF)...


I have 3 computers at home networked

using MS Home Network. I placed a copy of the Access Front End on one of
the
other computers. When I try to open the Access Front End on the other
computer I get a "Microsoft SQL Server Login" message.
"Connection Failed"
"SQL State: '28000'"
"SQL Server Error: 18542"
[Microsoft][ODBC SQL Driver][SQLServer] login failed for user ". The user
is
not associated with a trusted SQL Server Connection.
When I press OK a new message box appears
"SQL Server Login"
Server: BILL/SQLEXPESS
There is a checkbox that is checked for "Use Trusted Connection"
Then Login ID: WRD
Password: is blank
I am using Windows Authenticity.
Question: Where do I go from here? Is this an SQL security issue? If so,
how
do I correct the problem?
Thanking you and the microsoft community for the excellent feedback I have
received in the past.