Connecting to SQL Server on another machine

Hello everyone. I'm having a really rough time with this so I figured I would ask. I haven't had much input on MSDN Forums.

Here's my thread though if you'd like to see it:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/16a46463-67d3-4ec6-9c5f-74d73a87201b

Basically, I have a SQL Server instance on our server here at the office that we use for another program currently. I would like to connect to it to use it for a new program that we are going to be using. However, no matter what I do I cannot seem to connect to it. I've tried all of the connection strings on the site. I did finally get the database attached by creating a brand new one on the database and then scripting the database structure. But I can't connect to it. I'm not sure what more to try, but I would really love to begin using this and was hoping someone here might know better than I and be able to tell me what I might be doing wrong.

Thanks Again,
Matt

0 answers