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!!

Quote:

---

Originally Posted by savesheep

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!!

---

Nah!!! You're the incredible one! From zero programming experience to working all that out is not easy. I don't know you if you would make a good programmer/developer but you sure are an excellent problem solver and researcher :)

Congratulations ! :wave:
Its always great when it is possible to help someone and the help in the end is acknowledged too. :D