SQL blocking access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL blocking access

Author

Topic

Bleve
Starting Member

5 Posts

Posted - 2011-07-29 : 18:26:54

Hi everyone

I have a problem with a new database i'm running, it seems strange to me but, here it goes.

I've installed a program on my server called IBos and than on 27 client machines, some in one location and others were in remote locations, using hamachi to connect to the data base. All are working great. Until I picked up my laptop and went to a different location from where it was setup, meaning leaving the building and going to my house for example. When i get there I can't connect through the program to my database, but I can get to it from a mapped drive. I need to be able to access this from my laptop from anywhere.

If anybody has an idea that would be helpful thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-29 : 18:34:42

You'll need to provide the error as a starting point.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Bleve
Starting Member

5 Posts

Posted - 2011-07-29 : 19:04:03

here is the error

Error occured when trying to get login information, [.Net SqlClient Data Provider: Openconnection(Server Name=KSEVER;Database Name=vmxSystem):GetDbInfo()] Timeout expired. the timeout period elapsed prior to completion of the operation or the server is not responding

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-29 : 19:08:46

Increase your connection timeout in your configuration. So there's a command timeout and a connection timeout. Your network is apparently too slow from home to connect before it times out.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Bleve
Starting Member

5 Posts

Posted - 2011-08-02 : 10:01:18

at my house i already have it on my desktop computer and other laptop, with no connection problems , its only when i take the laptop to an alternate location from where it was setup at, that it wont connect. At the main office where I IT at there are multiple computers with IBos on them, then i setup up 5 locations elsewhere, I also setup my house computers for access, the problem is as soon as I take a computer from its orginal location of setup, it wont work at any of the other locations.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-02 : 12:54:28

So did you change your connection timeout or not?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Bleve
Starting Member

5 Posts

Posted - 2011-08-03 : 15:44:14

Yes i changed the timeout from 600 to 0 and i'm still having the same problem and error message i will include the IBOS Wordpad txt dat file

[SQL Server]
Server Name=KSERVER

Port=1433
Trusted Connection=No
Local Connection=No

System DB Name=vmxSystem

[Common]
Agency Name=Kindersley

[Default]
Global Config Path=C:\Program Files (x86)\iBOS Tools\Settings\GlobalConfig
Enabled Background Color=White
Enabled Font Color=Black
Read Only Font Color=Black
Disable Auto Update=Yes
Update Path=
Allow Multi Instances=Yes

[DVEnterprise]
Max Records In Grid=250000
Max Records In Chart=50000
Show Chart Toolbar=Yes
Application Path=C:\Program Files (x86)\iBOS Tools\DV Enterprise
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Enterprise\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Enterprise\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Enterprise\LocalConfig
SideBar Images Path=C:\Program Files (x86)\iBOS Tools\DV Enterprise\SideBarImages
Picklist Images Path=C:\Program Files (x86)\iBOS Tools\DV Enterprise\PicklistImages
Export Path=C:\Program Files (x86)\iBOS Tools\Export\DVEnterprise
Setup Info FileName=DVEntSetupInfo.Dat
DVEnterprise DB Name=vmxDataViewerEnterprise

[DVDesigner]
Vemax Use=Yes
Application Path=C:\Program Files (x86)\iBOS Tools\DV Designer Enterprise
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Designer Enterprise\UserConfig
UserTemp Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Designer Enterprise\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DV Designer Enterprise\LocalConfig
Setup Info FileName=DVDesignerEnterpriseSetupInfo.Dat
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\DVDesigner\UserTemp
Export Path=C:\Program Files (x86)\iBOS Tools\Export\DV Designer Enterprise
Import Path=C:\Program Files (x86)\iBOS Tools\Import\DV Designer Enterprise
Can Modify Max Records=Yes

[DVEnterprise_UpdateDB]
Application Path=C:\Program Files (x86)\iBOS Tools\PPT Update DB
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DVEnterprise_UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\DVEnterprise_UpdateDB\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\DVEnterprise_UpdateDB\LocalConfig

[WRR]
Application Path=C:\Program Files (x86)\iBOS Tools\WRR
Reports Path=C:\Program Files (x86)\iBOS Tools\WRR\Reports
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR\LocalConfig
Setup Info FileName=WRRSetupInfo.dat
Export Path=C:\Program Files (x86)\iBOS Tools\Export\WRR
Documents Path=I:Synchronize Server Name=unknown
Synchronize System DB Name=vmxSystem
Synchronize Server Is Master=Yes

