.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Problem connecting to SQL Server 2008 R2 Express from Access 2007

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

View Complete Post

More Related Resource Links

Problem with ODBC from MS Access 2007 to MS Sql Server 2008

Hi experts, I need some help with ODBC Connection Settings from MS Access 2007 to Sql Server 2008. Here is the Scenario, I have created a Database(StagingDB) with 5 tables on SQlServer 2008 and I have  Developed an MS Access 2007 Front End using Linked tables and ODBC to Insert/ Update data into these 5 tables. This is just working fine in my Dev database. ODBC Connection Settings are pointing to my DevServer. All I wanted to do now is, I want to point the ODBC Settings to the same database on my Test Server and then to Production Server. I have Changed the Server name in the ODBC File to point it to my Test Server and If I try to Insert  some data into test server its stil going into the database on Dev server. Is this the right way to do. Please help me with this. thanks In Advance..

Upsizing Database from Access 2007 to SQL Server Express 2008

I have recently downloaded and installed SQL Server Express 2008 on to my Windows XP SP3 machine, I have a large MS Access 2007 database (.accdb) I wish to export out to SQL Server. I am using the 'upsizing wizard' that is found on the 'Database Tools' tab of Access 2007. Clicking on the 'Database Tools' tab and then on the 'SQL Server' button starts the Upsizing wizard. On the first page of which I select the 'Create new database' option, the next page asks 'What SQL Server would you like to use for this database?' it already has '(local)' entered into the text box, so I leave that unchanged, I tick the trusted connection box and name the new SQL Server database and then click 'Next'. But I get the following error (it appears in a Windows information message box):

Title: Microsoft SQL Server Login
Message Text:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect()).
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

PS. I have successfully used the upsizing wizard to export the same Access database into SQL Server Express 2005 on another machine.

What am I doing wrong this time?

Problem remotely connecting to sql server 2008 express



I am trying to connect to sql server 2008 express remotely from visual studio 2010. On the server, I've enabled the sql browser service, enabled the TCP/IP and named pipes protocols. Also for firewall I added exceptions for the sqlserver and sqlbrowser instances. I tried connecting to the server through telnet by specifying the ip and port and it worked. But when I try connecting from visual studio through sql client I get the following error:

Timeout expired, the timeout period ellapsed prior to the completion of the operation or the server is not responding. Any ideas what might be the problem?

Thank you,


Connectivity problem between MS Access 2007 and SQL Server Express 2005


I have linked my tables, in SQL Server Express 2005, to MS Access 2007 and created a File DSN named LocalSQLServer.dsn. Both the front end (MS Access 2007) and the back end (SQL Express 2005) are on the same machine.

I am trying to check an open connection , and for that I have written a module -- Function CheckConnection(strFileDSNName As String, _

      strDBName As String, Optional strUN As String, Optional strPW As String) As Boolean

strConnect = "Provider=ODBC" & _

";FILE DSN =" & strFileDSNName & _

";Database=" & strDBName


I have created a form with a command button to check the connection, but it is giving the following error

"-2147467259; Method 'Close Connection' of Object'_CurrentProject failed


I am not able to figure it out, if the Connection Parameters that I have taken are correct or not. Please help me in this.



Trying to add a linked server - SQL Server 2008 Express Edition to Access 2007

OS: Vista SP1
SQL Server 2008 Express Edition installed locally
Office 2007 installed locally

I'm trying to add a linked server to a named instance of the SQL Server 2008 that links to an Access 2007 database.

I've spent a couple of hours trying this now - many, many different ways.

Always seem to end up back at Error 7303 - http://msdn.microsoft.com/en-us/library/aa226395(SQL.80).aspx

I've tried all versions of Access database file 2000, 2002-2003, 2007
I've tried to use different drivers -

Office 12 for Access driver

I've tried to use the upsizing wizard from Access - no good, cannot get it to connect to the SQL Server 2008 Express Edition instance

Whichever way I try it I end up with this message/error:

the upsizing wizard only works with microsoft sql server versions 6.50 sp5 or higher

I've read: http://support.microsoft.com/default.aspx/kb/838594 and followed it - same error.

I really want this to just work. Like it should already.

