Connecting to SQL Server DB

[John Spiegel]

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server and
suspect that it's a problem on that side. I've installed the SQL Server
developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection( "server=localho st;database=pub ;uid=sa;pwd=adm in" );

try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying to
connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC).
The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K , which
indicates to me that the sa/admin login is correct (which is what Iset at
installation).

Any ideas?

TIA,

John

[Aaron Bertrand - MVP]

> DSN=SQLServer1;

How is this DSN=SQLServer1 configured? Does it use the name "localhost" or
does it use an actual computer name, or IP address? Are you sure it's set
for port 1433?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[Eric Sabine]

Cross-posting is bad.

Is "localhost" and "SQLServer1 " actually the same machine? If not, is your
authentication on localhost "windows only"? Try some these connection
strings

"server=yourIPa ddressHere;data base=pubs;uid=s a;pwd=admin;"
"server=yourIPa ddressHere;data base=pubs;integ rated security=sspi;"
"server=localho st;database=pub s;integrated security=sspi;"
"server=SQLServ er1;database=pu bs;integrated security=sspi;"
"server=(local) ;database=pubs; uid=sa;pwd=admi n;"
"server=(local) ;database=pubs; integrated security=sspi;"
"server=.;datab ase=pubs;uid=sa ;pwd=admin;"
"server=.;datab ase=pubs;integr ated security=sspi;"

hth
Eric

"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:eX******** *******@TK2MSFT NGP11.phx.gbl.. .

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server and
suspect that it's a problem on that side. I've installed the SQL Server
developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection( "server=localho st;database=pub ;uid=sa;pwd=adm in" );
try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying to connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC).
The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K , which indicates to me that the sa/admin login is correct (which is what Iset at
installation).

Any ideas?

TIA,

John

[John Spiegel]

Thanks, Aaron. And sorry in advance for my newbie ignorance...

The DSN is a system DSN, configured as connecting to server "J2K" (which is
the name of the computer as well as of the SQL Server), using the TCP/IP
network library set to dynamically determine port (but, yes, the default
port is 1433). I can't find any reference to localhost in the DSN.

BTW, I don't think the ADO connection is attempting to use the DSN (but
could be COMPLETELY misinterpreting things).

- John

The default port is 1433.
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:#S******** ******@tk2msftn gp13.phx.gbl...

DSN=SQLServer1;
How is this DSN=SQLServer1 configured? Does it use the name "localhost"

or does it use an actual computer name, or IP address? Are you sure it's set
for port 1433?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[Aaron Bertrand - MVP]

> The DSN is a system DSN, configured as connecting to server "J2K"

So try

new SqlConnection( "server=J2K;dat abase=pub;uid=s a;pwd=admin" );

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

(which is

the name of the computer as well as of the SQL Server), using the TCP/IP
network library set to dynamically determine port (but, yes, the default
port is 1433). I can't find any reference to localhost in the DSN.

BTW, I don't think the ADO connection is attempting to use the DSN (but
could be COMPLETELY misinterpreting things).

- John

The default port is 1433.
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:#S******** ******@tk2msftn gp13.phx.gbl...

DSN=SQLServer1;

How is this DSN=SQLServer1 configured? Does it use the name "localhost"

or

does it use an actual computer name, or IP address? Are you sure it's set for port 1433?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[Paul M]

Hi,

If it's SQL2K, then you've probably not got the server in Mixed mode. Go
into enterprise manager and right click on the server (should be the same
name as the computer unless you've changed it) and go into the properties
page.

Go to the security page and you'll find an Authentication option. Select
SQL server and Windows. Important note here...You must make sure you change
the SA password to a nice long password with lots of _£$@} characters in,
otherwise, if you have broadband you'll be hacked to pieces.

You need to have the database server in mixed mode if you want to use forms
authentication (sounds like you do). Otherwise you might want to consider
integrated security, in which case you don't use uid and pwd in your
connection string and you ignore everything I've written above.

Have fun....welcome to the DBA's world!

P
"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:eX******** *******@TK2MSFT NGP11.phx.gbl.. .

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server and
suspect that it's a problem on that side. I've installed the SQL Server
developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection( "server=localho st;database=pub ;uid=sa;pwd=adm in" );
try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying to connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC).
The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K , which indicates to me that the sa/admin login is correct (which is what Iset at
installation).