[WRR_CP]
Application Path=C:\Program Files (x86)\iBOS Tools\WRR_CP
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_CP\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_CP\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_CP\LocalConfig
Setup Info FileName=WRRCPSetupInfo.dat
Export Path=C:\Program Files (x86)\iBOS Tools\Export\WRR_CP

[WRR_UpdateDB]
Application Path=C:\Program Files (x86)\iBOS Tools\WRR Update DB
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_UpdateDB\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRR_UpdateDB\LocalConfig

[MMS]
Application Path=C:\Program Files (x86)\iBOS Tools\MMS
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS\LocalConfig
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS\UserTemp
Import Path=C:\Program Files (x86)\iBOS Tools\Import\MMS
Export Path=C:\Program Files (x86)\iBOS Tools\Export\MMS
System Path=C:\Program Files (x86)\iBOS Tools\MMS\System
Support Path=C:\Program Files (x86)\iBOS Tools\MMS\Support
Reports Path=C:\Program Files (x86)\iBOS Tools\MMS\Reports
Default Documents Path=C:\Program Files (x86)\iBOS Tools\MMS\Documents
Setup Info Filename=MMSSetupInfo.dat

[MMS_DataTransfer]
Application Path=C:\Program Files (x86)\iBOS Tools\MMS\Utilities\MMS Data Transfer
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS\LocalConfig
Import Path=C:\Clients\SHT\Import\MMS
Export Path=C:\Program Files (x86)\iBOS Tools\Export\MMS
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS_DataTransfer\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS_DataTransfer\UserTemp

[MMS_UpdateDB]
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS_UpdateDB\LocalConfig
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS_UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\MMS_UpdateDB\UserTemp
Application Path=C:\Program Files (x86)\iBOS Tools\MMS Update DB

[AMPS]
Application Path=C:\Program Files (x86)\iBOS Tools\AMPS
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS\LocalConfig
Setup Info FileName=AMPSSetupInfo.dat
Export Path=C:\Program Files (x86)\iBOS Tools\Export\AMPS

[AMPS_CP]
Application Path=C:\Program Files (x86)\iBOS Tools\AMPS CP
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_CP\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_CP\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_CP\LocalConfig
Setup Info FileName=AMPSCPSetupInfo.dat
Export Path=C:\Program Files (x86)\iBOS Tools\Export\AMPS_CP

[AMPS_UpdateDB]
Application Path=C:\Program Files (x86)\iBOS Tools\AMPS Update DB
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_UpdateDB\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AMPS_UpdateDB\LocalConfig

[BackupDB]
Show All Databases=Yes
Enable Restore=Yes
BackupDBFolder=C:\Program Files (x86)\iBOS Tools\BackupDBFolder
RestoreDBFolder=C:\Program Files (x86)\iBOS Tools\RestoreDBFolder

[WRM]
Application Path=C:\Program Files (x86)\iBOS Tools\WRM
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRM\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\WRM\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\WRM\LocalConfig
Setup Info FileName=WRMSetupInfo.Dat

[AREntDesigner]
Application Path=C:\Program Files (x86)\iBOS Tools\AREntDes
Reports Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Reports
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntDesigner\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntDesigner\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntDesigner\LocalConfig
Import Path=C:\Program Files (x86)\iBOS Tools\Import\ArEntDesigner
Export Path=C:\Program Files (x86)\iBOS Tools\Export\ArEntDesigner
System Path=C:\Program Files (x86)\iBOS Tools\AREntDes\System
Utilities Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Utilities
Aliasing Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Aliasing
Scripts Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Scripts
Enable System ID=No
Use Aliasing=No
Application Caption=Asset Register Enterprise
Application Caption Abbr=AR Ent
Help File=C:\Program Files (x86)\iBOS Tools\AREntDes\AREntDesigner.chm
Can Design Forms=Yes
Can Open Configuration=Yes
Can Import Form Data=Yes
Use Global Info Server=Yes
Use Global Info Login=Yes
Documents Source Path=C:\Program Files (x86)\iBOS Tools\Documents\AREntDesigner\Source
Images Source Path=C:\Program Files (x86)\iBOS Tools\Images\AREntDesigner\Source
Documents Destination Path=C:\Program Files (x86)\iBOS Tools\Documents\AREntDesigner
Images Destination Path=C:\Program Files (x86)\iBOS Tools\Images\AREntDesigner
Enable Sytem ID=No
Setup Info Filename=AREntDesignerSetupInfo.dat

