Link to home
Start Free TrialLog in
Avatar of wolf_dik
wolf_dik

asked on

Connection in asp.net

i created physicly sqlDataConnection and sqlDataAdapter.
but on form load when i executed this code:

Dim cn As New SqlClient.SqlConnection()
cn.Open()

I got error message:
Server Error in '/WebApplication15' Application.
--------------------------------------------------------------------------------

Login failed for user 'SYCALE-3UDVADCQ\ASPNET'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Login failed for user 'SYCALE-3UDVADCQ\ASPNET'.

How can i fix it?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

You have to create a LOGIN in the SQLServer for the NT account 'SYCALE-3UDVADCQ\ASPNET', and give this LOGIN the permissions and access to the database (which creates a USER in that (those) database(s).

CHeers
ASKER CERTIFIED SOLUTION
Avatar of naveenkohli
naveenkohli

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wolf_dik
wolf_dik

ASKER

I figured out. I have to use standard account, not window.