Cannot connect to SQL Server 2008 thru Access Upsizing Wizard

[smsmail]

Hello,

I have just installed SQL Server 2008 Express. I will be upsizing from ACCESS 2007. I want to use the Access Upsizing Wizard to upsize to SQL Server 2008, however I cannot connect to it thru Access.

What did I miss, when I installed SQL Server 2008?

Thank you for your help!

 

[sparkbyte]

did you tell SQL 2008 to use the default instance or create a new instance?

The default is to create a new instance.

You will probably have to connect using (on the Select or enter a server name:

YourWorkstationName\SQLExpress





Thanks

John Fuhrman

 

[fredericofonseca]

http://sergeb.com/blog/post/Upsizing-MS-Access-2007-database-to-SQL-Server-2008.aspx

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[smsmail]

Thanks for your assistance. I was able to connect to sql server. The blog is very helpful.