SQL Server Back End

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillD - 21 Jan 2008 18:38 GMT

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.

Reply to this Message

Norman Yuan - 21 Jan 2008 19:02 GMT

>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
[quoted text clipped - 22 lines]
> 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
[quoted text clipped - 18 lines]
> Thanking you and the microsoft community for the excellent feedback I have
> received in the past.

Reply to this Message

BillD - 23 Jan 2008 00:03 GMT

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
[quoted text clipped - 57 lines]
> > Thanking you and the microsoft community for the excellent feedback I have
> > received in the past.

Reply to this Message