bit-tech.net

Go Back   bit-tech.net Forums > Technology > Software

Reply
 
Thread Tools
Old 26th May 2015, 12:41   #1
Pookie
Results May Vary
 
Pookie's Avatar
 
Join Date: May 2010
Location: Newton Scabbot
Posts: 2,630
Pookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming Saiyan
SQL Connection Error *Solved*

Any SQL gurus here? Personally I have very little experiance with SQL so I am feeling a little out of my depth. The exact error on the client machine is.....

Err202: 90 File System Error :: 08001 SQL Server does not exist or access denied. ConnectionOpen (Connect)).

The shortcut to the databse is on a shared drive and the error only appears when a client machine trys to open the shortcut. This happens even with the domain admin credentials! However if I run the shortcut from the share but logged in on the server running SQL (same credentials) the database opens just fine

Any suggestions most welcome
__________________
Unlimited Fibre Broadband 38Inc Per month including line Rental!
http://pulse8broadband.co.uk/fibreoptic-broadband

Last edited by Pookie; 26th May 2015 at 16:18.
Pookie is offline   Reply With Quote
Old 26th May 2015, 14:33   #2
Votick
My CPU's hot but my core runs cold.
 
Votick's Avatar
 
Join Date: May 2009
Location: Cambridgeshire
Posts: 2,140
Votick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming Saiyan
Ports opened correctly?
Votick is offline   Reply With Quote
Old 26th May 2015, 14:49   #3
Pookie
Results May Vary
 
Pookie's Avatar
 
Join Date: May 2010
Location: Newton Scabbot
Posts: 2,630
Pookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming Saiyan
Well the only port I have opened so far is 1433 and 1434. Also just to add that SQL is set to Windows only Authentication if that makes a difference?
__________________
Unlimited Fibre Broadband 38Inc Per month including line Rental!
http://pulse8broadband.co.uk/fibreoptic-broadband
Pookie is offline   Reply With Quote
Old 26th May 2015, 14:57   #4
Votick
My CPU's hot but my core runs cold.
 
Votick's Avatar
 
Join Date: May 2009
Location: Cambridgeshire
Posts: 2,140
Votick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming SaiyanVotick is a Super Spamming Saiyan
Use this on the server.

https://support.microsoft.com/en-us/kb/968872
Votick is offline   Reply With Quote
Old 26th May 2015, 15:14   #5
Pookie
Results May Vary
 
Pookie's Avatar
 
Join Date: May 2010
Location: Newton Scabbot
Posts: 2,630
Pookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming Saiyan
I had to create the Batch file option to get it to run but still no joy
__________________
Unlimited Fibre Broadband 38Inc Per month including line Rental!
http://pulse8broadband.co.uk/fibreoptic-broadband
Pookie is offline   Reply With Quote
Old 26th May 2015, 16:17   #6
Pookie
Results May Vary
 
Pookie's Avatar
 
Join Date: May 2010
Location: Newton Scabbot
Posts: 2,630
Pookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming SaiyanPookie is a Super Spamming Saiyan
Seem to have got it resolved by a fluke. To get it working I had to map the shared folder with a drive letter and and then send a shortcut to the desktop from the mapped drive. I have no idea why it won't run direct from the share but thats computers for you I guess
__________________
Unlimited Fibre Broadband 38Inc Per month including line Rental!
http://pulse8broadband.co.uk/fibreoptic-broadband
Pookie is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 00:24.
Powered by: vBulletin Version 3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.