Connection string user ID changes to (null)

From: JH Higgins (JHHiggins_at_discussions.microsoft.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 10:25:06 -0800

I've built a distributed application with a windows form in visual
studio.net. The windows form connects to a SQL server instance running on
windows server 2000 and appends records to a SQL database using ado.net.

If I log in and run the app my self the connection object works just fine.
If other users log in no connection to the SQL data provider can be
established. System Error message is "User ID ('null') is not a valid SQL
login"

My connect string = Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=GSRRC;Data
Source=DMSSURG1;uid=vbdotnet1;pwd=passvbdotnet1;Packet Size=4096

Why is the connection string correct for me but get's corrupted if others
are logged in?

Any help greatly appreciated

JH Higgins

Relevant Pages

  • Generating Combo Box items from an SQL Databse
    ... >From my windows form, I opened a connection to a SQL database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Generating Combo Box items from an SQL Databse
    ... > Dim oconn As New SqlConnection ... > ' you don't really need the connectionstring for this, ... >> From my windows form, I opened a connection to a SQL database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: returning data from SQL
    ... but it seems you read out the caption instead of the value wich can be ... > I have a windows form that has a group box having 2 check boxes. ... > bound to a table in a SQL database (I configured the SQL connection, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: returning data from SQL
    ... Michel ... >>> posting it in the right place? ... >>> I have a windows form that has a group box having 2 check boxes. ... >>> bound to a table in a SQL database (I configured the SQL connection, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: returning data from SQL
    ... > posting it in the right place? ... > I have a windows form that has a group box having 2 check boxes. ... > bound to a table in a SQL database (I configured the SQL connection, ... Although both you can only bind to a boolean column, ...
    (microsoft.public.dotnet.languages.vb)