Hi,
this seems to be a normal behaviour when you use a named instance of SQL
server, as you do (local\AXMSDE001).
When you need to disconnect from the network while working with Axapta just
stop Axapta, stop the SQL service, disconnect from network, wait some 10 - 15
seconds and then start SQL again. Now everything should work.
The reason is that the connection to the *named* instance seems to use the IP
address to connect - and this one will change after e.g. disconnecting from a
DHCP service.
hth Tobias
________________________________
Von: Axapta-Knowledge-Village@yahoogroups.com im Auftrag von jetjockey.geo
Gesendet: Di 07.02.2006 22:02
An: Axapta-Knowledge-Village@yahoogroups.com
Betreff: [Axapta-Knowledge-Village] Re: SQL Server timeout
Thanks David, unfortunately that didn't help.
I've made an additional discovery. If I'm connected to my work
network, it behaves normally. Once I disconnect, I get these errors.
It could be some sort of name resolution problem. Axapta does seem to
think that the DB is on the network. It's not, it's on the same
machine and always has been. Any ideas at all apreciated because, at
present, Axapta is useless to me.
--- In Axapta-Knowledge-Village@yahoogroups.com, "David Casas"
<[EMAIL PROTECTED]> wrote:
>
> It´s a resolution name problem.
> Try with the ip, and if you can modify de hosts file adding the
local name with the ip.
>
> Regards.
>
> David
> ----- Original Message -----
> From: jetjockey.geo
> To: Axapta-Knowledge-Village@yahoogroups.com
> Sent: Tuesday, January 31, 2006 10:27 AM
> Subject: [Axapta-Knowledge-Village] SQL Server timeout
>
>
>
> My Axapta 3 demo was working fine. It started throwing connection
> errors occassionally. They have been increasing over the last week or
> so and now I find I can't log in at all as the timeout occurs before
> the login dlg is shown. The error is:
>
> --------------
> SQL has reported the following error:
>
> [Microsoft][ODBC SQL Server Driver] Timeout expired. Connect
> information was
>
Userid=[bmssa],Database=[AXDB],Server=[(local)\AXMSDE001],DSN=[AXMSDE001],
> Other=[]
>
> You may refer to the error log file for further details.
>
> Retry the operation
> --------------
>
> Previously, a retry would get things going again, sometimes after
> several attempts. Now, nothing works. I've done some reading around
> regarding SQL Server timeouts and tried reinstalling both Axapta and
> the Desktop SQL Engine numerous times without success. The log files
> and system event log contain nothing that I can relate to this.
>
> The one thing I have noticed is that the AXMSDE001 datasource doesn't
> connect if the local domain is used. If I change it to use
> "garys-laptop\AXMSDE001" (the machine name) it connects. The error
> shows that Axapta is trying to use local. What I don't understand is
> why local fails. Changing the datasource to use "garys-laptop" doesn't
> stop Axapta failing, even though the datasource connects.
>
> As always, any ideas are appreciated.
>
> Thanks,
>
> Gary.
>
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
>
>
>
------------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "Axapta-Knowledge-Village" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
------------------------------------------------------------------------------
>
>
>
> [Non-text portions of this message have been removed]
>
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