Any ideas?

TIA,

John

[John Spiegel]

Thanks to all of you (Aaron, Mklapp, Eric & Paul) for jumping in. So far,
I've still had no luck.

This is a list of the connections I've tried so far:

server=localhos t;database=pubs ;uid=jspiegel;p wd=abc;
server=J2K;data base=pubs;uid=j spiegel;pwd=abc ;
server=J2K;data base=pubs;uid=s a;pwd=admin;Tru sted_Connection =Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in;Trusted_Conn ection=Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in
server=J2K;data base=pubs;uid=s a;pwd=admin
server=localhos t;database=pubs ;Trusted_Connec tion=Yes
server=<IPaddre ss>;database=pu bs;uid=sa;pwd=a dmin;
server=<IPaddre ss>;database=pu bs;integrated security=sspi;
server=localhos t;database=pubs ;integrated security=sspi;
server=SQLServe r1;database=pub s;integrated security=sspi;
server=(local); database=pubs;u id=sa;pwd=admin ;
server=(local); database=pubs;i ntegrated security=sspi;
server=.;databa se=pubs;uid=sa; pwd=admin;
server=.;databa se=pubs;integra ted security=sspi;

The uid=jspiegel;pw d=abc correspond both to a domain login and a user I've
added to SQL Server.

While I am logged into the domain, all of this is happening (or trying to
happen) on my local machine (Win2K Pro, SQL Server 2000 and .NET framework
1.1).

While I have toggled it a few times, most of my attempts have been with SQL
Server and Windows set as the authentication.

I had installed MSDE quite a while ago and then the SQL Server trial
version. Yesterday, I tried to wipe the slate clean and reinstall MSSQL2K
fresh. Probably doesn't answer anything but I'm grasping.

Thanks again,

John

BTW, I think I was spoiled years ago working in a single environment with
native DB. This interconnection stuff drives me batty!

"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:eX******** *****@TK2MSFTNG P11.phx.gbl...

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server and
suspect that it's a problem on that side. I've installed the SQL Server
developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection( "server=localho st;database=pub ;uid=sa;pwd=adm in" );
try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying to connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC).
The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K , which indicates to me that the sa/admin login is correct (which is what Iset at
installation).

Any ideas?

TIA,

John

[Aaron Bertrand - MVP]

Have you been to www.connectionstrings.com?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:uL******** ******@TK2MSFTN GP09.phx.gbl...

Thanks to all of you (Aaron, Mklapp, Eric & Paul) for jumping in. So far,
I've still had no luck.

This is a list of the connections I've tried so far:

server=localhos t;database=pubs ;uid=jspiegel;p wd=abc;
server=J2K;data base=pubs;uid=j spiegel;pwd=abc ;
server=J2K;data base=pubs;uid=s a;pwd=admin;Tru sted_Connection =Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in;Trusted_Conn ection=Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in
server=J2K;data base=pubs;uid=s a;pwd=admin
server=localhos t;database=pubs ;Trusted_Connec tion=Yes
server=<IPaddre ss>;database=pu bs;uid=sa;pwd=a dmin;
server=<IPaddre ss>;database=pu bs;integrated security=sspi;
server=localhos t;database=pubs ;integrated security=sspi;
server=SQLServe r1;database=pub s;integrated security=sspi;
server=(local); database=pubs;u id=sa;pwd=admin ;
server=(local); database=pubs;i ntegrated security=sspi;
server=.;databa se=pubs;uid=sa; pwd=admin;
server=.;databa se=pubs;integra ted security=sspi;

The uid=jspiegel;pw d=abc correspond both to a domain login and a user I've
added to SQL Server.

While I am logged into the domain, all of this is happening (or trying to
happen) on my local machine (Win2K Pro, SQL Server 2000 and .NET framework
1.1).

While I have toggled it a few times, most of my attempts have been with SQL Server and Windows set as the authentication.

I had installed MSDE quite a while ago and then the SQL Server trial
version. Yesterday, I tried to wipe the slate clean and reinstall MSSQL2K
fresh. Probably doesn't answer anything but I'm grasping.

Thanks again,

John

BTW, I think I was spoiled years ago working in a single environment with
native DB. This interconnection stuff drives me batty!

