Cannot connect to SQL Express 2005

S

SF

Hi

I have an ADP which run very well under SQL 2000. I have recently replace
the SQL 2000 with SQL Express 2005. My ADP now cannot connect to SQL Express
2005.

Could anyone advice?

SF
 
N

Norman Yuan

How did you replace SQL Server2000? It is most likely, your Sql Server
Express configuration problem.

1. Do you know the correct server name or server instance name?
2. Does it allow remote access (from other computer, if you use ADP or other
app to connect it from other computer). Hint: by default installation,
remote connection is disabled.
3. Do you try to connect it with Windows security or SQL Server security?
Hint, by default, Sql Server security is not enabled.
4. If you use Windows security, did you created a sql server login that maps
to the windows user account you used to connect to the SQL Server express?
5. Did you gave to appropriate permmission to the database you want to
connect to on the SQL Server Express?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000 ADP and SQL Server 2005 2
Using Access 2007 adp project files with SQL Server 2008 Express 3
Access 2007 ADP (Runtime) and SQL Express 2005 6
Access 2007 and ADP to SQL Server 2005 in Vista 12
SQL Server 2005 schema for Access 2007 ADP 2
MSDE + SQL 2000 Newbie Question 4
Login to SQL Server 1
Sql Server 2005 Express Advanced Services 1

Top