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