Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Microsoft SQL

 
Eric Pascarello
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
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
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