|
|
You're in the
sql server msde
group:What the defaut login when creating db using Access?
sql server msde:
Ok I'm just having my first play with MSDE on my laptop. I've installed
it and created a new ADP in Access which has created the SQL Server db in C:\Program Files\Microsoft SQL Server\MSSQL\Data\TempData.mdf I've downloaded the web admin tool and also DbaMgr2k but neither of them will let me connect. The web admin just hangs, the DbaMge2k gives me the following error "login failed for user 'grant' Reason: not associated with trusted sql server connection" So my question is what login and password were saved with the db when I created it through Access??? I'm running Windows XP Pro Once I can get one of these admin utils to work, the first thing I want to do is move the db to a more approporate location than in programme files! I assume both these utils will allow me to do this? Thanks in advance Grant
hi,
[quoted text, click to view] techworks@clear.net.nz wrote: > Ok I'm just having my first play with MSDE on my laptop. I've > installed it and created a new ADP in Access which has created the > SQL Server db in C:\Program Files\Microsoft SQL > Server\MSSQL\Data\TempData.mdf > > I've downloaded the web admin tool and also DbaMgr2k but neither of > them will let me connect. The web admin just hangs, the DbaMge2k gives > me the following error > > "login failed for user 'grant' Reason: not associated with trusted sql > server connection" > > So my question is what login and password were saved with the db when > I created it through Access??? > > I'm running Windows XP Pro > > Once I can get one of these admin utils to work, the first thing I > want to do is move the db to a more approporate location than in > programme files! I assume both these utils will allow me to do this? MSDE installs by default allowing only trusted connections (WinNT authentication) for security reasons, so that standard SQL Server authenticated connections (providing user and pwd credentials) are not allowed... you can modify this behaviour both at install time or later, at "run time" as described in http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 in order to "move" a db to a new location, you have to connect to the MSDE instance as a sysadmin member and detach it (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp .... DbaMgr2k provides a graphical way to do it)... then you can move it wherever you want, but ..\Program Files\Microsoft SQL Server\MSSQL\Data\ is the default path for SQL Server databases... anyway, you can do it, but please remember that for "secuirty" reasons the folder containing your database should be as "secure" as possible... only MSDE (actually the account running it, and obviously OS/Domain administrators) should be available to access it... that's to say... do not place it on a local shared folder :D -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Andrea Thanks for the explanation.. but I'm still confused
I have a number of MS Access apps that have linked tables to SQL Server tables on a number of Client sites. I'm trying to create a number of MSDE db's on my laptop so I can have alternate server/db's on my laptop to relink my Access apps SQL tables and run the apps off-site. I dont want all the SQL Server security crap on my MSDE DB's, I want them as unsecure as I can get them. Having to deal with unnecessary security on ly laptop just costs me time I cant bill! So back to my problem, what exactly do I need to do to get DbaMgr2k to work with my MSDE db's? Do i need to change the default login mode to SQL by editing the register as outlined in http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 Will your DbaMgr2k not work with trusted connection? Interestingly, when I installed MSDE it didnt give me any options, just installed with no prompts and no advice. I didnt even think it had installed and tried installing again and got errors saying coulnt install. It was only after two reboots that the MSDE icon in the taskbar showed up. Good old Bill Gates flakky XP I assume Thanks in advance. Grant [quoted text, click to view] Andrea Montanari wrote:
> MSDE installs by default allowing only trusted connections (WinNT > authentication) for security reasons, so that standard SQL Server > authenticated connections (providing user and pwd credentials) are not > allowed... you can modify this behaviour both at install time or later, at > "run time" as described in > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 > > in order to "move" a db to a new location, you have to connect to the MSDE > instance as a sysadmin member and detach it > (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp > ... DbaMgr2k provides a graphical way to do it)... then you can move it > wherever you want, but ..\Program Files\Microsoft SQL Server\MSSQL\Data\ is > the default path for SQL Server databases... anyway, you can do it, but > please remember that for "secuirty" reasons the folder containing your > database should be as "secure" as possible... only MSDE (actually the > account running it, and obviously OS/Domain administrators) should be > available to access it... that's to say... do not place it on a local shared > folder :D > -- > Andrea Montanari (Microsoft MVP - SQL Server) > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual > interface) > --------- remove DMO to reply
Andrea, I've got it working now. As usual with Microsoft installs, All
I had to do was uninstall and reinstall 3-4 times with different setting untill it worked. Thanks Grant
hi Grant,
[quoted text, click to view] techworks@clear.net.nz wrote: here I do not understand you... if you use MSDE as storage engine for you > I have a number of MS Access apps that have linked tables to SQL > Server tables on a number of Client sites. > > I'm trying to create a number of MSDE db's on my laptop so I can have > alternate server/db's on my laptop to relink my Access apps SQL tables > and run the apps off-site. > Access prjs, they should always reference your server or the "master" company server.. and al your client "sites" have to reference their local MSDE instance or their "master" company server... but I probably did not understand your meaning... apologise.. [quoted text, click to view] > I dont want all the SQL Server security crap on my MSDE DB's, I want > them as unsecure as I can get them. Having to deal with unnecessary > security on ly laptop just costs me time I cant bill! actually you have to deal with it, as it is a core part of SQL Server architecture, so you have to spend enought time to understand and learn it... [quoted text, click to view] > So back to my problem, what exactly do I need to do to get DbaMgr2k to > work with my MSDE db's? > > Do i need to change the default login mode to SQL by editing the > register as outlined in > http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 Will > your DbaMgr2k not work with trusted connection? you can... just specify you want a trusted connection in the connection window... you can use both, it's up to you... but you still have to understand how it works.. try having a look at http://www.developer.com/tech/article.php/721441 ,http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_05bt.asp , http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec03.mspx SQL Server IS NOT Jet, and you have to deal with it as long as you are not using "User Instance" features available via .Net in the new Framework 2.0 and SQLExpress 2005 [quoted text, click to view] > Interestingly, when I installed MSDE it didnt give me any options, > just installed with no prompts and no advice. I didnt even think it > had installed and tried installing again and got errors saying coulnt > install. It was only after two reboots that the MSDE icon in the > taskbar showed up. > > Good old Bill Gates flakky XP I assume MSDE installs by default disabling network protocols (disabling remote connections), disabling mixed security (only allowing trusted connections)... this is all documented in the readme file (you read them, did you? :D) http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/ReadmeMSDE2000A.htm#_3464461_security_considerations_for_msde_d3jb , and XP has nothing to do with this (this time only :D) -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |