Showing posts with label window. Show all posts
Showing posts with label window. Show all posts

Monday, March 19, 2012

MSDE no access on database objects

I have installed MSDE 2000 A, but I can't edit the database objects (tables,
stored procedures, etc.) in Access 2000. If I try, the window appears only
for a moment.
Any suggestions to solve the problem?
Frank
Hi Frank,
"FAT" <FAT@.discussions.microsoft.com> ha scritto nel messaggio
news:D74106D3-FDF3-4359-9AFA-1DB9A25C809E@.microsoft.com
> I have installed MSDE 2000 A, but I can't edit the database objects
> (tables, stored procedures, etc.) in Access 2000. If I try, the
> window appears only for a moment.
> Any suggestions to solve the problem?
> Frank
I think you've probably better resort on alternate tools.. perhaps Acces
2003, or other 3rd party tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||ehm........
please have a look at http://www.microsoft.com/sql/msde/partners/default.asp
and/or http://www.aspfaq.com/show.asp?id=2442 ... google for others..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Friday, March 9, 2012

MSDE Installation Problem - very urgent

Hi,
I'm facing a strange problem with MSDE. I installed MSDE 2000 in a newly formatted Window 2000 professional Machine with SP2 and IE5.5. I restarted the machine after MSDE installation. Installed my application, which creates a database. Database creation failed, I got this error "Login failed for user 'spsadmin'. Reason: Not associated with a trusted SQL
Server connection.". I tried again, this time I restarted the machine thrice after installing MSDE, then ran my setup. Database installation was through. We can't ask the end user to restart the machine these many times. Any help will be appreciated.
Thanks in advance,
VardhiniHi,
I solved the problem. It was because of the authentication. In the setup the login mode was changed to 2 and it was not getting reflected as the service was running. So from the setup I stopped the service, changed the mode and started the service again, this time database had been created successfully.
Thanks,
Vardhini

MSDE installation problem

Dear all,
I have a installation problem on MSDE and install to window 2000 server,
while installing MSDE, it shows error "1607: Unable to install InstallShield
Scripting Runtime", then rolling back.
Does anyone experienced the same problem?
Thank you very much for any suggestion.
Hi
Are you running the setup whilst logged in as Administrator or a user with
administrator privileges?
Regards
Mike
"kpler" wrote:

> Dear all,
> I have a installation problem on MSDE and install to window 2000 server,
> while installing MSDE, it shows error "1607: Unable to install InstallShield
> Scripting Runtime", then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
|||Already login by administrator account
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Are you running the setup whilst logged in as Administrator or a user with
> administrator privileges?
> Regards
> Mike
> "kpler" wrote:
|||Hi
http://consumer.installshield.com/kb.asp?id=Q108340
Regards
Mike
"kpler" wrote:
[vbcol=seagreen]
> Already login by administrator account
> "Mike Epprecht (SQL MVP)" wrote:
|||Hi
Also:
Make sure you have the Windows Installer Service enabled and set to manual:
Browse to Control Panel > Administrative Tools > Services.
Verify that the Windows Installer Service is enabled.
If the Windows Installer Service is disabled, set it to Manual.
Refer to InstallShield? Knowledge Base Article - Q107094, ERRDOC: Run-time
Error 1607, for more information.
Regards
Mike
"kpler" wrote:
[vbcol=seagreen]
> Already login by administrator account
> "Mike Epprecht (SQL MVP)" wrote:
|||Checked service enabled, and i can install MDAC, but still can't install MSDE.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Also:
> Make sure you have the Windows Installer Service enabled and set to manual:
> Browse to Control Panel > Administrative Tools > Services.
> Verify that the Windows Installer Service is enabled.
> If the Windows Installer Service is disabled, set it to Manual.
> Refer to InstallShield? Knowledge Base Article - Q107094, ERRDOC: Run-time
> Error 1607, for more information.
> Regards
> Mike
> "kpler" wrote:
|||"kpler" wrote:
> Checked service enabled, and i can install MDAC, but still
> can't install MSDE.
> "Mike Epprecht (SQL MVP)" wrote:
> set to manual:
> Services.
> Manual.
> ERRDOC: Run-time
> &nbsp;> > Already login by administrator account
> &nbsp;> >
> &nbsp;> > "Mike Epprecht (SQL MVP)" wrote:
> &nbsp;> >
> &nbsp;&nbsp;> > > Hi
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > Are you running the setup whilst logged in
> as Administrator or a user with
> &nbsp;&nbsp;> > > administrator privileges?
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > Regards
> &nbsp;&nbsp;> > > Mike
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > "kpler" wrote:
> &nbsp;&nbsp;> > >
> &nbsp;&nbsp;> > > > Dear all,
> &nbsp;&nbsp;> > > >
> &nbsp;&nbsp;> > > > I have a installation problem on MSDE and
> install to window 2000 server,
> &nbsp;&nbsp;> > > > while installing MSDE, it shows error
> "1607: Unable to install InstallShield
> &nbsp;&nbsp;> > > > Scripting Runtime", then rolling back.
> &nbsp;&nbsp;> > > >
> &nbsp;&nbsp;> > > > Does anyone experienced the same problem?
> &nbsp;&nbsp;> > > > Thank you very much for any suggestion.
I am currently experiencing the same problems with installing MSDE.
I have checked everything above.
The server that i am trying to install onto is a domain controller.
I have previously installed on servers which are not domain
controllers without problems.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/MSDE-install...ict198031.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=706597
|||"jharwood" wrote:
> I am currently experiencing the same problems with installing
> MSDE.
> I have checked everything above.
> The server that i am trying to install onto is a domain
> controller.
> I have previously installed on servers which are not domain
> controllers without problems.
I have cracked this one on the Domain controller.
See this link:
http://www.sepialine.com/kb/read/?1151
Had to change the PDC to the original domain controller, at some point
in the past we added a DC and that new one took over as the Primary.
Good Luck