Win a copy of Learning Java by Building Android Games this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

Microsoft SQL  RSS feed

 
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Okay now I am asking this because no one in the building has a clue.
I have a stored proceedure that connects to another database using OPENDATASOURCE. Now it had been working for 5 months and all of the sudden stopped. Now it is showing the following: Server: Msg 18, Level 16, State 1, Line 1
Now I checked with the Firewall people and they did not chop off the ports like they did to me in the past. The same query can run from my development box with no problems.
Msg 18 mean nothing, the logs in both database boxes says nothing! I have no clue what is going on! Once in awhil I get a message that says access denied. The user name and password have not changed.
If anyone has any opinions on what could be wrong (I know do not use a MS product) please state your mind!
Eric
 
ranger
Sheriff
Posts: 17314
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well there seems to be no Msg 18 at all at MSDN web site. However, even though it was a different message number, is it possible the database, data, or index has been corrupted. That could be a good explaination, but a guess on my part.
Mark
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am going to try to bounce the box tonight and see if that corrects the problem! I which I could just go and manually boot the box with my foot!
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!