Re: Login failed for user (null)

SSPI security assumes that the user credentials are known to the SQL Server.
Setup a login account matching your credentials and give the account rights
to the database you intend to access.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Bob Segrest" <Bob.Segrest@xxxxxxxxx> wrote in message
news:X9CdnUrjC_H2pmTfRVn-vA@xxxxxxxxxxxxxxx
> Hello Everyone,
>
> I am fairly new to the .NET environment and have read all of the previous
> posts
> related to this topic.
>
> I am running Visual Studio .Net on a Windows XP workstation.
>
> My VB.Net application uses a SqlDataAdapter and SqlConnection created by
> the
> Data Adapter Configuration wizard.
>
> I am logged into my workstation using a windows domain account with domain
> administrator priveledges.
>
> My database server is in the same domain.
>
> When I created my connection in the Data Adapter Configuration wizard, I
> pushed
> the Test Connection button and it connected without any problem. If I
> expand
> the connection in the Visual Studio Server Explorer, I can see all of the
> tables in the database without difficulty.
>
> The SQL connect String generated by the wizard is:
> "workstation id=BOBSLAP;packet size=4096;integrated security=SSPI;data
> source=PROJECTDEMO;persist security info=False;initial
> catalog=MPSSampleDatabase"
>
> So, why am I getting a "Login failed for user '(null)'. Reason: Not
> associated
> with a trusted SQL Server connection." error?
>
> Help!!!
>


.