dan nashjy®²‹0Š·œ¢é

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

andrea montanari

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.aspx?scid=kb;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.shtm http://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

dan nashjy®²‹0Š·œ¢é

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

hi Dan,
"Dan Nash" <dan@musoswire.co.uk> ha scritto nel messaggio
news:855B1269-ED3F-4E70-B734-476F38DA4307@microsoft.com...


please have a look at
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237980
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://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