problem with connection string in app.config

getnitha

Member
Joined
Jul 16, 2007
Messages
14
Programming Experience
1-3
Hi,

I am developing a vb.net 2005 windows application.For that i wrote connection string in app.config as

HTML:
<add name="MyCnString" connectionString="packet size=4096;integrated security=True;data
 source=Nitha;persist security info=False;initial catalog=payroll" providerName="System.Data.SqlClient"/>

and calling this connection in all the forms as

VB.NET:
connString = ConfigurationManager.ConnectionStrings.("MyCnString").ConnectionString
        Conn.ConnectionString = connString

This works perfectly fine in my system.Then i made a setup using Visual Studio and installed in other systems in our local network.Exe is not wrking in other systems.Its showing like

Login Failed for user :Nitha/Guest

Can anyone plse pointout me the problem on this and how to solve this

Regards
Nitha
 
Last edited by a moderator:
Hello, Im guessing the computer you're trying on can't figure out what/where the Datasource Nitha is.

And I see you got integrated security=True so the current Windows account credentials are used for authentication.. Could also be the problem? Your loged in account doesnt have access to do what you want it to do.
 
Hi,
U install the database and appliaction in diffrent pc? if yes u have to create remote connection if not please create guest account (give permission for guest) then only it will work,
 
Back
Top