Cannot connect to SQL Express 2005

  • Thread starter Thread starter SF
  • Start date Start date
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
 
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?
 
Back
Top