View Single Post
  #2 (permalink)  
Old November 17th, 2008, 03:51 PM
dparsons dparsons is offline
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

There are a handful of things to check on this.

First, in SQL Server Management Studio ( I am assuming SQL2K5+ here ) right click on your database instance, select properties, then go to the connections setting found in the left pane. Make sure the 'Allow remote connections to this Server" is ticked. Go to the Security setting found directly above the Connections setting in the left pane and make sure that SQL Server and Windows Authentication Mode is ticked off under Server Authentication.

Finally, make sure that your connection string is pointed correctly and you have supplied the correct credentials.

hth.
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========