cant upsize from access to MSDE 2000 (urgentish :p)

Hi guys
Having a problem with MSDE. I'm trying to upsize an Access database to MSDE.
I'm fairly new to all this SQLServer malarkey, so bear with me.
I've setup MSDE with the default Instance name (what is the default instance
name?) and a good SAPWD. Used to the /qb+ switch to install from the command
line - if I don't, the installation just seems to die half way through.
Now then, when I try and upsize my access db, i tell it to "create a new
database" and then it gives me a new dialog with Which server, login,
password etc. I'm not entirely sure what to put in here though. What's the
LoginID? I haven't created one (as far as i know).
I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
keep getting the same error (18452), telling me that login failed for user.
Reason: not associated with a trusted SQL server connection.
What am I doing wrong? Have I missed something? Any help greatly appreciated!
Cheers
Dan
hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> Hi guys
> Having a problem with MSDE. I'm trying to upsize an Access database to
MSDE.
> I'm fairly new to all this SQLServer malarkey, so bear with me.
> I've setup MSDE with the default Instance name (what is the default
instance
> name?) and a good SAPWD. Used to the /qb+ switch to install from the
command
> line - if I don't, the installation just seems to die half way through.
please add the
/L*v "c:\...\Log.txt"
commandline parameter to the setup.exe bootstrap installer, in order to log
the installation (quite 2mb textual log) for troubleshooting...
did nt understand if you succesfully installed MSDE or not.. =;-D

> Now then, when I try and upsize my access db, i tell it to "create a new
> database" and then it gives me a new dialog with Which server, login,
> password etc. I'm not entirely sure what to put in here though. What's the
> LoginID? I haven't created one (as far as i know).
> I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
> keep getting the same error (18452), telling me that login failed for
user.
> Reason: not associated with a trusted SQL server connection.
> What am I doing wrong? Have I missed something? Any help greatly
appreciated!
here seems you succesfully got it... MSDE is installed..
MSDE installs by default only granting WindowsNT (trusted) authentication...
you have to manually change this setting..
please have a look at
http://support.microsoft.com/default...b;en-us;285097 for further
info on how to modify this behaviour both at install time and later...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hiya
Thanks for, I had a look at the article and did what it suggested with the
Registry. That's prevented it from asking me for a username and password.
However, when I do it now.. I'm getting an "overflow" error. Any ideas on
that one?
Thanks again for your help so far!
Cheers
Dan
"Andrea Montanari" wrote:

> hi Dan,
> "Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
> news:83F5ED5F-0F4A-43BC-AE40-1A57B907F9F1@.microsoft.com...
> MSDE.
> instance
> command
> please add the
> /L*v "c:\...\Log.txt"
> commandline parameter to the setup.exe bootstrap installer, in order to log
> the installation (quite 2mb textual log) for troubleshooting...
> did nt understand if you succesfully installed MSDE or not.. =;-D
> user.
> appreciated!
> here seems you succesfully got it... MSDE is installed..
> MSDE installs by default only granting WindowsNT (trusted) authentication...
> you have to manually change this setting..
> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 for further
> info on how to modify this behaviour both at install time and later...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Dan,
"Dan Nash" <dan@.musoswire.co.uk> ha scritto nel messaggio
news:855B1269-ED3F-4E70-B734-476F38DA4307@.microsoft.com...
> Hiya
> Thanks for, I had a look at the article and did what it suggested with the
> Registry. That's prevented it from asking me for a username and password.
> However, when I do it now.. I'm getting an "overflow" error. Any ideas on
> that one?
please have a look at
http://support.microsoft.com/default...;EN-US;Q237980
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply