question about connection error

[chapm4]

I am trying to connect to sql server on my local machine (will connect to remotel later. I get the following error:

Microsoft SQL Native Client (0x80040E4D)
Invalid connection string attribute

Here is the connection string:
<%set cn=server.createobject("ADODB.connection")
cn.open "PROVIDER=SQLNCLI;SERVER=myServerName;DATABASE=Lennox;UID=customerSurvey;PWD="
set r=server.createobject("adodb.recordset")
%>

Can someone help me?

 

[bborissov]

You can't have a user w/o password. Try with windows authentication:

   cn.open "PROVIDER=SQLNCLI;SERVER=myServerName;DATABASE=Lennox;Trusted_Connection=yes"

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[chapm4]

Thanks for the reply,

I am getting this error now:

Microsoft SQL Native Client (0x80040E4D)
Login failed for user 'LENNOX\IUSR_TECH-83F90408F5'.

The IUSR name is the server name I was using when I first setup my machine and sql server. I have since changed the machine name because I wanted the test bed setup with the name of the client machine that I eventually will move this to.

So the question is how do I change the IUSR to reflect the new machine name?

And also if the client will be connecting to this from another network is the Trusted_Connection the way to go for security purposes?