connection error

Hello I have this error when I run my report.
. An error has occurred during report processing.
(rsProcessingAborted) Get Online Help
o Cannot create a connection to data source myDB.
(rsErrorOpeningConnection) Get Online Help
 Login failed for user myDB.
What is problem? I am testing my ODBC connection it seem
fine.Are you trying to use integrated security and the credentials your using
need to make more than 1 hop? If so you're running into a limitation in
windows integrated auth. To resolve it either deploy kerberos or you can
try changing the data source credentials to stored and see if it works after
that.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:2cc5301c46913$fdfae570$a301280a@.phx.gbl...
> Hello I have this error when I run my report.
> . An error has occurred during report processing.
> (rsProcessingAborted) Get Online Help
> o Cannot create a connection to data source myDB.
> (rsErrorOpeningConnection) Get Online Help
>  Login failed for user myDB.
> What is problem? I am testing my ODBC connection it seem
> fine.
>

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