Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

[Frederik]

Hi,

First sorry for my english I'm french.

I developped a web app that work good under XPDEVSERVER machine (iis5) and SqlServerDevelo pper Edition.

I get problem when I moved this app to an other web server (IIS5.0) win2000. Actualy, I only have problem to connect with the Database that she still hosted on the the XPDEVSERVER mahcine . I get this error msg when I ask a aspx page that is connected to the database:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

Here is my connection string :

strConn = "data source=DEVSERVE R;Provider=SQLO LEDB; initial catalog=pickup; integrated security=SSPI;p ersist security info=False;work station id=DEVSERVER;pa cket size=4096"

I also tried to use a local Sql Server acount with pwd and i got the same error message.data source=DEVSERVE R;User ID=SqlUser;Pass word=SqlUserPwd

I also tried data source=DEVSERVE R\aspnet

* I haven't find any sample or solution that show how to connect ASPX page to a remote SQL Server that.
It is suppose to be an frequently used architeture no?
* I added the ASPNET user on the database.

Thanks for your help

as*******@hotma il.com
Frederik

[Ken Cox [Microsoft MVP]]

Salut Frederik,

If you're connecting to to a remote SQL server (via IP address), try this:

oSQLConn.Connec tionString = "Network Library=DBMSSOC N;" & _
"Data Source=xxx.xxx. xxx.xxx,1433;" & _
"Initial Catalog=mySQLSe rverDBName;" & _
"User ID=myUsername;" & _
"Password=myPas sword"
Where:
- "Network Library=DBMSSOC N" tells SqlConnection to use TCP/IP (KB Q238949)
- xxx.xxx.xxx.xxx is an IP address.
- 1433 is the default port number for SQL Server. (KB Q269882 and Q287932)
- You can also add "Encrypt=ye s" for encryption

There are other connection strings here:

http://www.able-consulting.com/dotne...anagedProvider

See also:

http://support.microsoft.com/default...b;en-us;316989

Ken
Toronto
"Frederik" <as*******@hotm ail.com> wrote in message
news:ep******** ******@TK2MSFTN GP10.phx.gbl...
Hi,

First sorry for my english I'm french.

I developped a web app that work good under XPDEVSERVER machine (iis5) and
SqlServerDevelo pper Edition.

I get problem when I moved this app to an other web server (IIS5.0) win2000.
Actualy, I only have problem to connect with the Database that she still
hosted on the the XPDEVSERVER mahcine . I get this error msg when I ask a
aspx page that is connected to the database:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection

Here is my connection string :

strConn = "data source=DEVSERVE R;Provider=SQLO LEDB; initial
catalog=pickup; integrated security=SSPI;p ersist security
info=False;work station id=DEVSERVER;pa cket size=4096"

I also tried to use a local Sql Server acount with pwd and i got the same
error message.data source=DEVSERVE R;User ID=SqlUser;Pass word=SqlUserPwd

I also tried data source=DEVSERVE R\aspnet

* I haven't find any sample or solution that show how to connect ASPX page
to a remote SQL Server that.
It is suppose to be an frequently used architeture no?
* I added the ASPNET user on the database.

Thanks for your help

as*******@hotma il.com
Frederik

[Jeff]

I believe that the reason for the problem in the first place is the
"integrated security=SSPI" in the connection string. This tells SQL to use
domain credentials to connect you to the database; it ignores any user and
password settings you pass. I would hazard to guess that your web box and
your database are not in the same domain - in this case, SQL can't get the
credentials and you get the null user message. At least this is when I've
seen it.

Jeff
"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:Ob******** ******@TK2MSFTN GP10.phx.gbl...

Salut Frederik,

If you're connecting to to a remote SQL server (via IP address), try this:

oSQLConn.Connec tionString = "Network Library=DBMSSOC N;" & _
"Data Source=xxx.xxx. xxx.xxx,1433;" & _
"Initial Catalog=mySQLSe rverDBName;" & _
"User ID=myUsername;" & _
"Password=myPas sword"
Where:
- "Network Library=DBMSSOC N" tells SqlConnection to use TCP/IP (KB Q238949) - xxx.xxx.xxx.xxx is an IP address.
- 1433 is the default port number for SQL Server. (KB Q269882 and Q287932) - You can also add "Encrypt=ye s" for encryption

There are other connection strings here:

http://www.able-consulting.com/dotne...anagedProvider
See also:

http://support.microsoft.com/default...b;en-us;316989

Ken
Toronto
"Frederik" <as*******@hotm ail.com> wrote in message
news:ep******** ******@TK2MSFTN GP10.phx.gbl...
Hi,

First sorry for my english I'm french.

I developped a web app that work good under XPDEVSERVER machine (iis5) and
SqlServerDevelo pper Edition.

I get problem when I moved this app to an other web server (IIS5.0) win2000. Actualy, I only have problem to connect with the Database that she still
hosted on the the XPDEVSERVER mahcine . I get this error msg when I ask a
aspx page that is connected to the database:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection

Here is my connection string :

strConn = "data source=DEVSERVE R;Provider=SQLO LEDB; initial
catalog=pickup; integrated security=SSPI;p ersist security
info=False;work station id=DEVSERVER;pa cket size=4096"

I also tried to use a local Sql Server acount with pwd and i got the same
error message.data source=DEVSERVE R;User ID=SqlUser;Pass word=SqlUserPwd

I also tried data source=DEVSERVE R\aspnet

* I haven't find any sample or solution that show how to connect ASPX page
to a remote SQL Server that.
It is suppose to be an frequently used architeture no?
* I added the ASPNET user on the database.

Thanks for your help

as*******@hotma il.com
Frederik