Previous Thread

7/27/2006 3:03:01 PM    upsize wizard can't find SQLEXPRESS
I'm using Access 2003 and SQL Server 2005 Express. I want to convert my .MDB 
 
file into a SQL server database. I used the upsizing wizard. It gave me an 
 
error saying: 
 
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist 
 
or access denied. 
 
I have administrator priveledges. Why can't it find the local SQLEXPRESS 
 
server? Does the .MDB file have to be in the SQLEXPRESS folder first? 
 
I looked at the MS knowledge base for answers but it didn't seem to be 
 
referring to my exact problem.



7/27/2006 5:21:29 PM    Re: upsize wizard can't find SQLEXPRESS
Did you connect to the correct SQL Server  instance ? The default 
 
instalation installs  it as SQLEXPRESS instance  if I'm not mistaken. So you 
 
have to conenct to servername\sqlexpress and not just to servername. 
 
Gil Lapid Shafriri 
 
Program Manager 
 
SQL Server Migration Assistant 
 
Microsoft 
 
http://www.microsoft.com/sql/solutions/migration/default.mspx 
 
"CoolMama" <CoolMama@discussions.microsoft.com> wrote in message 
 
news:2AB28C2B-7048-47BD-9C49-343F2DA28B43@microsoft.com...