Help needed in establishing connection

I recently migrated SQL Server 2005 which we use for our internet site and other internal applications, to it's own server. SQL used to be on the development PC. However now I am having security issues.

I keep getting an error message when I try to connect to the server from the development PC that the SQL server is not set up or does not allow remote connections. I have made sure that ASPNET is a user. I have also run aspnet_regsql to set up the internet users database.

What other security features do I need to check? I am more of a VB developer than a SQL admin so any help is appreciated.

FYI - This is a small network that does not run any form of Windows Server. I am using IIS 5.1. TCP/IP and Named Pipes is enabled.

Thanks

Additional information - I tried to telnet using the server/instance 1433 and I get this message:

Could not open connection to the host, on port 1433: Connect failed

2nd update - I turned OFF the firewall (Windows) to the SQL server and now it seems to work. I did add port 1433 as an exception so I am not sure what that is not working. And I also really do not feel comfortable in turning off the firewall. However, now it is working. I know it is not an ideal situation for SQL Server, but the machine it is running on is using XP with SP2.

|||

Take a look and see if any of the answers in this thread help you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=268328&SiteID=1

Thanks
Laurentiu

help me pleeease, im so confused

ok i have a mysql database setup
i also have an image gallery setup on my site where people can upload their own pics after registering

in another section of my site i have a message forum where people can register to post messages
now heres the problem

what i wanna do is so that when someone signs up in the image gallery section they can use the same usernam and password to sign in to the forum and vise versa
i have no idea how to do this, its really bugging me :(

pleeeease helpThe solution depends on the complexity of your requirement.

If you do not require separate privelages for individual pages of the web site, then create a single users table.|||how do i create a single user table?
im so sorry but im an absoloute beginner and have noo idea what that even means|||Simplified,

Create table users
(
username varchar2(15),
password varchar2(15)
);|||where do i type that?|||The MySQL Console.|||lol where is that?

maybe i should say this

i got the forum script from www.phpbb.com and the image script from http://www.4homepages.de

if that helps in anyway, i just uploaded them on to my subdomains and linked them to the mysql database i created in my hosting control panel
in the control panel theres no option for any console of any sort, all i can do is create new users and edit passwords|||If you need to execute DML statements then you need access to a "console" or "interface" that can accept the statements and pass them to the DBMS.

As an alternative consider editing the source code for both scripts, such that both access the same users table.|||i downloaded a program and am now editing the tables
i found this

4images_users

inside that i found these values:

column_____________type____________null

user_name varchar(255) no
user_password varchor(255) no9

do i change these? to the stuff u wrote up there?

thats for the image gallery
for the chat forum it has these settings phpbb_users

column __________type______________ null
username varchar(25) no
user_password varchar(32) no

please help me|||Script A - Select * from userA
Script B - Select * from userB

userA
---
username
password

userB
---
username
password

users_AB
---
username
password

A temporary solution may be,

Drop table userA;
Drop table userB;

Create view userA as select * from users_AB;
Create view userB as select * from users_AB;

I would recommend not using the scripts, instead write your own code specifically for your requirements. Furthermore the database tables can be designed according to your specifications.|||thats greek to me
forget it i give up :(

thanks very much for all ur help anyway, i appreciate it very much