Connection of SQL server 2000 with ASP in IIS6.0

Dear Friend,

Please tell me how to connect sql server and ASP in IIS 6.0.Earlier in IIS 5 I have connected in SQL server with ASP with DSN connection,the same global.asa file is not working in IIS6.0.But Asp pages are not giving any error ,but they are no just taking value from Database.I mean server connection is not establishing..

Could you please help in matter

Thank you

Graceson MAthewIf you are not recieving an error, I highly doubt it is your connection string.

connection error

Hi guys, my asp.net web page was working fine on my laptop. Until i transferred it into my friend's.. an error msg popped out. My SQL Northwind database was been copied over but still there seems to be a problem with the connection, can any one help me?
Personal guess: You are using an sa username/password in the connection string, and the other server you are connecting to is not set up for SQL security, only Windows security.
Show the connection string you are using (with any passwords obscured, of course).
|||

SqlConnection conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind");

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT * FROM tblDoor";

conn.Open();
//how to find out what user id to use?

|||Do you have SQL Server or MSDE? If SQL Server, then you should be able to use Enterprise Manager to try and figure out what the SA password is, as well as determining whether SQL Server security is enabled. If you have Enterprise manager, right click the SQL Server and select Porperties. In the properties window, go to the Security tab make sure authentication is set to SQL Server and Windows.|||oh it is working already, thanks man!

Connecting to the server

Hi everyone, my friend is creating an online game and he needs help with something, he made the formatting for the configuration like this:
"AccountDbIP"="example.com"
"AccountDbID"="ABC"
"AccountDbPwd"="123"
"AccountDbName"="AccountDB"

But his dedicated server host is running windows 2003 web edition and it only allows mssql express. And he cannot connect just by using the ip, he needs to use ip/SQLEXPRESS, can anyone tell us how to connect to the server database using the IP only?

Thanks and best regards to all,
Bob R

for remote connections the format is "[ServerName or IP][\Named Instance][,Port#]"

for local connections (game is running on the same box as the SQL Server) the format is "[.][\Named Instance]"

Each of these methods uses whats called a different protocol and there is actually a few more including Named Pipes but I am assuming you do not wish to use that protocol.

D

|||

As far as I know, you must provide the Instance Name when you are connecting to a Named Instance. This is a requirement of SQL Server, not just SQL Express. The only way you could connect using only the IP would be if your friends Hosting company installed SQL Express as the Default Instance rather than as a Named Instance.

I'm not sure I understand why your friend can not use the Named Instance. As you've indicated, just use IP\SQLEXPRESS in your connection string. What is the problem with this?

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Bob, please update thread/mark an answer.

thanks,

Derek