Member Avatar for functionalCode

I am working on an application and I have SQL server 2008 running on my local machine when I start the application everything works fine, but when I moved my application to my laptop the program connects to sql server, but it cannot find any of my stored procedures when connecting remotely. I am not sure if it is something in may code or SQL server. Any way to fix this?

Thanks

  • 2 Contributors
  • 4 Replies
  • 98 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by functionalCode
Member Avatar for sknake

It sounds like you're connecting to the wrong database on the server or you're using a different schema. Try to do "exec dbo.sproc" on your laptop as you're probably an admin on your desktop and thus it was created under the dbo schema. If you're already calling the sproc with dbo then it must be something else.

Member Avatar for functionalCode

I got it working. My laptop isn't on the domain, but my computer is. So I added a user name to sql server and used a sql server authentication instead of windows authentication. It seems to work now.

Member Avatar for sknake

That works :)

Please mark this thread as solved as you have found a solution to your issue and good luck!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.