[AREntViewer]
Application Path=C:\Program Files (x86)\iBOS Tools\AREntDes
Reports Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Reports
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntViewer\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntViewer\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREntViewer\LocalConfig
Import Path=C:\Program Files (x86)\iBOS Tools\Import\ArEntViewer
Export Path=C:\Program Files (x86)\iBOS Tools\Export\ArEntViewer
System Path=C:\Program Files (x86)\iBOS Tools\AREntDes\System
Utilities Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Utilities
Aliasing Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Aliasing
Scripts Path=C:\Program Files (x86)\iBOS Tools\AREntDes\Scripts
Enable Sytem ID=No
Use Aliasing=No
Application Caption=Asset Register Enterprise
Application Caption Abbr=AR Ent
Can Open Configuration=Yes
Can Import Form Data=Yes
Can Import Configuration=Yes
Can Import Folders=Yes
Use Global Info Server=Yes
Use Global Info Login=Yes
Documents Source Path=C:\Program Files (x86)\iBOS Tools\Documents\AREntViewer\Source
Images Source Path=C:\Program Files (x86)\iBOS Tools\Images\AREntViewer\Source
Documents Destination Path=C:\Program Files (x86)\iBOS Tools\Documents\AREntViewer
Images Destination Path=C:\Program Files (x86)\iBOS Tools\Images\AREntViewer
Can Maintain Users=No
Enable System ID=No
Setup Info Filename=AREntViewerSetupInfo.dat

[ConnectionInfoEditor]
Application Path=C:\Program Files (x86)\iBOS Tools\Connection Info Editor
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\ConnectionInfoEditor\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\ConnectionInfoEditor\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\ConnectionInfoEditor\LocalConfig
Setup Info FileName=ConnectionInfoEditorSetupInfo.dat
Export Path=C:\Program Files (x86)\iBOS Tools\Export\ConnectionInfoEditor
Help File=C:\Program Files (x86)\iBOS Tools\Connection Info Editor\ConnectionInfoEditorManual.pdf

[PPT]
Setup Info FileName=PPTSetupInfo.dat
Application Path=C:\Program Files (x86)\iBOS Tools\PPT SQL
System Path=C:\Program Files (x86)\iBOS Tools\PPT SQL\System
Utilities Path=C:\Program Files (x86)\iBOS Tools\PPT SQL\Utilities
Reports Path=C:\Program Files (x86)\iBOS Tools\PPT SQL\Reports
Aliasing Path=C:\Program Files (x86)\iBOS Tools\PPT SQL\Aliasing
Scripts Path=C:\Program Files (x86)\iBOS Tools\PPT SQL\Scripts
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT SQL\LocalConfig
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT SQL\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT SQL\UserTemp
Import Path=C:\Program Files (x86)\iBOS Tools\Export\PPT SQL
Export Path=C:\Program Files (x86)\iBOS Tools\Export\PPT SQL
Help File=C:\Program Files (x86)\iBOS Tools\PPT SQL\PPT Combined.chm
Application Caption=Performance Prediction Technology
Application Caption Abbr=PPT
Use Global Info Server=Yes
Use Global Info Login=Yes
Allow Multi Instances=Yes

[PPT_UpdateDB]
Application Path=C:\Program Files (x86)\iBOS Tools\PPT Update DB
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT UpdateDB\LocalConfig
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\PPT UpdateDB\UserTemp

[AREnterprise_UpdateDB]
Application Path=C:\Program Files (x86)\iBOS Tools\AR Enterprise Update DB
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREnterprise_UpdateDB\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\AREnterprise_UpdateDB\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\AREnterprise_UpdateDB\LocalConfig

[UploadToVEMAX]
Application Path=C:\Program Files (x86)\iBOS Tools\Upload To VEMAX
User Config Path=C:\Program Files (x86)\iBOS Tools\Settings\Upload To VEMAX\UserConfig
User Temp Path=C:\Program Files (x86)\iBOS Tools\Settings\Upload To VEMAX\UserTemp
Local Config Path=C:\Program Files (x86)\iBOS Tools\Settings\Upload To VEMAX\LocalConfig
Setup Info FileName=UploadToVEMAXSetupInfo.dat

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-03 : 15:48:57

I do not see a connection timeout in that output.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Bleve
Starting Member

5 Posts

Posted - 2011-08-04 : 18:55:15

how do I increase the timeouts, i've changed the server timeout as i said from 600 seconds to 0, but not sure, what elese I need to do , can you help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-04 : 18:57:36

It's a client-side timeout and not a server timeout. You'll need to contact the vendor to see how the connection timeout can be changed.

If it were just SSMS, we could help. But you are using a third-party tool, so you'll need to contact the vendor as your config file doesn't appear to provide that option.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources