DataBase - connect to sql server 2005 from client

Dear all
After i installed sql serverr 2005 on window server 2008
and i attached my data base on the server successfuly
in the client  i cant see the database from access 2007 adp

so pls any idea??

best regards

--
Message posted via http://www.accessmonster.com

  Paul Shapiro replied to ashraf_al_ani via AccessMonster.com

Check SQL Server Configuration Manager on the server to see that TCP/IP is
enabled.
Check that the server firewall allows TCP port 1433 from the workstation(s).
Make sure the user has a login on the SQL Server that is mapped to a user
in the database with appropriate permissions.

  a a r o n . k e m p f replied to ashraf_al_ani via AccessMonster.com

have you tried IP address vs servername?

is there an _INSTANCE_ name on your SQL Server?

Do you have NT permissions?
SQL Login?

SQL query slow DataBase Hi In the code below I found that it takes 1.3 seconds to load to split it up or cancel the query? And can I read this faster? string sql = EquipmentID(Equipment) + StartDate.ToOADate().ToString(FloatFormat, myCulture) + EndDate.ToOADate().ToString(FloatFormat, myCulture); sql + = " group by event_id, name"; _Log("Calc thread #2"); OleDbCommand com = new OleDbCommand(sql, con); _Log("Calc thread #3"); From #2 to #3 it takes 1.3 seconds. Remaing less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides

Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed reading this article, is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will 2010 does not really save them money (because of the 64-bit requirements of Sharepoint Server 2010, it could vastly increase those costs for organizations with legacy hardware). The features of email hosted by someone else, so it is not a paradigmatic change. Having your flagship database applications hosted outside your local LAN seems to me to be a big leap, and http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1) SharePoint (1) David W. Fenton (1) Access 2010 (1) Everything you

Using Mysql or SQL server as backend to Access front end DataBase Have a client having problems with a fairly complex Access system which is split into end. Using access 2003 / mdb format with Access 2007 software. We are surmising that recent server problems or connectivity problems may be to blame. If we converted to MySQL or SQL server as the back end, would that eliminate the potential for Database corruption that can occur with Access Jet databases when you lose connectivity, when someone shuts down their PC with the database active, etc? If so am I correct that you connect via ODBC rather than using

Aaron Kempf's MCITP DBA proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson Microsoft Office Access (1) Bing Microsoft SQL Server

Access to SQLServer GCE DataBase I = 92m trying to step up from being a decent Access Programmer, to including SQLServer components and hundreds of thousands of events if that makes any difference. Thanks Access Discussions SQL Server (1) Larry Linson Microsoft Office Access (1) SharePoint (1) InfoPath (1) Microsoft SQL Server (1) Access 2007 (1) Informix (1) Office (1) One way to pass a query from your Access database to the server (in your case, but not necessarily, Microsoft SQL Server) is to use a Passthrough Query (which means to ODBC "pass this to the