• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Microsoft SQL

 
author
Posts: 15385
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 15385
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
reply
    Bookmark Topic Watch Topic
  • New Topic