Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Access Project/MSDE problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access Project/MSDE problem
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
andymilli2 View Drop Down
Newbie
Newbie


Joined: 23 August 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote andymilli2 Quote  Post ReplyReply Direct Link To This Post Topic: Access Project/MSDE problem
    Posted: 23 August 2004 at 5:17am

I am trying to create an Access 2000 project with an MSDE database.

I have downloaded and extracted MSDE2000 (relA) onto a Win2000 laptop. I have installed a default database with the command:

setup sapwd=mypassword securitymode=sql disablenetworkprotocols=1.

I have opened a new Access project, and got the database wizard. I enter the following details:
SQL Server: NTRL-LAP (the laptop name)
Login ID: sa
Password: mypassword

I get this error message:
Connection failed:
SQLState:'01000'
SQL Server Error:2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

Can anyone suggest what I am doing wrong?

Thanks,

Andy
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2004 at 8:05am

It should be:

setup sapwd=mypassword securitymode=sql disablenetworkprotocols=0
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 23 August 2004 at 4:46pm
well you can leave disablenetworkprotocols at 1 but the you cannot access it from other computers. To fix that though, just go to Start>Programs...>Server Network Utility and add Tcp/IP
Blog | MPG Tracker
Back to Top
andymilli2 View Drop Down
Newbie
Newbie


Joined: 23 August 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote andymilli2 Quote  Post ReplyReply Direct Link To This Post Posted: 24 August 2004 at 11:46am

Thanks. At the moment I only need to use MSDE on the laptop. However, I have uninstalled MSDE and reinstalled it with:

setup sapwd=mypassword securitymode=sql disablenetworkprotocols=0

I still get the same error though.
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2004 at 1:07am
Is it running?
There have been many, many posts made throughout the world...
This was one of them.
Back to Top
andymilli2 View Drop Down
Newbie
Newbie


Joined: 23 August 2004
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote andymilli2 Quote  Post ReplyReply Direct Link To This Post Posted: 31 August 2004 at 6:43am

Originally posted by Bunce Bunce wrote:

Is it running?

It was running, but since then I have uninstalled it, and now I can't install it at all. The installer dialogue opens for a few seconds then closes again.

I am now trying to install msde on a desktop. On this machine, the installation gets to the end, then a pop informs me that Exception Package has no digital signature, and the installation fails and rolls back. The log shows this:

2004-08-31 11:27:10.06 server    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
 Dec 17 2002 14:22:05
 Copyright (c) 1988-2003 Microsoft Corporation
 Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)

2004-08-31 11:27:10.12 server    Copyright (C) 1988-2002 Microsoft Corporation.
2004-08-31 11:27:10.12 server    All rights reserved.
2004-08-31 11:27:10.12 server    Server Process ID is 1508.
2004-08-31 11:27:10.12 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2004-08-31 11:27:10.14 server    SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-08-31 11:27:10.33 server    SQL Server configured for thread mode processing.
2004-08-31 11:27:10.34 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-08-31 11:27:10.59 spid3     Warning ******************
2004-08-31 11:27:10.59 spid3     SQL Server started in single user mode. Updates allowed to system catalogs.
2004-08-31 11:27:10.68 spid3     Starting up database 'master'.
2004-08-31 11:27:11.45 server    Using 'SSNETLIB.DLL' version '8.0.766'.
2004-08-31 11:27:11.45 spid5     Starting up database 'model'.
2004-08-31 11:27:11.89 spid3     Server name is 'ANDREW'.
2004-08-31 11:27:11.89 spid3     Skipping startup of clean database id 5
2004-08-31 11:27:11.92 spid3     Skipping startup of clean database id 6
2004-08-31 11:27:11.93 spid3     Starting up database 'msdb'.
2004-08-31 11:27:12.32 server    SQL server listening on 192.168.2.105: 1433.
2004-08-31 11:27:12.32 server    SQL server listening on 127.0.0.1: 1433.
2004-08-31 11:27:12.62 spid5     Clearing tempdb database.
2004-08-31 11:27:13.66 spid5     Starting up database 'tempdb'.
2004-08-31 11:27:13.80 spid3     Recovery complete.
2004-08-31 11:27:13.80 spid3     SQL global counter collection task is created.
2004-08-31 11:27:13.83 spid3     Warning: override, autoexec procedures skipped.
2004-08-31 11:27:14.67 server    SQL server listening on TCP, Shared Memory, Named Pipes.
2004-08-31 11:27:14.67 server    SQL Server is ready for client connections
2004-08-31 11:27:23.21 spid3     SQL Server is terminating due to 'stop' request from Service Control Manager.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.