"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:eX******** *****@TK2MSFTNG P11.phx.gbl...

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server and suspect that it's a problem on that side. I've installed the SQL Server
developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection( "server=localho st;database=pub ;uid=sa;pwd=adm in" );

try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying to

connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL

Server

connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC).
The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K ,

which

indicates to me that the sa/admin login is correct (which is what Iset

at installation).

Any ideas?

TIA,

John

[John Spiegel]

Hey Eric,

Aside from the connection issue...

Cross-posting is bad.

I've seen this dozens of times (part of why 90+% of the time I don't do it).
But I've never really understood what the problem is--particularly in a case
where there are multiple technologies thrown in the mix. Is it a resource
issue for the newserver or confusion/clutter issue for the readers? Just
trying to understand.

Sorry for being bad,

John

[John Spiegel]

Heading there now!

"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:OT******** ******@TK2MSFTN GP12.phx.gbl...

Have you been to www.connectionstrings.com?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message
news:uL******** ******@TK2MSFTN GP09.phx.gbl...

Thanks to all of you (Aaron, Mklapp, Eric & Paul) for jumping in. So far,

I've still had no luck.

This is a list of the connections I've tried so far:

server=localhos t;database=pubs ;uid=jspiegel;p wd=abc;
server=J2K;data base=pubs;uid=j spiegel;pwd=abc ;
server=J2K;data base=pubs;uid=s a;pwd=admin;Tru sted_Connection =Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in;Trusted_Conn ection=Yes
server=localhos t;database=pubs ;uid=sa;pwd=adm in
server=J2K;data base=pubs;uid=s a;pwd=admin
server=localhos t;database=pubs ;Trusted_Connec tion=Yes
server=<IPaddre ss>;database=pu bs;uid=sa;pwd=a dmin;
server=<IPaddre ss>;database=pu bs;integrated security=sspi;
server=localhos t;database=pubs ;integrated security=sspi;
server=SQLServe r1;database=pub s;integrated security=sspi;
server=(local); database=pubs;u id=sa;pwd=admin ;
server=(local); database=pubs;i ntegrated security=sspi;
server=.;databa se=pubs;uid=sa; pwd=admin;
server=.;databa se=pubs;integra ted security=sspi;

The uid=jspiegel;pw d=abc correspond both to a domain login and a user I've added to SQL Server.

While I am logged into the domain, all of this is happening (or trying to happen) on my local machine (Win2K Pro, SQL Server 2000 and .NET framework 1.1).

While I have toggled it a few times, most of my attempts have been with

SQL

Server and Windows set as the authentication.

I had installed MSDE quite a while ago and then the SQL Server trial
version. Yesterday, I tried to wipe the slate clean and reinstall MSSQL2K fresh. Probably doesn't answer anything but I'm grasping.

Thanks again,

John

BTW, I think I was spoiled years ago working in a single environment with native DB. This interconnection stuff drives me batty!

"John Spiegel" <js******@YETAN OTHERSPAMHATERc-comld.com> wrote in message news:eX******** *****@TK2MSFTNG P11.phx.gbl...

Hi all,

I'm missing something, probably stupid, on connecting to a SQL Server
database from an aspx file. I haven't really done much w/ SQL Server

and suspect that it's a problem on that side. I've installed the SQL Server developer edition locally and do have a pubs database.

The connection I'm attempting is the following:

SqlConnection objConnection =
new SqlConnection(

"server=localho st;database=pub ;uid=sa;pwd=adm in" );

try
{
// Open the connection.
objConnection.O pen();
/*snip*/
}
catch( Exception ex )
{
ErrorMessage.Te xt = ex.Message.ToSt ring();
}

The exception caught indicates (whether or not 'sa' is the uid I'm trying

to

connect with):
Login failed for user 'sa'. Reason: Not associated with a trusted SQL

Server

connection. (w/Windows-only Authentication) or
Login failed for user 'sa'. (Windows and SQL Server Authentication)

I have been able to create a connection through VFP (though using ODBC). The connection string it creates is:
DSN=SQLServer1; UID=sa;PWD=admi n;APP=Microsoft Visual FoxPro;WSID=J2K ,

which

indicates to me that the sa/admin login is correct (which is what Iset

at installation).

Any ideas?

TIA,

John