Any suggestions appreciated.

Matt Haddon

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Access 2007 upsizing wizard can't connect to SQL Server 2005 Express


When trying to use the Access 2007 upsizing wizard to move a database to SQL Server 2005 Express, I get the following error message:

Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQ Server Driver][Share
Connection failed:
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server
does not exist or access denied.

I get the same message regardless of whether I configure SQL Server to run as a local system or service.

I am the only user on my Vista 32 PC and am therefore the administrator. As far as I can tell I have sufficient authority since I can start and stop SQL Server.

As a newbie to all this, I can't find any step by step instructions as to how a local copy of SQL Server should be configured to work with the upsizing wizard. In fact I can't even find any Access 2007 help walk-throughs on this upsizing wizard, let alone troubleshooting its error messages.

Any help would be appreciated, as well as links to step by step instructions (which I can't find in the MSDN Library materials).

PS Does MS understand how inadequate and inefficient its built-in documentation really is? Maybe that's what keeps MS Press in business!

Problem uninstalling or reinstalling SQL Server 2008 Express


Hi all, as still a novice user, I am looking for some advise on a problem I am currently having with SQL Server 2008 Express. Thanks in advance.

I had a copy of SQL Server 2008 Express installed on my XP machine. Recently I tried to uninstall it, so that I can install a clean copy of 2008 R2. The uninstallation failed halfway, and subsequently, the SQL server does not start or even allow me to reinstall/uninstall or put in the Microsoft updates meant for the SQL Server 2008 express.

Need advice on how to remove it cleanly, and I do not require any of the database on the current installation. Appreciate any advice.

Below is a copy SQL Server Error Log when I tried to redo the uninstallation:

 Copyright (c) 1988-2008 Microsoft Corporation
 Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2010-09-18 22:34:50.09 Server      (c) 2005 Microsoft Corporation.
2010-09-18 22:34:50.09 Server      All rights reserved.
2010-09-18 22:34:50.09 Server      Server process ID is 4236.
2010-09-18 22:34:50.09 Server      Authentication mode is WINDOWS-ONLY.
2010-09-18 22:34:50.09 Server      Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Se

problem with connecting to local SQL Server 2008 default instance using windows authentication




I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.


2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:]



This us

upgarde accdb (access 2007) files to SQL EXPRESS 2008 R2


Is there a program that I can download that aids in converting an access (accdb) file to sql express 2008 R2?

Thank you


sql server express 2008 problem


We just recently switched from Visual Studio 2008 to Visual Studio 2010. I have an application which uses sql express database locally. The problem is after installing new Visual Studio, I can't access the Sql Server 2008 express. When I try to create a new database, or change the existing one, I get following message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and and that SQL Server is configured to allow remote connections. (provider: TCP Provider, Error 0 - No connection could be made because target machine is actively refused it.)

When I check the sqlexpress windows service, it is stopped. If I try to enable it, it runs for a few seconds and then stops again.

SQL Server Express 2008 vista x64 installation rpc problem

Hi Folks,

I am trying to install SQL Server 2008 Express in a brand new workstation with Vista Business x64 and I am keep on getting this error:

"The following error has ocurred: The RPC server is unavailable..."

At the same time this alert message is displayed:

"Windows has encountered a critical problem and will restart automatically in one minute. Please save your work now"

After a while (~1 minute) the computer reboots, but I am not able to log on as usual. I have to reboot manually the computer in "safe mode" first. 

Trying to reduce the problem I reinstalled the OS and only run the recommended Windows updates. Other than that the computer is in the absolute initial state. (The firewall is not the problem since I already tried it after disabling it)

Any clue !!!!!


SQl Server Express 2008 connecting to instance issue


Hi all,

First time user here.

Need some advice on connecting to a database or instance. Keep getting error message when i try to connect to instance.

Error message when I try to connect to instance refers to veryfying that the instance name is correct and to also check that remote connections are enabled.

I just cant connect at all.

I have enabled TCP/IP in config manager tool for sql server.

I am trying to do this locally.

TCP/IP and shared name pipes is enabled.

How do I verify that the instance name is correct?

And one silly question I think, why dont I have sql browser service in Services?

Any help would be greatly appreciated.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend