|
-
March 31st, 2009, 08:25 AM
#16
Re: i have NO IDEA what i'm doing
Hey Nelo!
I got it to work! There were three remaining steps to make the connection happen.
1) Check the port in SQL Server Confugruation manager/Protocols for SBSMONITORING/ TCP/IP /IP Addresses /IPAll - add 1433 to TCP port
2) Tell it to only allow remote connections using TCP/IP and not both Named Pipes.
3) Allow MSSQL 2005 to accept connections in mixed mode not just windows authentication. More can be found here: http://www.codeproject.com/KB/databa...05_remote.aspx
You guys are incredible! Thanks again!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|