sqlConnection not working in VS.net IDE

  • Thread starter Thread starter J. Muenchbourg
  • Start date Start date
J

J. Muenchbourg

Inside VS.net, I'm using the Data Form wizard to creat a DataSet and a
Data Connection to my sql database on my network. VS.net creates this
code after I point it to the correct database:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=xx;Initial Catalog=Northwind;Data
Source=TAURUSSQL;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=PROG1;Use Encryption for Data=False;Tag with
column collation when possible=False

...but after i finish the data form and try to bring up records when i
run the project, i get a prompt/error: "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection." ..when the
same userid has no problem on my other sql connection scripts. I even
tried inserting the password in the above string and i still get the
same exact error.

muench
 
Take the user id and password out of the connection string if you're
using integrated security.

--Mary
 
Thanks Mary for reply. Yes, I started a new connection and made it
Windows Integrated Security, without a User or password designation, and
it still gave me the same error

???????????
 
Have you set up a connection in the Server Explorer using these
credentials? That may be a good way to troubleshoot this thing. Null
user means the server is not seeing a valid user.

--Mary
 
Back
Top